Re: Dimension column of integer type - to exclude from dictionary

Posted by Liang Chen on
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/Dimension-column-of-integer-type-to-exclude-from-dictionary-tp9961p10008.html

Hi Sanoj

First , see if i understand your requirement: you only want to build index for column "Account", but don't want to build dictionary for column "Account", is it right?
If the above my understanding is right,  then David mentioned "SORT_COLUMNS" feature will satisfy your requirements.

Currently, you only can do like this :
First changes column "Account" to String type from Integer, then uses TBLPROPERTIES ('DICTIONARY_EXCLUDE'='Account')

Regards
Liang

Sanoj MG wrote

Hi All,

I have a dimension column of integer type. Since the cardinality of this
column is relatively high, I want to exclude it from the dictionary for
faster loading. Is there any way to do this in Carbondata DDL?

When I use TBLPROPERTIES ('DICTIONARY_INCLUDE'='Account'), Account will be
defined as a dimension, but it will also be included in the dictionary.


Thanks,
Sanoj