SQL programming
Project description
ClickSQL: ClickHouse client for Humans
Package information:
ClickSQL is a smart client for ClickHouse database, which may help users to use ClickHouse more easier and smoother.
more information for ClickHouse can be found at here
Installation
pip install ClickSQL
Usage
initial connection
Approach 1
from ClickSQL import ClickHouseTableNode
conn_str = "clickhouse://default:test121231@99.99.9.9:8123/system"
ct = ClickHouseTableNode(conn_str)
>>> connection test: Ok.
Approach 2
from ClickSQL import ClickHouseTableNode
conn_str = {'name':'clickhouse','host':'99.99.9.9','port':8123,'user':'default',
'password':'test121231','database':'system'}
ct = ClickHouseTableNode(**conn_str)
>>> connection test: Ok.
Query
from ClickSQL import ClickHouseTableNode
conn_str = "clickhouse://default:test121231@99.99.9.9:8123/system"
ct = ClickHouseTableNode(conn_str)
ct.query('show tables from system limit 1')
>>> connection test: Ok.
>>> name
>>> 0 aggregate_function_combinators
Contribution
there is welcome to do more work to improve this package more convenient
Author
sn0wfree
functions
- get data from clickhouse
- insert data into clickhouse
- create
- alter
Plan
Available function
- access clickhouse service
- execute standard SQL and transform into dataframe
- able to execute select query
- able to execute insert query
- no require clickhouse-client
- auto create table sql
schedule
- create a pandas_liked executable function, which can compatible with pandas
- can execute explain query
- can execute user role query
- create analysis component
- auto report system
- table register system
- data manager system
- meta data manager
- distributed query(query+insert)
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
ClickSQL-0.1.5.5.tar.gz
(14.2 kB
view hashes)