Hive
  1. Hive
  2. HIVE-3649

Hive List Bucketing - enhance DDL to specify list bucketing table

    Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.10.0
    • Fix Version/s: 0.10.0
    • Component/s: None
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      We need to differ normal skewed table from list bucketing table. we use an optional parameter "store as DIRECTORIES"

      4 main cases:
      1. create table <name> skewed by .. on .. stored as directories;
      2. alter table <name> skewed by .. on .. stored as directories;
      3. alter table <name> not skewed;
      4. alter table <name> not stored as directories;

      details in https://cwiki.apache.org/confluence/display/Hive/ListBucketing

      1. HIVE-3649.patch.9
        112 kB
        Gang Tim Liu
      2. HIVE-3649.patch.8
        78 kB
        Gang Tim Liu
      3. HIVE-3649.patch.7
        75 kB
        Gang Tim Liu
      4. HIVE-3649.patch.6
        77 kB
        Gang Tim Liu
      5. HIVE-3649.patch.4
        79 kB
        Gang Tim Liu

        Issue Links

          Activity

          Gang Tim Liu created issue -
          Gang Tim Liu made changes -
          Field Original Value New Value
          Link This issue relates to HIVE-3073 [ HIVE-3073 ]
          Gang Tim Liu made changes -
          Summary Hive List Bucketing - specify list bucketing table Hive List Bucketing - enhance DDL to specify list bucketing table
          Affects Version/s 0.10.0 [ 12320745 ]
          Gang Tim Liu made changes -
          Link This issue relates to HIVE-3026 [ HIVE-3026 ]
          Gang Tim Liu made changes -
          Description We need to differ normal skewed table from list bucketing table. we use an optional parameter "store as DIRECTORIES"

          create table <T> (schema) skewed by (keys) on ('c1', 'c2') [store as DIRECTORIES];

          details in

          https://cwiki.apache.org/confluence/display/Hive/ListBucketing

          We need to differ normal skewed table from list bucketing table. we use an optional parameter "store as DIRECTORIES"

          create table <T> (schema) skewed by (keys) on ('c1', 'c2') [store as DIRECTORIES];

          details in

          https://cwiki.apache.org/confluence/display/Hive/ListBucketing

          *

          Gang Tim Liu made changes -
          Description We need to differ normal skewed table from list bucketing table. we use an optional parameter "store as DIRECTORIES"

          create table <T> (schema) skewed by (keys) on ('c1', 'c2') [store as DIRECTORIES];

          details in

          https://cwiki.apache.org/confluence/display/Hive/ListBucketing

          *

          We need to differ normal skewed table from list bucketing table. we use an optional parameter "store as DIRECTORIES"

          create table <T> (schema) skewed by (keys) on ('c1', 'c2') [store as DIRECTORIES];

          details in

          https://cwiki.apache.org/confluence/display/Hive/ListBucketing



          Gang Tim Liu made changes -
          Description We need to differ normal skewed table from list bucketing table. we use an optional parameter "store as DIRECTORIES"

          create table <T> (schema) skewed by (keys) on ('c1', 'c2') [store as DIRECTORIES];

          details in

          https://cwiki.apache.org/confluence/display/Hive/ListBucketing



          We need to differ normal skewed table from list bucketing table. we use an optional parameter "store as DIRECTORIES"

          create table <T> (schema) skewed by (keys) on ('c1', 'c2') [store as DIRECTORIES];

          details in https://cwiki.apache.org/confluence/display/Hive/ListBucketing

          4 main cases:
          1. create table <name> skewed by .. on .. stored as directories;
          2. alter table <name> skewed by .. on .. stored as directories;
          3. alter table <name> not skewed;
          4. alter table <name> not stored as directories;


          Gang Tim Liu made changes -
          Description We need to differ normal skewed table from list bucketing table. we use an optional parameter "store as DIRECTORIES"

          create table <T> (schema) skewed by (keys) on ('c1', 'c2') [store as DIRECTORIES];

          details in https://cwiki.apache.org/confluence/display/Hive/ListBucketing

          4 main cases:
          1. create table <name> skewed by .. on .. stored as directories;
          2. alter table <name> skewed by .. on .. stored as directories;
          3. alter table <name> not skewed;
          4. alter table <name> not stored as directories;


          We need to differ normal skewed table from list bucketing table. we use an optional parameter "store as DIRECTORIES"

          4 main cases:
          1. create table <name> skewed by .. on .. stored as directories;
          2. alter table <name> skewed by .. on .. stored as directories;
          3. alter table <name> not skewed;
          4. alter table <name> not stored as directories;


          details in https://cwiki.apache.org/confluence/display/Hive/ListBucketing
          Gang Tim Liu made changes -
          Attachment HIVE-3649.patch.4 [ 12552428 ]
          Gang Tim Liu made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Fix Version/s 0.10.0 [ 12320745 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Gang Tim Liu made changes -
          Attachment HIVE-3649.patch.6 [ 12552517 ]
          Gang Tim Liu made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Gang Tim Liu made changes -
          Attachment HIVE-3649.patch.7 [ 12552553 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Gang Tim Liu made changes -
          Link This issue relates to HIVE-3690 [ HIVE-3690 ]
          Gang Tim Liu made changes -
          Attachment HIVE-3649.patch.8 [ 12552625 ]
          Gang Tim Liu made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Gang Tim Liu made changes -
          Attachment HIVE-3649.patch.9 [ 12552669 ]
          Gang Tim Liu made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Hadoop Flags Reviewed [ 10343 ]
          Resolution Fixed [ 1 ]
          Gang Tim Liu made changes -
          Assignee Gang Tim Liu [ gangtimliu ]
          Ashutosh Chauhan made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Lefty Leverenz made changes -
          Link This issue is related to HIVE-3072 [ HIVE-3072 ]

            People

            • Assignee:
              Gang Tim Liu
              Reporter:
              Gang Tim Liu
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development