ClickHouse/spark-clickhouse-connector

Unsupported type: Object('json')

Opened this issue · 0 comments

I am trying to execute query using spark connector to query Clickhouse with Spark 3.3 and scala 2.12.
val df = spark.sql("select customerId, clientId from <table_name>")
column type -
customerId - int32
clientId - String

However, table has another columns with type Object('json'). I am getting error -
[error] (Compile / runMain) xenon.clickhouse.exception.CHClientException: [-1] Unsupported type: Object('json')

  1. Does this connector support Object('json')?
  2. Even if it does not, why I am facing above error because my query result does not contain Object('json')?

Thanks!