[REST] [MetaStore] Kyuubi metastore fails to store SQL session_type metadata

[rubberliu]

Hello, I have a question about the metastore. I use kyuubi 1.9.2 and the rest mode.

Firstly, I submit a batch jar using:
curl --location --request POST 'url:port/api/v1/batches' \ --form 'batchRequest="{\"batchType\":\"SPARK\",\"className\":\"org.apache.spark.examples.SparkPi\",\"name\":\"kyuubi-spark-pi\", \"resource\":\"path/jars/spark-examples_2.12-3.3.1.jar\"}";type=application/json'
and found the metastore work:

then I submit a session sql using:
curl -X 'POST' \ 'url:port/api/v1/sessions' \ -H 'accept: application/json' \ -H 'Content-Type: application/json' \ -d '{ "configs": { "xxx": "xxx" } }'
but found nothing in metastore.

the kyuubi configurations about metastore I use:

• kyuubi.metadata.store.jdbc.database.type MYSQL
• kyuubi.metadata.store.jdbc.url jdbc:mysql://xxxxx:3306/kyuubi
• kyuubi.metadata.store.jdbc.user
• kyuubi.metadata.store.jdbc.password
• kyuubi.metadata.store.jdbc.driver com.mysql.cj.jdbc.Driver

It seems like kyuubi supports SQL or BATCH session type, but I can only enable batch mode. How can I make session mode work?

[rubberliu]

btw, the session mode can normally execute sql, and query correct result. The only problem is that I can't find it in the metastore.

[moelhoussein]

Youd probably figured this out by now. Kyuubi does NOT implmenet share session state. (Sessions will NOT be stored in kyuubi metadata db.). To over come this you can use session affinity.