You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Jacky Li (JIRA)" <ji...@apache.org> on 2018/11/07 09:24:00 UTC

[jira] [Created] (CARBONDATA-3087) Prettify DESC FORMATTED output

Jacky Li created CARBONDATA-3087:
------------------------------------

             Summary: Prettify DESC FORMATTED output
                 Key: CARBONDATA-3087
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-3087
             Project: CarbonData
          Issue Type: Improvement
            Reporter: Jacky Li


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)