Python driver with native interface for ClickHouse
Project description
ClickHouse Python Driver
ClickHouse Python Driver with native (TCP) interface support.
Asynchronous wrapper is available here: https://github.com/mymarilyn/aioch
Features
External data for query processing.
Query settings.
Compression support.
TLS support (since server version 1.1.54304).
Types support:
Float32/64
[U]Int8/16/32/64
Date/DateTime(‘timezone’)
String/FixedString(N)
Enum8/16
Array(T)
Nullable(T)
UUID
Decimal
IPv4/IPv6
LowCardinality(T)
SimpleAggregateFunction(F, T)
Query progress information.
Block by block results streaming.
Reading query profile info.
Receiving server logs.
Documentation
Documentation is available at https://clickhouse-driver.readthedocs.io.
Usage
>>> from clickhouse_driver import Client >>> >>> client = Client('localhost') >>> >>> client.execute('SHOW TABLES') [('test',)] >>> >>> client.execute('DROP TABLE IF EXISTS test') [] >>> >>> client.execute('CREATE TABLE test (x Int32) ENGINE = Memory') [] >>> >>> client.execute( ... 'INSERT INTO test (x) VALUES', ... [{'x': 100}] ... ) >>> client.execute('INSERT INTO test (x) VALUES', [[200]]) >>> >>> client.execute( ... 'INSERT INTO test (x) ' ... 'SELECT * FROM system.numbers LIMIT %(limit)s', ... {'limit': 3} ... ) [] >>> >>> client.execute('SELECT sum(x) FROM test') [(303,)]
License
ClickHouse Python Driver is distributed under the MIT license.
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
Built Distributions
Hashes for clickhouse_driver-0.1.0-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f3e76d75cfcd21d70a1cb93e15aebcfed978c6885fc99f46a78d4c110222452b |
|
MD5 | eb03e5bf0c9f0caadd3be8843992bc0c |
|
BLAKE2b-256 | ba3d038ea23af3abdf3786c6b027d149fe3ea38b9e77c19813e85c623af54c92 |
Hashes for clickhouse_driver-0.1.0-cp37-cp37m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d8fea8e2a2e16af91e0285b2f7120c173004c5f061da02937f098d08fd9f1ae2 |
|
MD5 | 856307c9d299ecd95c501892f77df406 |
|
BLAKE2b-256 | 5632a5b01bb274b62174b524a90f79987bca5fb0645031dbadc99c5fdfbcb124 |
Hashes for clickhouse_driver-0.1.0-cp37-cp37m-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ca8b6fcc76cf35b0b20233f0b4c7be00c88d03d08790c8d502d66e8518ba4e7e |
|
MD5 | 5a7bcb7fa4392ee2d955514cac37ea51 |
|
BLAKE2b-256 | 3c7e0e43846d0b670ff8fedd2e4b730fd243d833c22741c83c911f3d4c65ba26 |
Hashes for clickhouse_driver-0.1.0-cp37-cp37m-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5f0a1ef62a479164bfe8890d5bd2e1a70b0c88ff7566d5463a267a7f6c6e8e7b |
|
MD5 | a2dd2206dd061f236d13b4ad060150f5 |
|
BLAKE2b-256 | 0a43b04696e15d5e79c1e583a45b130f7c6cb4f5f4063bba370e26a25af4c3e1 |
Hashes for clickhouse_driver-0.1.0-cp37-cp37m-macosx_10_6_intel.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 58f9447d022f025af677bebbc48179f535f337b17f09cf3c9de8f4d0b92fa4af |
|
MD5 | 49e9fcb2ebe62c4da8c016856a72aa0e |
|
BLAKE2b-256 | f0f3dcdeb446034a896a836aecb41eaa760e5d30e7a09bb70bf2cd1b57619c12 |
Hashes for clickhouse_driver-0.1.0-cp36-cp36m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c5dfa8228c6545b127782258ae260f48854301f9a8e90f07765d2bf37b7d1a64 |
|
MD5 | 943c8fc61e6f29ce3b10fefb93494f27 |
|
BLAKE2b-256 | ba3aafa34d0b3bc91e5f91fc47781b9690114ba7b90eb31ddb734e03543fad84 |
Hashes for clickhouse_driver-0.1.0-cp36-cp36m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0df687e4f88dfc9c8a46f6925939378b117190fe3668ef9a6da62a87bc00c201 |
|
MD5 | 0a16068f1f98bab81a087d166417f169 |
|
BLAKE2b-256 | 2bf4d1190163d092623640f8b4368f9e3848527174f2400ace6453a1314fa37f |
Hashes for clickhouse_driver-0.1.0-cp36-cp36m-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 172982f619a0258b283a249ee87e237e92cb6c410613179e66dea37d04dd1cc2 |
|
MD5 | 2474f60cc153d3f22c0320ee0f83b8b1 |
|
BLAKE2b-256 | 98cddd21afec77096af23864e43c0971b10afa3772edf10e30f7973081bbcfc2 |
Hashes for clickhouse_driver-0.1.0-cp36-cp36m-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b3763587a838c6a8483cacf81f67a3043f0a9096f3f547f1d22e38f1531a88a0 |
|
MD5 | 9983c1168ccfd648d687b544dbb33624 |
|
BLAKE2b-256 | bdc1af850432b06d7446fb4e11965cfc81e41d7067d5ba3b2b3088a7d5a084e5 |
Hashes for clickhouse_driver-0.1.0-cp36-cp36m-macosx_10_6_intel.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 03857751287708aa836098564466f7066d4aec8bdebe2b2cf4af3a25fce46a65 |
|
MD5 | c45d44ba3bd832a599f7d627cf2fe135 |
|
BLAKE2b-256 | 59da0c252d5ad8da95da79196aa3186e2b21ff800eaaf6dd49bb37b7551446e1 |
Hashes for clickhouse_driver-0.1.0-cp35-cp35m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c292d733129ebbc057ff77938f66c9a65f3f4e67c7ace439ab4064c31a5ecdd5 |
|
MD5 | b9059824085ca1c83fd1fb2360258f05 |
|
BLAKE2b-256 | fab8ccf9f338e061ce5c0999948ad83dbc75776a8a5c6721b079b1ecca0d06fe |
Hashes for clickhouse_driver-0.1.0-cp35-cp35m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 44f041506b9263e5fef7b77b47b2c97fbca69f1492a798d0fab2a983611f9a34 |
|
MD5 | 4e381113be9bf38ae3ac16460ba3da10 |
|
BLAKE2b-256 | 4610616b39e1f9d597e1a22ecdca397924245aab37971cbb30584afe4cb0bbdc |
Hashes for clickhouse_driver-0.1.0-cp35-cp35m-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f732250ccf92185c04e5db557a9be3ee4e2f367c8aba4688cd7bc9672ee4ef24 |
|
MD5 | bc66f01f8ee264dd72840c61a095a211 |
|
BLAKE2b-256 | 43ebb44f24abab606610040b0be27f0e34f49a35b9f922cface1db8253e926b7 |
Hashes for clickhouse_driver-0.1.0-cp35-cp35m-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f6f2ac707934fa714dbe151384c534170a3417ba025ac896ede4effbb123a94b |
|
MD5 | fc08427387ac603d2070a6bbf4f1fdaa |
|
BLAKE2b-256 | 1dd548e60a49dc0ce4624143783ae67016b1f0a708e95a097228605fed5512b4 |
Hashes for clickhouse_driver-0.1.0-cp35-cp35m-macosx_10_6_intel.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0fc7c821f11be3a6c9352ceae6f37490b817b5dd348e6329fe78385ff307d4dd |
|
MD5 | 6491cc22c52b78d786cabd1ce78218b0 |
|
BLAKE2b-256 | 0ff163e92d8484b836126110033c657aeae5c49015e83cc3ff66d9f7facc2559 |
Hashes for clickhouse_driver-0.1.0-cp34-cp34m-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5d5473b3e500aebb8c28962d814f67c808897b100d3ab4c2a411f233c17e2e14 |
|
MD5 | f5db65a28f3a4b4acd6ec86be7ce25bd |
|
BLAKE2b-256 | 24382e0acc000bed6585c420c76dc42ff2e16b1b9f677029a084912c191fdbfa |
Hashes for clickhouse_driver-0.1.0-cp34-cp34m-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3288b2f62bd5f3abb77add7747a3017c3d03d97613c95aaf556bfb980495efd0 |
|
MD5 | 137b2056420bd157602b1399e734e3df |
|
BLAKE2b-256 | b45fd1594d5fcef9c9199d8f77931d2c110269592b24c403bf58c8ea14914bee |
Hashes for clickhouse_driver-0.1.0-cp34-cp34m-macosx_10_6_intel.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b22ddf7e8255b1bab8d26f88c505932f011ccf5dc4a8bfeea0a8fbd507d87823 |
|
MD5 | d82b6d381087e90da7826575b6e882e9 |
|
BLAKE2b-256 | 34963f62aca149d607a529187dbb2dbaac6ce1cbabed71fcf9b7ea4a61318da8 |
Hashes for clickhouse_driver-0.1.0-cp27-cp27mu-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e3b49f6976af65149f2377257f7c678fe2d3d373e55cddae0d10e4aeaa543ab9 |
|
MD5 | 987987e13a233f932859240e8fc45426 |
|
BLAKE2b-256 | eb55b6bab80678ce53e985b0edc7638668ae7433717c3ae0d174a122f6fef378 |
Hashes for clickhouse_driver-0.1.0-cp27-cp27mu-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c619cb94d11b72d8e5500c1468404a78ac6fa3754a9ef35932028ee295e0c5c6 |
|
MD5 | f22406c4186cda609862224456216824 |
|
BLAKE2b-256 | d4d359810acf51a123d237375e78064261fdf61c4677e8578cf5283a93383760 |
Hashes for clickhouse_driver-0.1.0-cp27-cp27m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 262cb03435ba40424477408f84e6b776e2abd38488a9c8377d6b0e50cfbb4e99 |
|
MD5 | 7cae3409d81d9e084e5b71d414b81f90 |
|
BLAKE2b-256 | 7ac17ef157dfe5f68a2a1eb8f55ed2e409a54ffd2a4ee7df4ea91192789773d5 |
Hashes for clickhouse_driver-0.1.0-cp27-cp27m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 053330fc22684f8eb956befc9804639c780688c41510d2808c2b1f63bf38816f |
|
MD5 | 46367083fe5ba6eed58852fbf06fbe3a |
|
BLAKE2b-256 | 31f392e5bc18268a439c8e663128c15d728da03db6c8db22e4c2ddc7a2bdc1ee |
Hashes for clickhouse_driver-0.1.0-cp27-cp27m-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6327859c72cfa600e020bf6c7474c83e5d03055dbd8103a7da4b0d4bd7c3aacc |
|
MD5 | ede2cba00078f6d0a88bc8ea50416cfb |
|
BLAKE2b-256 | 43f8b6c4d7dbd03755cd4d4c0e49e87538ee3d8400a4ca4fec1971b7219191d2 |
Hashes for clickhouse_driver-0.1.0-cp27-cp27m-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d25076b494c4e0074ec50625464d7dd0928b44344c6e21d9999727617f6d503c |
|
MD5 | c8f94091c7629265b6580e29d865edfd |
|
BLAKE2b-256 | a17fb739292714da59fa290f4577fcc147dcfb3492029df2748290bd19091841 |
Hashes for clickhouse_driver-0.1.0-cp27-cp27m-macosx_10_6_intel.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 78788461d54482433e4ad509870227c0f156a30f33d759a0bd48aea2a240e662 |
|
MD5 | 6f20f5ca93040d3d23051fe08d3fa3c8 |
|
BLAKE2b-256 | cdd1cebcf07a3f497175fef035a94c0d02953b5d58edf5d6ebbd62c7e8080113 |