[jira] [Comment Edited] (CARBONDATA-2595) Reformat the output of command 'desc formatted table_name'

[Akash R Nilugal (Jira)]

    [ https://issues.apache.org/jira/browse/CARBONDATA-2595?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16585858#comment-16585858 ]

Zhichao  Zhang edited comment on CARBONDATA-2595 at 8/20/18 12:27 PM:
----------------------------------------------------------------------

  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 sql:
{code:java}
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 ;{code}
The non-formatted sql I get is : 

 
{code:java}
SELECT*fromsource_test{code}
  

any suggestion for this? 

 


was (Author: zzcclp):
  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 sql:
{code:java}
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 ;{code}


The non-formatted sql I get is : 

 
{code:java}
SELECT*fromsource_test{code}
 

 

 

any suggestion for this?

 
{code:java}
 {code}
 

> Reformat the output of command 'desc formatted table_name'
> ----------------------------------------------------------
>
>                 Key: CARBONDATA-2595
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2595
>             Project: CarbonData
>          Issue Type: Improvement
>          Components: sql
>            Reporter: Zhichao  Zhang
>            Assignee: Zhichao  Zhang
>            Priority: Minor
>             Fix For: 1.5.0
>
>         Attachments: desc_formatted.txt, desc_formatted_external.txt
>
>
> According to the discussion in [topic|http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/Change-the-comment-content-for-column-when-execute-command-desc-formatted-table-name-td46848.html], reformat the output of command 'desc formatted table_name'. 

--
This message was sent by Atlassian JIRA
(v7.6.3#76005)