search

kszucs / pandahouse

Pandas interface for Clickhouse database
MIT License
228 stars 70 forks source link

Database parameter will work #17

Closed kszucs closed 5 years ago

kszucs commented 5 years ago

sample code:

ch = {'host': 'http://clickhouse:8123', 'database': 'telegraf', 'user': 'test', 'password': 'test'}

QUERY = "SELECT datetime, host, toStringCutToZero(path) AS path, total, free, used, used_percent FROM disk WHERE service = 'backup'"

df = read_clickhouse(QUERY, connection=ch)

give me error:

pandahouse.http.ClickhouseException: Code: 60, e.displayText() = DB::Exception: Table default.disk doesn't exist., e.what() = DB::Exception
kszucs commented 5 years ago

+1