carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Liang Chen (JIRA)" <>
Subject [jira] [Assigned] (CARBONDATA-709) Incorrect documentation for bucketing in ddl section
Date Wed, 22 Feb 2017 09:21:44 GMT


Liang Chen reassigned CARBONDATA-709:

    Assignee: anubhav tarar

> Incorrect documentation for bucketing in ddl section
> ----------------------------------------------------
>                 Key: CARBONDATA-709
>                 URL:
>             Project: CarbonData
>          Issue Type: Bug
>          Components: docs
>    Affects Versions: 1.0.0-incubating
>            Reporter: anubhav tarar
>            Assignee: anubhav tarar
>             Fix For: 1.0.1-incubating
>          Time Spent: 1h 50m
>  Remaining Estimate: 0h
> 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

View raw message