[QA] Hive and Clickhouse. How to select and insert data from clickhouse into hive using spark thrift server?

[paf91]

So basically I'm using spark thrift server to let users use pure sql to select data from hive + s3 storage using spark. How do I select data from clickhouse using clickhouse-connector and THEN insert into Hive table? like: SET spark.sql.catalog.clickhouse.user=someuser; SET spark.sql.catalog.clickhouse.user=somepassword; use clickhouse;

then SELECT * FROM .

INSERT INTO .?

[pan3793]

Use the following Spark SQL syntax

INSERT INTO spark_catalog.<hive_db>.<hive_tbl>
SELECT ... FROM clickhouse.<ch_db>.<ch_tbl>