[jira] [Commented] (CARBONDATA-759) How to check a table's properties?

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

[jira] [Commented] (CARBONDATA-759) How to check a table's properties?

Akash R Nilugal (Jira)

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

Babulal commented on CARBONDATA-759:
------------------------------------

please try "desc formatted <table_name>"  command .
In comment column you can find the column type .

MEASURE = Measure type column
DICTIONARY, KEY COLUMN  = dimension  with Dictionary
KEY COLUMN  = dimension  with NO Dictionary

In ##Column Group Information    you can find the COLUMN_GROUPS info .
MDK info is used internally and  only dimensions are used to form it .

Regards
Babu



> How to check a table's properties?
> ----------------------------------
>
>                 Key: CARBONDATA-759
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-759
>             Project: CarbonData
>          Issue Type: Improvement
>            Reporter: sehriff
>            Priority: Minor
>
> Is there a way to check what colums of  a table is treated as dimensions or measures?
> How to check default table properties(COLUMN_GROUPS,DICTIONARY_EXCLUDE,DICTIONARY_INCLUDE,NO_INVERTED_INDEX) and what of this tables's mdk looks like?



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)