ksql icon indicating copy to clipboard operation
ksql copied to clipboard

Better indentation for SHOW QUERIES

Open hjafarpour opened this issue 6 years ago • 0 comments

If multiple lines are used for a query, show query does not correctly indent the query content. Here is an example:

ksql> CREATE STREAM pageviews_enriched AS
>SELECT users_original.userid AS userid, pageid, regionid, gender
>FROM pageviews_original
>LEFT JOIN users_original
>  ON pageviews_original.userid = users_original.userid;

 Message                                                                                                  
----------------------------------------------------------------------------------------------------------
 Stream PAGEVIEWS_ENRICHED created and running. Created by query with query ID: CSAS_PAGEVIEWS_ENRICHED_2 
----------------------------------------------------------------------------------------------------------
ksql> show queries;

 Query ID                  | Kafka Topic        | Query String                                                                                                 
---------------------------------------------------------------------------------------------------------------------------------------------------------------
 CSAS_PAGEVIEWS_ENRICHED_2 | PAGEVIEWS_ENRICHED | CREATE STREAM PAGEVIEWS_ENRICHED WITH (KAFKA_TOPIC='PAGEVIEWS_ENRICHED', PARTITIONS=1, REPLICAS=1) AS SELECT
  USERS_ORIGINAL.USERID "USERID",
  PAGEVIEWS_ORIGINAL.PAGEID "PAGEID",
  USERS_ORIGINAL.REGIONID "REGIONID",
  USERS_ORIGINAL.GENDER "GENDER"
FROM PAGEVIEWS_ORIGINAL PAGEVIEWS_ORIGINAL
LEFT OUTER JOIN USERS_ORIGINAL USERS_ORIGINAL ON ((PAGEVIEWS_ORIGINAL.USERID = USERS_ORIGINAL.USERID))
EMIT CHANGES; 
---------------------------------------------------------------------------------------------------------------------------------------------------------------
For detailed information on a Query run: EXPLAIN <Query ID>;
ksql> 

hjafarpour avatar Oct 07 '19 23:10 hjafarpour