Login  Register

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

Posted by Jacky Li on Aug 20, 2018; 11:37am
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-tp46848p59859.html

Hi ZZC,

Can you create a JIRA ticket and upload the design doc, in mail list we can not get the attachment

Regards,
Jacky

> 在 2018年8月20日,上午11:20,xm_zzc <[hidden email]> 写道:
>
> 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
> <http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/file/t133/desc_formatted.txt>  
> desc_formatted_external.txt
> <http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/file/t133/desc_formatted_external.txt>  
>
>
>
>
>
>
> --
> Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/
>