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

'cluster by' should not be needed for a bucketed table

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Blocker
    • Resolution: Duplicate
    • 3.0.0
    • None
    • None
    • None

    Description

      given

      CREATE TABLE over10k_orc_bucketed(t tinyint,
                 si smallint,
                 i int,
                 b bigint,
                 f float,
                 d double,
                 bo boolean,
                 s string,
                 ts timestamp,
                 `dec` decimal(4,2),
                 bin binary) CLUSTERED BY(si) INTO 4 BUCKETS STORED AS ORC;
      

      insert into over10k_orc_bucketed select * from over10k

      produces 1 data file (bucket 0).  It should produce 4 based on input data.
      

      insert into over10k_orc_bucketed select * from over10k cluster by si

      
      

      does the right thing.

      acid_vectorization_original.q has the full script (HIVE-17458)

      Attachments

        Issue Links

          Activity

            People

              djaiswal Deepak Jaiswal
              ekoifman Eugene Koifman
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: