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.2-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a91d2c02e6957386429c48fd429e6a1d412c19faed24dcc4b1c21efc389ddf21 |
|
MD5 | fd82fa02e5142a2421de0d2d212b68f7 |
|
BLAKE2b-256 | 559951e61c191f3a540d2d4267e91fe31d33170369b7973506f9f1c152fb5a17 |
Hashes for clickhouse_driver-0.1.2-cp38-cp38-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 09b88e2dd69f5034a8bad3d89285195933c2d316e7a97fa83553fd426cd1bf77 |
|
MD5 | a61b65bdfba458cb7fd93cfcec65c67c |
|
BLAKE2b-256 | d5bafea9a366d944e03105469972ed64fc3d9a933bd50932ae6a86ca9516a89d |
Hashes for clickhouse_driver-0.1.2-cp38-cp38-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5afc85412772831a1517d2dac37373e358283aeca557c0c200614063316555a9 |
|
MD5 | 160dc717e27eabc4cbc0882164b0d071 |
|
BLAKE2b-256 | f971d20c18e974c92e771e4a73a5baff1181d035c67e49cce2391174acc8d5c4 |
Hashes for clickhouse_driver-0.1.2-cp38-cp38-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d38a148230624dba68963654350be154c70a823c21a9dfbc2b21349d7eaa0591 |
|
MD5 | 8821a8cc0d6ef97cc2aa7b56e6d637c8 |
|
BLAKE2b-256 | 99054d1e45978093aca3b1059dcd034db977230db7e2cdd3e7956ada6c386dcd |
Hashes for clickhouse_driver-0.1.2-cp38-cp38-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 96a7ad2157a676aeeb8fec5e3e1c3183fd2c7e597521fab1d0df6ea1e5d5fd0b |
|
MD5 | fdabf28f35bbae15961eeec0ff58a4da |
|
BLAKE2b-256 | 497e29f5258c41686aa6d722a6addda173b4acc5d299815997512b6265d740de |
Hashes for clickhouse_driver-0.1.2-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5310cff52fd19453d6c0fdd11384d139a1291c921084333d23d44cbd02d14081 |
|
MD5 | dfcafa3d4950aa87a0e159bcbd3aaf3b |
|
BLAKE2b-256 | d289b15161cae72df486a676f6c88b7628aaf96bb7273fb570278ad522b33ff2 |
Hashes for clickhouse_driver-0.1.2-cp37-cp37m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ca93e180fbe580adeff3f2fc3f2361bf4554c09a18208f487e5454cfc43d5560 |
|
MD5 | 6ef2e245f9e60a91fd762ebf0957f12d |
|
BLAKE2b-256 | 84b807c3db2a7bb42104ad8439a022482f0791b0305bba4e163d8fa0a92721a3 |
Hashes for clickhouse_driver-0.1.2-cp37-cp37m-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9e8c8db399ee59a0cba729b5a4e54074c3475cc8f3d0784ddc7eaf0bfc6b5d0b |
|
MD5 | 4e8eafd9a70b6f702fd10b22a26256c6 |
|
BLAKE2b-256 | 5227713ef12bb88f2b4fae2e928a91a898a74b74906286fbf4a0491a2f5d1bc4 |
Hashes for clickhouse_driver-0.1.2-cp37-cp37m-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 639e38fe82ebdd7d48cb501e2bbdcb4d4ccb833b2cb4095ba163f244c15e7a0e |
|
MD5 | d01789de693723a35bff0ce405a56f35 |
|
BLAKE2b-256 | 7be81e1457ce2e4667d9b6013dc872086a1157d944ac42ca1b3d720c10f5a94a |
Hashes for clickhouse_driver-0.1.2-cp37-cp37m-macosx_10_6_intel.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 249eab1f45cfe111a669dcf6586987a8da9cebea1864e36a7d1315fc5d600a53 |
|
MD5 | d15320c407eb7490c4d98bb16dd78d35 |
|
BLAKE2b-256 | e678a434a6eae525d01994e37949be804fac928841b06417e295ce76b3e3e6ac |
Hashes for clickhouse_driver-0.1.2-cp36-cp36m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3d120b85ba785a4141c8d5e89f114ec66f405d53f335897abaa982f0a412f758 |
|
MD5 | 9acbba8920e2bf313e3e93e4f50f7cb1 |
|
BLAKE2b-256 | b2deefc2df51ed4651541ea494b229feb724634d8e990d31fa53e4a62e923f67 |
Hashes for clickhouse_driver-0.1.2-cp36-cp36m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | cf5066136b6b32650e60528ed1e93e49b17001ef00038046e6161cf3b9c2b714 |
|
MD5 | 5e830d47587fe2f8396bc1217d40b640 |
|
BLAKE2b-256 | 8295a4eb6560af2f0b6ef6d8ae50d823bb06c9f49f29cd2b103d908b80818fe7 |
Hashes for clickhouse_driver-0.1.2-cp36-cp36m-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e540f32ab5e77b04c76fa07d72d98d2e78d71697c26558b54a02e00607bb098c |
|
MD5 | e9706c5eef3914d446330dcd4e0bcd2d |
|
BLAKE2b-256 | 0549df9c2509eb813eda2a5138cdcdcadb233668f6cde081dc203b65ec87a8e5 |
Hashes for clickhouse_driver-0.1.2-cp36-cp36m-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 439da03af2c223bc73c830634c15217aae502d39a7cfd2e3d67f3de97174a428 |
|
MD5 | 9637d3cdb7d1ea8d9a11b3654399cb4a |
|
BLAKE2b-256 | 0c849047cc44161ef857f97294b40422c55348bf28709172280103b901e864fa |
Hashes for clickhouse_driver-0.1.2-cp36-cp36m-macosx_10_6_intel.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2b7b890b812a2a83dd14f5345b6d06d58f058b5f53bfbe84525fc914932deaf7 |
|
MD5 | c80a9472e4c89cc8b5babf626d2be1ec |
|
BLAKE2b-256 | faa5cd6e14e17603f89e66b8ff19bad9e224635a03de1e116fec86cb045a871c |
Hashes for clickhouse_driver-0.1.2-cp35-cp35m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9adf449a13198c06d87a089fdbfe5b6d96ef95d5fc6a741c926533c8fff8b365 |
|
MD5 | 75ce713b150b732287ebf7ab493d1dca |
|
BLAKE2b-256 | be085f87fff1c11ff512fa1bfc0d5d2a8d21c5f0ba941800c1656d1b9528d326 |
Hashes for clickhouse_driver-0.1.2-cp35-cp35m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d0dcdad9806b9462b7ad5dddb3fd469d1e2c91adbc1e8dccca55f1a25cdd4ad0 |
|
MD5 | 7bc5978612befbed7c9ea221f4b2b15b |
|
BLAKE2b-256 | 01348f1d73e8cbea18fb625e285bcb36704f0be8628d00e9687339e414f98443 |
Hashes for clickhouse_driver-0.1.2-cp35-cp35m-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fa037fdafd864cbe5b8d55b14da3cd7e5e734b543629a10da638d2b87056e37f |
|
MD5 | c13ffbb67aa344fe17ba485265ae9333 |
|
BLAKE2b-256 | ba2d3c75dc2de1ad5862c160590e22b7a3089a42b74fd542dd7e4a86b4ee0682 |
Hashes for clickhouse_driver-0.1.2-cp35-cp35m-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7d3ea3e7f8b2de3b88522901447ed73922d3c86fb3291192c8d0b04c1b818d4d |
|
MD5 | 3842d066df4b43cbef3af68fd91bf6ed |
|
BLAKE2b-256 | 8739339b8466c2d20dee685a71cc6c98b22a7616862537f173c676d734d2587c |
Hashes for clickhouse_driver-0.1.2-cp35-cp35m-macosx_10_6_intel.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 654e5026509e8c78e8ac767aaf8375bfd49588a5c1aec1697f9693558e6788e9 |
|
MD5 | 83fa76509880ed0c3b7e8150cbe4ab41 |
|
BLAKE2b-256 | 6c31630011f0fef75a3fb201dfbf6f119e82729aa1c19f116500642af7bface5 |
Hashes for clickhouse_driver-0.1.2-cp34-cp34m-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | abdcfe24881257a5a4a5a67c41163fd34cc18e8bd17f6fe2439f79abd43c62ae |
|
MD5 | 5a93b9af355f0d0eeca117be4438356b |
|
BLAKE2b-256 | cf38bd8e21cff5d8dad0e12e13bb327e0b51d3034635eb539d297935870b4df1 |
Hashes for clickhouse_driver-0.1.2-cp34-cp34m-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bdd963d7223faa9ccc54cec4511aace876dd87994602ce12cc1410826d60a4e5 |
|
MD5 | 0e5bbe8ced0de0e440b8a85223875058 |
|
BLAKE2b-256 | 11fc5e40d9de4e4df6f72efbf926bcc959050c509877a71906fca4022716f2ac |
Hashes for clickhouse_driver-0.1.2-cp34-cp34m-macosx_10_6_intel.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9d74645e24a1539984a1ca206a74d63246284afad49809c4f321e1c3491daaa4 |
|
MD5 | 0e06378a2662c9d478bc0b46bf6e8fba |
|
BLAKE2b-256 | be86bb51bae48591ed44c55daa702ffae275e784cc11cb9f623e44cc5cf9b677 |
Hashes for clickhouse_driver-0.1.2-cp27-cp27mu-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0831a93759f7fc576b49c5c9b70e8ca35a72a327f28fa84248268119e51be309 |
|
MD5 | 24eb9de61bee08e84c917e8c409d0801 |
|
BLAKE2b-256 | 2d50be79dfa7074e893bc3cab9ed9b8ab61b9930c899094ef622187c24df4169 |
Hashes for clickhouse_driver-0.1.2-cp27-cp27mu-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 36ce63f8679e09f1b2e627c17cc26c7f40b69e69c21bb8c642241f855071f3b7 |
|
MD5 | bf601dd6506f87b857beb7b24fc4b856 |
|
BLAKE2b-256 | 0fa8ab0b41faecdc64dd7eafe3c7236b3b0dbf8ee43f756ebd13dddbda2d80bd |
Hashes for clickhouse_driver-0.1.2-cp27-cp27m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2fb45f4a9fda53887f4504e7846e9428ea2146f39747ec26e4611221b112511b |
|
MD5 | 8cc578dd3519f373a66e0fe08733bafe |
|
BLAKE2b-256 | 8109cc142fda2dc4ac4c8347023562250221046555e4bba5d86066f8f2b1793c |
Hashes for clickhouse_driver-0.1.2-cp27-cp27m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c40a96b02b56f08112631124883dad885e80755668856f78c57889213208587d |
|
MD5 | 068fbde8da023482122b2241db697f3f |
|
BLAKE2b-256 | 9b8213f7a646d7de75fb62e218aa5f651d2951b36bea34da609f99e831b2b514 |
Hashes for clickhouse_driver-0.1.2-cp27-cp27m-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ed457cdebb8852bd2551300b1a681e078c4c01dccb1244fbb324cb63dbc0c3b3 |
|
MD5 | 41526a375bfe0c8c4384808303757c8d |
|
BLAKE2b-256 | 5b478c88d69410704481929d54b8452169ce270be31edfacb9113f44e010395b |
Hashes for clickhouse_driver-0.1.2-cp27-cp27m-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c5b39b521e15071dd7be02b9c26c1dff38f470caf976740ccd1a21e9f2a110e1 |
|
MD5 | 9d6724e4aa224a1730e1953fda01e7e8 |
|
BLAKE2b-256 | 0c06ff73a83b6fc2ea73e0d368305e0a10a58d7a8a96358be4ca83e7ef26dfde |
Hashes for clickhouse_driver-0.1.2-cp27-cp27m-macosx_10_6_intel.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a8145c1fcb7b13ff2a3bfdee3a1a459b7d1535fabd57128f3c93133cd7493c1d |
|
MD5 | 00b3af25d6bb3faf5953f690f78b3ce6 |
|
BLAKE2b-256 | 4dac2e7e2e71391131527e7b6269e13a0d90b4ac4b61083a510b17c7a930f604 |