Clickhouse查询数据写入SQL Server、MySQL

前提条件：需安装部署好clickhouse-jdbc-bridge

1.写入SQL Server

• SQL Server端先建目标表test

• Clickhouse端通过JDBC挂接test目标表

  Create Table test (
  id String,
  name String
  ) ENGINE=JDBC('msjdbc', 'dbo','test');
  

• Clickhouse端执行insert语句

  INSERT INTO test SELECT id, name FROM othertable

2.写入MySQL(用MySQL引擎)

• MySQL端先建目标表test

• Clickhouse端通过MySQL引擎挂接test目标表

  Create Table test ( id String, name String ) ENGINE=MySQL('192.168.1.176:3306', 'database', 'test', 'user', 'pass');

• Clickhouse端执行insert语句

  INSERT INTO test SELECT id, name FROM othertable

3.写入MySQL(用mysql table function)

• MySQL端先建目标表test

• Clickhouse端执行语句：

  INSERT INTO FUNCTION mysql('mysql:port', 'database', 'test', 'user', 'pass', 1) 
  SELECT * FROM ck.test;