[
https://issues.apache.org/jira/browse/CARBONDATA-709?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Liang Chen reassigned CARBONDATA-709:
-------------------------------------
Assignee: anubhav tarar
> 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)
