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)
