[Database] ClickHouse 설치방법

나중에 파이썬에서 연결하기 위해 Nurion테스트베드에 설치해 봄 

# clickhouse 드라이버 설치
pip3 install clickhouse-driver[lz4]
python3 -m pip install clickhouse-driver[lz4]

 

from clickhouse_driver import Client
 
try:
    client = Client('192.168.123.50',
                user='user',
                password='password',
                verify=False,
                database='default',
                compression=True)
 
    result = client.execute('SELECT now(), version()') #내용고쳐서
    result2 = client.execute('SHOW databases')
    print(result)
 
except:
    print("Error while fetching Schema")