Hi , I am trying Common Table Expression(CTE) using below example but its not working , can you please tell how to implement CTE in KSQL where I want to select from table or topic. WITH cteSample (VBELN, MANDT, POSNR) AS ( SELECT lips.VBELN,lips.MANDT,lips.POSNR FROM JSON_LIMITED_2_LIPS_S1…

Handling of Common Table Expression

rmoff Split this topic 11 February 2021 11:06 6

Topic		Replies	Views
Create Table without data aggregation ksqlDB	2	4117	16 April 2022
Handling of Windowing function in KSQL like ROW_NUMMBER() , RANK() and DENSE_RANK() ksqlDB	8	4671	16 July 2021
Equivalent of SQL Union in KSQLDB ksqlDB	4	5065	1 October 2022
RECORDING AVAILABLE - ksqlDB 101 Events	0	3275	19 November 2021
Data Snapshot using KSQL ksqlDB	3	3183	25 November 2021