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

Support date type for column stats autogather

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 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

          People

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

            Dates

              Created:
              Updated:
              Resolved: