[ https://issues.apache.org/jira/browse/CARBONDATA-3087?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16679858#comment-16679858 ]
Zhichao Zhang commented on CARBONDATA-3087:
--------------------------------------------
Hi Jacky:
I have some questions shown below:
1. How to show external info if it's an external table?
2. It need to show the partition info if it has partition columns;
3. missing property: DICTIONARY_INCLUDE;
4. doesn't it show database and table name?
5. will remove NO_INVERTED_INDEX ? right?
6. doesn't it show default value for each properties? and as our discussion, we need to save the default value to schema info even user doesn't set the value, is this done?
> Prettify DESC FORMATTED output
> ------------------------------
>
> Key: CARBONDATA-3087
> URL: https://issues.apache.org/jira/browse/CARBONDATA-3087
> Project: CarbonData
> Issue Type: Improvement
> Reporter: Jacky Li
> Priority: Major
> Time Spent: 1h 10m
> Remaining Estimate: 0h
>
> Change output of DESC FORMATTED to:
> {noformat}
> +----------------------------+-------------------------------------------------------------------------------------+-------+
> |col_name |data_type |comment|
> +----------------------------+-------------------------------------------------------------------------------------+-------+
> |shortfield |smallint |null |
> |intfield |int |null |
> |bigintfield |bigint |null |
> |doublefield |double |null |
> |stringfield |string |null |
> |timestampfield |timestamp |null |
> |decimalfield |decimal(18,2) |null |
> |datefield |date |null |
> |charfield |string |null |
> |floatfield |double |null |
> | | | |
> |## Table Basic Information | | |
> |Comment | | |
> |Path |/Users/jacky/code/carbondata/examples/spark2/target/store/default/carbonsession_table| |
> |Table Block Size |1024 MB | |
> |Table Blocklet Size |64 MB | |
> |Streaming |false | |
> |Flat Folder |false | |
> |Bad Record Path | | |
> |Min Input Per Node |0.0B | |
> | | | |
> |## Index Information | | |
> |Sort Scope |LOCAL_SORT | |
> |Sort Columns |stringfield,timestampfield,datefield,charfield | |
> |Index Cache Level |BLOCK | |
> |Cached Index Columns |All columns | |
> | | | |
> |## Encoding Information | | |
> |Local Dictionary Enabled |true | |
> |Local Dictionary Threshold |10000 | |
> |Local Dictionary Include |stringfield | |
> | | | |
> |## Compaction Information | | |
> |MAJOR_COMPACTION_SIZE |1024 | |
> |AUTO_LOAD_MERGE |false | |
> |COMPACTION_LEVEL_THRESHOLD |4,3 | |
> |COMPACTION_PRESERVE_SEGMENTS|0 | |
> |ALLOWED_COMPACTION_DAYS |0 | |
> | | | |
> |## Dynamic Information | | |
> |Table Data Size |2.93KB | |
> |Table Index Size |1.53KB | |
> |Last Update Time |Wed Nov 07 17:16:01 CST 2018 | |
> +----------------------------+-------------------------------------------------------------------------------------+-------+
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)