[jira] [Commented] (CARBONDATA-911) Exception raised while creating table using bucketing

[Akash R Nilugal (Jira)]

    [ https://issues.apache.org/jira/browse/CARBONDATA-911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15965472#comment-15965472 ]

Kunal Kapoor commented on CARBONDATA-911:
-----------------------------------------

Column Groups are not supported for columns defined with DICTIONARY_EXCLUDE

> Exception  raised while creating table using bucketing
> ------------------------------------------------------
>
>                 Key: CARBONDATA-911
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-911
>             Project: CarbonData
>          Issue Type: Bug
>          Components: docs
>         Environment: Spark 2.1
>            Reporter: Shivangi Gupta
>            Priority: Minor
>
> Exception raised while creating table using bucketing: Column group is not supported for no dictionary columns
> Steps to reproduce:
> 1. Create table
>  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,productNumber)',
>                   'DICTIONARY_EXCLUDE'='productName',
>                   'DICTIONARY_INCLUDE'='productNumber',
>                   'NO_INVERTED_INDEX'='productBatch',
>                   'BUCKETNUMBER'='4',
>                   'BUCKETCOLUMNS'='productName');
> 2. Expected result :
> It should create table successfully
> 3. Result on beeline :
> Error: org.apache.carbondata.spark.exception.MalformedCarbonCommandException: Column group is not supported for no dictionary columns:productname (state=,code=0)

--
This message was sent by Atlassian JIRA
(v6.3.15#6346)