GitHub user anubhav100 opened a pull request:
https://github.com/apache/incubator-carbondata/pull/601
[CARBONDATA-709]corrected doc for bucketing
correcting the doc for bucketing in this pr
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)
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/anubhav100/incubator-carbondata CARBONDATA-709
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-carbondata/pull/601.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #601
----
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
