subkanthi

create table test_modify(uid String, newcol Nullable(String)) Engine=MergeTree() order by uid;

CREATE TABLE test_modify
(
    `uid` String,
    `newcol` Nullable(String)
)
ENGINE = MergeTree
ORDER BY uid

subkanthi

// https://github.com/ClickHouse/ClickHouse/blob/58db4b7be4f326f5c30dccf3372172d83912f282/dbms/tests/queries/0_stateless/00463_sessions_in_http_interface.sh

// Pass a unique id to session_id and open a new connection.
ClickHouseDataSource dataSource = new ClickHouseDataSource(url + "?session_id=1", properties);
ClickHouseConnection conn = dataSource.getConnection(userName, "");
dataSource.getConnection().prepareStatement("set max_rows_to_read=7777777").execute();

// Set the setting - max_rows_to_read
ResultSet rs = dataSource.getConnection().prepareStatement("select * from system.settings where name='max_rows_to_read'").executeQuery();

subkanthi

version: "3.4"

# Ubuntu , set this for redpanda to start
# https://sort.veritas.com/public/documents/HSO/2.0/linux/productguides/html/hfo_admin_ubuntu/ch04s03.htm

# Clickhouse Table Schema
# create table test(id int, message String) ENGINE=MergeTree() PRIMARY KEY id;

services:
  mysql-master: