Hello,
You may install and test KSQL as it is open source. It is not tested & not supported by Cloudera. While functionally different, Spark Streaming may provide a solution for your use case.
KSQL is very new and Spark Streaming is the tried and tested technology for processing streams of data, and Cloudera has around hundred customers using Spark Streaming in production settings. In addition, with Spark Streaming, Cloudera's customers are able to benefit from the superior Spark ecosystem and libraries and machine learning support.
Hope this answers your question!
Cheers,
Manuel