Create clickhouse temporary table with doobie

338 Views Asked by At

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

0

There are 0 best solutions below