> Support Standard Partitioning in CarbonData
> -------------------------------------------
>
> Key: CARBONDATA-1850
> URL:
https://issues.apache.org/jira/browse/CARBONDATA-1850> Project: CarbonData
> Issue Type: New Feature
> Reporter: Ravindra Pesala
> Attachments: Standard Partitioning Support in CarbonData (1).docx
>
>
> Currently, Carbon supports the partitions which is custom implemented by carbon. So if community users want to use the features which are available in spark and hive in carbondata then there is a compatibility problem arrives in the sense of usage. And also carbondata does not have a built-in dynamic partition.
> To use the partition feature of spark we should comply with the interfaces available in spark while loading and reading the data.
> Features supported by standard partitioning
> Creating table with partition
> {code}
> CREATE [TEMPORARY] TABLE [IF NOT EXISTS] [db_name.]table_name
> [(col_name1 col_type1 [COMMENT col_comment1], ...)]
> USING datasource
> [OPTIONS (key1=val1, key2=val2, ...)]
> [PARTITIONED BY (col_name1, col_name2, ...)]
> [TBLPROPERTIES (key1=val1, key2=val2, ...)]
> [AS select_statement]
> Or
> CREATE TABLE [IF NOT EXISTS] [db_name.]table_name
> [(col_name data_type , ...)]
> [COMMENT table_comment]
> [PARTITIONED BY (col_name data_type , ...)]
> [CLUSTERED BY (col_name, col_name, ...) [SORTED BY (col_name [ASC|DESC], ...)] INTO num_buckets BUCKETS]
> [STORED BY file_format]
> [TBLPROPERTIES (property_name=property_value, ...)]
> [AS select_statement];
> {code}
> Load Data Using Static Partition
> {code}
> LOAD DATA LOCAL INPATH '${env:HOME}/staticinput.txt'
> INTO TABLE partitioned_user
> PARTITION (country = 'US', state = 'CA')
>
> INSERT OVERWRITE TABLE partitioned_user
> PARTITION (country = 'US', state = 'AL')
> SELECT * FROM another_user au
> WHERE au.country = 'US' AND au.state = 'AL';
> {code}
> Load data Using Dynamic Partition
> {code}
> LOAD DATA LOCAL INPATH '${env:HOME}/staticinput.txt'
> INTO TABLE partitioned_user
> PARTITION (country, state)
>
> INSERT OVERWRITE TABLE partitioned_user
> PARTITION (country, state)
> SELECT * FROM another_user;
> {code}
> Show Partitions
> {code}
> SHOW PARTITIONS [db_name.]table_name
> {code}
> Drop Partition
> {code}
> ALTER TABLE table_name DROP [IF EXISTS] (PARTITION part_spec, ...)
> {code}
Locked
