Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-12381

analyze table compute stats for table with special characters will wipe out all the table stats

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      repo:

      drop table `t//`;
      create table `t//` (col string);
      insert into `t//` values(1);
      insert into `t//` values(null);
      analyze table `t//` compute statistics;
      explain select * from `t//`;
      

      The result

      Statistics: Num rows: 1 Data size: 5 Basic stats: COMPLETE Column stats: NONE
      

      is wrong

      Attachments

        1. HIVE-12381.01.patch
          6 kB
          Pengcheng Xiong
        2. HIVE-12381.02.patch
          13 kB
          Pengcheng Xiong
        3. HIVE-12381.03.patch
          6 kB
          Pengcheng Xiong
        4. HIVE-12381.04.patch
          22 kB
          Pengcheng Xiong
        5. HIVE-12381.05.patch
          73 kB
          Pengcheng Xiong

        Issue Links

          Activity

            People

              pxiong Pengcheng Xiong
              pxiong Pengcheng Xiong
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: