CODEWITHSUNDEEP
scalaclickhousescala-catscats-effectdoobie
Andrew
Andrew

Reputation: 11

Create clickhouse temporary table with doobie

I want to create clickhouse temporary table with doobie, but i don't know how to add session_id parameter in query

I tried

val sql =
          sql"CREATE TEMPORARY TABLE " ++ Fragment.const(tableName) ++ sql"( call_id String ) ENGINE Memory()"

HC.setClientInfo("session_id",sessionId.toString) *> sql.update.run

but this not working

Upvotes: 1

Views: 418

Answers (0)

Related Questions