anubhav tarar created CARBONDATA-709:
----------------------------------------
Summary: 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
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)