[jira] [Updated] (CARBONDATA-2585) Support Adding Local Dictionary configuration in Create table statement

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

[jira] [Updated] (CARBONDATA-2585) Support Adding Local Dictionary configuration in Create table statement

Akash R Nilugal (Jira)

     [ https://issues.apache.org/jira/browse/CARBONDATA-2585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Akash R Nilugal updated CARBONDATA-2585:
----------------------------------------
    Description:
Allow user to pass local dictionary configuration in Create table statement.

*LOCAL_DICTIONARY_ENABLE :  enable or disable local dictionary generation for a table(default local dictionary generation will be true)*

{color:#000000}*CARBON_LOCALDICT_THRESHOLD: configuring the threshold value for local dictionary generation(default will be 1000)*{color}

{color:#000000}*LOCAL_DICTIONARY_INCLUDE***: list of columns for which user wants to generate local dictionary (default all the no dictionary string data type columns will be considered for generation) {color}

{color:#000000}*LOCAL_DICTIONARY_EXCLUDE***: list of columns for which user does not want to generate local dictionary (default no string datatype no dictionary columns are excluded unless it is configured) {color}

CREATE TABLE carbontable(

column1 string,

column2 string,

column3 LONG )

STORED BY 'carbondata'

TBLPROPERTIES('*LOCAL_DICTIONARY_ENABLE*'='*true*',*’LOCAL_DICTIONARY_THRESHOLD=1000',*

'*LOCAL_DICTIONARY_INCLUDE*'='*column1*','*LOCAL_DICTIONARY_EXCLUDE*'='*column2*')

  was:
Allow user to pass local dictionary configuration in Create table statement.

*LOCAL_DICTIONARY_ENABLE*

{color:#000000}*CARBON_LOCALDICT_THRESHOLD*{color}

{color:#000000}*LOCAL_DICTIONARY_INCLUDE***{color}

{color:#000000}*LOCAL_DICTIONARY_EXCLUDE***{color}

CREATE TABLE carbontable(

column1 string,

column2 string,

column3 LONG )

STORED BY 'carbondata'

TBLPROPERTIES('*LOCAL_DICTIONARY_ENABLE*'='*true*',*’LOCAL_DICTIONARY_THRESHOLD=1000',*

'*LOCAL_DICTIONARY_INCLUDE*'='*column1*','*LOCAL_DICTIONARY_EXCLUDE*'='*column2*')


> Support Adding Local Dictionary configuration in Create table statement
> -----------------------------------------------------------------------
>
>                 Key: CARBONDATA-2585
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2585
>             Project: CarbonData
>          Issue Type: Sub-task
>            Reporter: kumar vishal
>            Assignee: Akash R Nilugal
>            Priority: Major
>          Time Spent: 5h 50m
>  Remaining Estimate: 0h
>
> Allow user to pass local dictionary configuration in Create table statement.
> *LOCAL_DICTIONARY_ENABLE :  enable or disable local dictionary generation for a table(default local dictionary generation will be true)*
> {color:#000000}*CARBON_LOCALDICT_THRESHOLD: configuring the threshold value for local dictionary generation(default will be 1000)*{color}
> {color:#000000}*LOCAL_DICTIONARY_INCLUDE***: list of columns for which user wants to generate local dictionary (default all the no dictionary string data type columns will be considered for generation) {color}
> {color:#000000}*LOCAL_DICTIONARY_EXCLUDE***: list of columns for which user does not want to generate local dictionary (default no string datatype no dictionary columns are excluded unless it is configured) {color}
> CREATE TABLE carbontable(
> column1 string,
> column2 string,
> column3 LONG )
> STORED BY 'carbondata'
> TBLPROPERTIES('*LOCAL_DICTIONARY_ENABLE*'='*true*',*’LOCAL_DICTIONARY_THRESHOLD=1000',*
> '*LOCAL_DICTIONARY_INCLUDE*'='*column1*','*LOCAL_DICTIONARY_EXCLUDE*'='*column2*')



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)