[jira] [Resolved] (CARBONDATA-709) Incorrect documentation for bucketing in ddl section

[Akash R Nilugal (Jira)]

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

Liang Chen resolved CARBONDATA-709.
-----------------------------------
       Resolution: Fixed
    Fix Version/s: 1.0.1-incubating

> Incorrect documentation for bucketing in ddl section
> ----------------------------------------------------
>
>                 Key: CARBONDATA-709
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-709
>             Project: CarbonData
>          Issue Type: Bug
>          Components: docs
>    Affects Versions: 1.0.0-incubating
>            Reporter: anubhav tarar
>            Assignee: anubhav tarar
>             Fix For: 1.0.1-incubating
>
>          Time Spent: 1h 50m
>  Remaining Estimate: 0h
>
> in docs ddl bucketing section Columns in the BUCKETCOLUMN parameter must be either a dimension or a measure but combination of both is not supported. this line is incorrect here is the example
> 0: jdbc:hive2://localhost:10000> CREATE TABLE uniqData_t11(ID Int,name string)stored by 'carbondata' TBLPROPERTIES("DICTIONARY_EXCLUDE"="name","bucketnumber"="1", "bucketcolumns"="ID");
> Error: java.lang.RuntimeException: Bucket field must be dimension column and should not be measure or complex column: ID (state=,code=0)
> so bucketing coloumn should be dimension only
> plus in parameter description tableName is not required and the example that added for bucketing is also wrong
> 0: jdbc:hive2://localhost:10000> CREATE TABLE IF NOT EXISTS productSchema.productSalesTable ( productNumber Int, productName String, storeCity String, storeProvince String, productCategory String, productBatch String, saleQuantity Int, revenue Int) STORED BY 'carbondata' TBLPROPERTIES ('COLUMN_GROUPS'='(productName,productCategory)', 'DICTIONARY_EXCLUDE'='productName', 'DICTIONARY_INCLUDE'='productNumber', 'NO_INVERTED_INDEX'='productBatch', 'BUCKETNUMBER'='4', 'BUCKETCOLUMNS'='productNumber,saleQuantity');
> Error: org.apache.carbondata.spark.exception.MalformedCarbonCommandException: Invalid column group,column in group should be contiguous as per schema. (state=,code=0)

--
This message was sent by Atlassian JIRA
(v6.3.15#6346)