ClickHouse / spark-clickhouse-connector

Spark ClickHouse Connector build on DataSourceV2 API
https://clickhouse.com/docs/en/integrations/apache-spark
Apache License 2.0
176 stars 63 forks source link

Unsupported type: Object('json') #313

Open dsonawane-conviva opened 2 months ago

dsonawane-conviva commented 2 months ago

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 ") 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!