[ 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) |
Free forum by Nabble | Edit this page |