ksql
ksql copied to clipboard
Better indentation for SHOW QUERIES
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>