carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "anubhav tarar (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CARBONDATA-709) Incorrect documentation for bucketing in ddl section
Date Thu, 16 Feb 2017 05:51:41 GMT
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)

Mime
View raw message