[jira] [Commented] (CARBONDATA-1672) Carbon 1.3.0-Partitioning:Hash Partition is not working as specified in the document.

[Akash R Nilugal (Jira)]

    [ https://issues.apache.org/jira/browse/CARBONDATA-1672?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16290813#comment-16290813 ]

Sangeeta Gulia commented on CARBONDATA-1672:
--------------------------------------------

This is the link to the latest documentation:

https://carbondata.apache.org/data-management-on-carbondata.html

which has provided the below syntax for creating hash partition table:

CREATE TABLE IF NOT EXISTS hash_partition_table(
    col_A String,
    col_B Int,
    col_C Long,
    col_D Decimal(10,2),
    col_F Timestamp
) PARTITIONED BY (col_E Long)
STORED BY 'carbondata' TBLPROPERTIES('PARTITION_TYPE'='HASH','NUM_PARTITIONS'='9')

Note: please check the difference in NUM_PARTITIONS attribute for specifying the number of partitions.

> Carbon 1.3.0-Partitioning:Hash Partition is not working as specified in the document.
> -------------------------------------------------------------------------------------
>
>                 Key: CARBONDATA-1672
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1672
>             Project: CarbonData
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 1.3.0
>            Reporter: Ayushi Sharma
>            Priority: Minor
>         Attachments: Part2.PNG, Partition1.PNG
>
>
> create table Carb_part (P_PARTKEY BIGINT,P_NAME STRING,P_MFGR STRING,P_BRAND STRING,P_TYPE STRING,P_CONTAINER STRING,P_RETAILPRICE DOUBLE,P_COMMENT STRING)PARTITIONED BY (P_SIZE int) STORED BY 'CARBONDATA' TBLPROPERTIES('partition_type'='HASH','partition_num'='3');
> This command displays error as mentioned below:
> Error: org.apache.carbondata.spark.exception.MalformedCarbonCommandException: Error: Invalid partition definition (state=,code=0)

--
This message was sent by Atlassian JIRA
(v6.4.14#64029)