KSQL Configuration

Set KSQL configuration and security parameters in the ksql-server.properties file. The default port for KSQL is 8084.

Configuring KSQL to Run in Non-Interactive (Headless) Mode

To run KSQL in non-interactive mode, set the parameters shown and then start KSQL.
NOTE Note that the ksql.default.stream parameter is optional, but recommended. This parameter sets the default stream to consume from and send the messages to. The default stream is used if the topic name does not include the stream name. For example, if a message is sent to exampleTopic and this parameter is set to /exampleStream, then the message is sent to /exampleStream:exampleTopic.

Set the following properties in the /opt/mapr/ksql/ksql-<version>/etc/ksql/ksql-server.properties file:

ksql.command.topic.suffix=commands
ksql.service.id=app2
listeners=http://localhost:8084
ksql.default.stream=/sample-stream
Start KSQL:
$ KSQL_INSTALL_DIR/bin/ksql-server-start /opt/mapr/ksql/ksql-<version>/etc/ksql/ksql-server.properties --queries-file some-queries-file.sql

Configuring KSQL to Run in Interactive Mode

The following example shows the configuration parameters that you must set in the ksql-server.properties file to run KSQL in interactive (distributed) mode:
ksql.command.topic.suffix=commands
            ksql.service.id=app2
            listeners=http://192.168.121.73:8084
            ksql.default.stream=/sample-stream
NOTE You must set the listeners parameter to an actual IP address.

For more information