Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-11160 Auto-gather column stats
  3. HIVE-20498

Support date type for column stats autogather

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersConvert to IssueMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 4.0.0, 4.0.0-alpha-1
    • Statistics
    • None

    Description

      set hive.stats.column.autogather=true;
      create table dx2(a int,b int,d date);
      
      explain insert into dx2 values(1,1,'2011-11-11');
      -- no compute_stats calls
      
      insert into dx2 values(1,1,'2011-11-11');
      insert into dx2 values(1,1,'2001-11-11');
      
      explain analyze table dx2 compute statistics for columns;
      -- as expected; has compute_stats calls
      analyze table dx2 compute statistics for columns;
      -- runs ok
      desc formatted dx2 d;
      -- looks good
      

      Attachments

        1. HIVE-20498.02.patch
          34 kB
          Zoltan Haindrich
        2. HIVE-20498.03.patch
          474 kB
          Zoltan Haindrich
        3. HIVE-20498.04.patch
          475 kB
          Zoltan Haindrich
        4. HIVE-20498.1.patch
          18 kB
          Daniel Voros

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            kgyrtkirk Zoltan Haindrich Assign to me
            kgyrtkirk Zoltan Haindrich
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment