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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Akash R Nilugal (Jira)
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)