[ 
https://issues.apache.org/jira/browse/HIVE-3649?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Gang Tim Liu updated HIVE-3649:
-------------------------------

    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

  was:
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;




    
> Hive List Bucketing - enhance DDL to specify list bucketing table
> -----------------------------------------------------------------
>
>                 Key: HIVE-3649
>                 URL: https://issues.apache.org/jira/browse/HIVE-3649
>             Project: Hive
>          Issue Type: New Feature
>    Affects Versions: 0.10.0
>            Reporter: Gang Tim Liu
>
> 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

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to