[DISCUSS] For the dimension default should be no dictionary

Posted by bill.zhou on Feb 26, 2017; 2:34pm
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/DISCUSS-For-the-dimension-default-should-be-no-dictionary-tp8010.html

hi All
    Now when create the CarbonData table,if  the dimension don't add into the dictionary_exclude properties, the dimension will be consider as dictionary default. I think default should be no dictionary.

    For example when I do the POC for one customer, it has 300 columns and 200 dimensions, but only 5 columns is used for filter, so he only need set this 5 columns to dictionary and leave other 195 columns to no dictionary. But now he need specify for the 195 columns to dictionary_exclude properties the will waste time and make the create table command huge, also will impact the load performance.

    So I suggestion dimension default should be no dictionary and this can also help customer easy to know the dictionary column which is useful.