Skip to content

Instantly share code, notes, and snippets.

@s-chb
Created July 15, 2020 00:59
Show Gist options
  • Save s-chb/6d2ad8c4b81940b9d8508fdcb4765b46 to your computer and use it in GitHub Desktop.
Save s-chb/6d2ad8c4b81940b9d8508fdcb4765b46 to your computer and use it in GitHub Desktop.
CREATE STREAM transition
WITH (
TIMESTAMP='START_TIME_,END_TIME_',
KAFKA_TOPIC='transition',
VALUE_FORMAT='DELIMITED'
) AS
SELECT
PROC_DEF_ID_,
EXECUTION_ID_,
NAME_ ,
START_TIME_,
END_TIME_,
TIMESTAMPTOSTRING(START_TIME_, 'yyyy-MM-dd HH:mm:ss.SSS') AS START_TIME,
TIMESTAMPTOSTRING(END_TIME_, 'yyyy-MM-dd HH:mm:ss.SSS') AS END_TIME
FROM PROCESS
EMIT CHANGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment