Hello! Is there a recommended way to setup the SQL...
# random
j
Hello! Is there a recommended way to setup the SQL Gateway with Flink K8S Operator ?
r
I expect you could start the gateway in the jobmanager's pod template post start hook? Something like:
Copy code
jobManager:
    resource:
      memory: ...
      cpu: ...
    podTemplate:
      apiVersion: v1
      kind: Pod
      metadata:
        name: pod-template
      spec:
        serviceAccount: flink
        containers:

          - name: flink-main-container

              lifecycle:
                postStart:
                  exec:
                    command:
                      - sh
                      - -c
                      - './bin/sql-gateway.sh start -Dsql-gateway.endpoint.rest.address=localhost &'
I think it'd need to be in interactive mode though...
j
Thank you ! We tried to do this but we could not make it work. We are running in application mode using the Flink Operator. We are getting the following exception when running select 1; from the sql client
r
from those logs, it actually looks like it's working. But you've not done the session handshake setup. And you'll need it in interactive / standalone mode, so that the cluster can accept interactive jobs