[jira] [Commented] (CARBONDATA-1431) Dictionary_Include working incorrectly for date and timestamp data type.

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

[jira] [Commented] (CARBONDATA-1431) Dictionary_Include working incorrectly for date and timestamp data type.

Akash R Nilugal (Jira)

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

Raghunandan S commented on CARBONDATA-1431:
-------------------------------------------

desc formatted shows that it is a dictionary column.
should not base the judgement on the files in the store.
you can add the info log for that. no harm in that. but the information is not much useful.
log would useful when they didnt get considered as direct dictionary

> Dictionary_Include working incorrectly for date and timestamp data type.
> ------------------------------------------------------------------------
>
>                 Key: CARBONDATA-1431
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1431
>             Project: CarbonData
>          Issue Type: Bug
>          Components: sql, test
>    Affects Versions: 1.2.0
>            Reporter: Sangeeta Gulia
>            Assignee: Pallavi Singh
>            Priority: Minor
>             Fix For: 1.2.0
>
>          Time Spent: 1h
>  Remaining Estimate: 0h
>
> When we create a table with date and timestamp data type with DICTIONARY_INCLUDE :
> Example :
> CREATE TABLE uniqdata_INCLUDEDICTIONARY2 (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('DICTIONARY_INCLUDE'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2')
> It should either create the dictionary for date and timestamp field or it should throw an error that "DICTIONARY_INCLUDE" feature is not supported for date and timestamp.
> whereas in the current master branch,  the query executed successfully without throwing any error and neither it created dictionary files for date and timestamp field.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)