Re: Change the 'comment' content for column when execute command 'desc formatted table_name'

Posted by Liang Chen on Aug 21, 2018; 2:31pm
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/Change-the-comment-content-for-column-when-execute-command-desc-formatted-table-name-tp46848p59898.html

Hi

1. Agree with likun's comments(4 points) :

2. About 'select sql' for CTAS , you can leave it. we can consider it later.

Regards
Liang

Jacky Li wrote

> Hi ZZC,
>
> I have checked the doc in CARBONDATA-2595. I have following comments:
> 1. In the Table Basic Information section, it is better to print the Table
> Path instead of "CARBON Store Path”
> 2. For the Table Data Size  and Index Size, can you format the output in
> GB, MB, KB, etc
> 3. For the Last Update Time, can you format the output in UTC time like
> YYYY-MM-DD hh:mm:ss
> 4. In table property, I think maybe some properties are missing, like
> block size, blocklet size, long string
>
> For implementation, I suggest to write the main logic of collecting these
> information in java so that it is easier to write tools for it. One tool
> can be this SQL command and another tool I can think of is an standalone
> java executable that  can print these information on the screen by reading
> the given table path. (We can put this standalone tool in SDK module)
>
> Regards,
> Jacky
>
>
>> 在 2018年8月20日，上午11:20，xm_zzc <

> 441586683@

>> 写道：
>>
>> Hi dev:
>>  Now I am working on this, the new format is shown in attachment, please
>> give me some feedback.
>>  There is one question: if user uses CTAS to create table, do we need to
>> show the 'select sql' in the result of 'desc formatted table'? If yes,
>> how
>> to get 'select sql'? now I just can get a non-formatted sql from
>> 'CarbonSparkSqlParser.scala' (Jacky mentioned), for example:
>>
>> *CREATE TABLE IF NOT EXISTS test_table
>> STORED BY 'carbondata'
>> TBLPROPERTIES(
>> 'streaming'='false', 'sort_columns'='id,city',
>> 'dictionary_include'='name')
>> AS SELECT * from source_test ;*
>>
>> The non-formatted sql I get is :
>> *SELECT*fromsource_test*
>>
>> desc_formatted.txt
>> &lt;http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/file/t133/desc_formatted.txt&gt; 
>> desc_formatted_external.txt
>> &lt;http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/file/t133/desc_formatted_external.txt&gt; 
>>
>>
>>
>>
>>
>>
>> --
>> Sent from:
>> http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/
>>

--
Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/