Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-8395 CBO: enable by default
  3. HIVE-8654

CBO: parquet_ctas test returns incorrect results

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • None
    • 0.14.0
    • CBO
    • None

    Description

      I am investigating right now.
      The issue is specific to Parquet:

      set hive.cbo.enable=true;
      drop table staging;
      drop table parquet_ctas;
      
      create table staging (key int, value string) stored as textfile;
      insert into table staging select * from src order by key limit 10;
      select * from staging;
      
      create table parquet_ctas stored as parquet as select * from staging;
      select * from parquet_ctas;
      create table orc_ctas stored as orc as select * from staging;
      select * from orc_ctas;
      create table txt_ctas stored as textfile as select * from staging;
      select * from txt_ctas;
      

      The parquet query returns all NULLs with CBO on.

      Attachments

        1. HIVE-8654.patch
          1 kB
          Sergey Shelukhin

        Activity

          People

            sershe Sergey Shelukhin
            sershe Sergey Shelukhin
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: