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
--
View this message in context:
http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/Dimension-column-of-integer-type-to-exclude-from-dictionary-tp9961p10008.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at
Nabble.com.
