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.1-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2dc3b1a2de4c49e15d2fc312a767739d557acced6c3f5eb5157128f986f76c87 |
|
MD5 | 98afc8e7a4a09573c11e90c1b6cc1781 |
|
BLAKE2b-256 | 9dd5ac9fb013be5ee00562f836b4b020ce50d05a2acaf697513d4e0d23c424f0 |
Hashes for clickhouse_driver-0.1.1-cp37-cp37m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 24da2397685084c6a89ce0180a2531b956b51e7bc568719b72115c93dd7aceb5 |
|
MD5 | cec1a669e82453c5ff89d6c555700cdb |
|
BLAKE2b-256 | 51aec6a8a42590b69bbc80b58b6aec570ded83c37e88a3babab7635600bf22a7 |
Hashes for clickhouse_driver-0.1.1-cp37-cp37m-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c660e926cde2f2d4d62e151370af35810efde9c5293c615aaf57df8ce07134f0 |
|
MD5 | 4546f1e5ea9501eca0e6f707b48024fe |
|
BLAKE2b-256 | 4b71ce2e5619b338df40c5472a6389b202eb33edbed8483c47b2f5e0301e09b5 |
Hashes for clickhouse_driver-0.1.1-cp37-cp37m-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6c576d9e219f7157ebc3034e12a774ce10644b0fab7d6739ba42eff35b637d2d |
|
MD5 | d03bb52e4a8f466fb6eb7d5b16fc24d6 |
|
BLAKE2b-256 | 720302c2bf83ba8f2af6f291feaeed75e175d5ef664087bbe02e2b9c977b10c4 |
Hashes for clickhouse_driver-0.1.1-cp37-cp37m-macosx_10_6_intel.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 809297f575a683cfa5637dca7693d3cb8d192d2aa5d2cb5515fdb534994438d4 |
|
MD5 | b99a4e3b5493a8bfeea883cc173ea64b |
|
BLAKE2b-256 | 829452588453b75bbb7ebe289ff36b719b55c0c991fbbc59ba8ea7e44a12dfdd |
Hashes for clickhouse_driver-0.1.1-cp36-cp36m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d149420e1894ee8458cb68ce951085e117a573edeb54221ce9ad9558524826e4 |
|
MD5 | ad3421ad82539b92fc9b0db485dafb31 |
|
BLAKE2b-256 | 05591d994d47fe738a68ffc9bbb0020cb8500deca93145aa48d1e0c48ac0ba06 |
Hashes for clickhouse_driver-0.1.1-cp36-cp36m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6fa6bea25ada2031e0db39378e678cdc4dcd6ea8bb668b6fc7f4961948762a4c |
|
MD5 | fc1d079b4417118c17a342088db6da60 |
|
BLAKE2b-256 | 4fcf095057f212712049b991c1fee93f0d491f28eb435d945ea103d33b885ce7 |
Hashes for clickhouse_driver-0.1.1-cp36-cp36m-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3527ee02999afa6c89435fb3c2aad69b1dd2abf7038e891ae0b485d6271caa5c |
|
MD5 | d2e8dd73f97120b157c34773442971c6 |
|
BLAKE2b-256 | df96c749e17b36511ac3125d3101006eea355f56f3f7acef4e0b31e42d8bf525 |
Hashes for clickhouse_driver-0.1.1-cp36-cp36m-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f60d89a78883c1bedae3a3d53d11d2ec3e931cc760100d48d88b464a22447d46 |
|
MD5 | 40c54c0b5780061eb391e711695628c6 |
|
BLAKE2b-256 | 9f606842b695818d10f41265a36be7a3defc270201b5fa3a35c5cb3d8f4cb367 |
Hashes for clickhouse_driver-0.1.1-cp36-cp36m-macosx_10_6_intel.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9c2ac19adefb74b46fafa1b0c9e6c8a4c280115344f639a2962fb305078e06a3 |
|
MD5 | 6bc03a5e047a9891c3a63141cfe020ce |
|
BLAKE2b-256 | 4b8b7cd9d9133cb9ed58384041d6342fe9ddfdd0e256c7022e557b0242199043 |
Hashes for clickhouse_driver-0.1.1-cp35-cp35m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ed2f6ab2becc778dcd41b0f819b5e87a96fc12d88fd12b25a72cccea3717643d |
|
MD5 | 7858aa3ee867472bfa1accb3e04c37a1 |
|
BLAKE2b-256 | 73d145b4a2e0215dab273cfbaaa8e6afea61e6f281e8a0668814c31cf090513e |
Hashes for clickhouse_driver-0.1.1-cp35-cp35m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f1e3befddf441adf745f908b5689a4c23b3b722c0befb6cad44994683f008715 |
|
MD5 | 9ed84e2544c3f5d11cc0b95cbfc73d47 |
|
BLAKE2b-256 | 2f6f01e5fab9828d666de25a51f73522865ff555353e932efd64eabf5c306d8f |
Hashes for clickhouse_driver-0.1.1-cp35-cp35m-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bb4d84ef2c6a1f0e2ac644fcabb49d2d1032ccb8a7b39f8d130117c7e9053eaf |
|
MD5 | f98a9c3caf1eea0901c69b03c8d46a4e |
|
BLAKE2b-256 | 340b52fed8f39966ce3200f10eaec4aa8db5f86d106ee4041f92bc3cf2bf9fd8 |
Hashes for clickhouse_driver-0.1.1-cp35-cp35m-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 11e38019a7cf17930364487ddc6939ffa5b22400051e0ce8ab972ad9c1023615 |
|
MD5 | f24177197e840b4ed05f8d9dcfee9ed1 |
|
BLAKE2b-256 | 3551fb19b07d4993e0d69d63b7043334cfc6a2f4325a04cceca9d51b884747d9 |
Hashes for clickhouse_driver-0.1.1-cp35-cp35m-macosx_10_6_intel.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 283dcf152244d2daf20fcf8afb7367783560c62bf5574c1ccaf1f9f38c1f354e |
|
MD5 | 063bb9f31208778ec927645d90c0fcb5 |
|
BLAKE2b-256 | 4f5861adbd942d12fa2ad14133ba3c9efe01faa0dbf687014a2ded82d3c51e4b |
Hashes for clickhouse_driver-0.1.1-cp34-cp34m-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a0d0189cab127f7921e7f19ad844c4779868569c302562750696c55fed65aac1 |
|
MD5 | f11dcde2bb6c935874b0bf5d803d4509 |
|
BLAKE2b-256 | 143adf8db462fed8df154e19306b8c34da29283caa1cfca17297fb6299832731 |
Hashes for clickhouse_driver-0.1.1-cp34-cp34m-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e5f8e9d6d16d92a88eb161a3b075d216526c8be20c1369bad1ff508c92fea62e |
|
MD5 | ea49224171acb4468298852e67fb3331 |
|
BLAKE2b-256 | 1dee999d4c167792c52e9b60204b16aed199f867b802b4efe7005e0b96d3017b |
Hashes for clickhouse_driver-0.1.1-cp34-cp34m-macosx_10_6_intel.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 593ba593e6a163125ef9764b2da97ae355e7fe079232b82e9c48b9180fa6d536 |
|
MD5 | c1e4798561032f0af8682461c48d18ea |
|
BLAKE2b-256 | b120c0e6fbd895ed27d3c119286117a5f44f84ce49df197b9d970cb88d3de943 |
Hashes for clickhouse_driver-0.1.1-cp27-cp27mu-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b38483bfeb8e260627cac92dcb0d2bfbdd97d38422f75b192f2282062743ebfd |
|
MD5 | 61749a8cc43da95426336c8f93e18bde |
|
BLAKE2b-256 | 2a9389c7b633e99df318e0ad19f9de99a498217601d7c8e05c708c89729a0d9f |
Hashes for clickhouse_driver-0.1.1-cp27-cp27mu-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6dd64b6f9356f5ba5ed27b0d2df0dd9311bd8607685f03e9cd18875027554839 |
|
MD5 | 0be9020c2c71f2f1a753ee918ff2a7c2 |
|
BLAKE2b-256 | caf91bbdb64c4729952e1392c0670863a3390c650857867c01f772eed6ac7b7f |
Hashes for clickhouse_driver-0.1.1-cp27-cp27m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c1b08a9145b8f669b9ce97a38956f69d946683d8ab4befa0a0e1bbfb8a2cb246 |
|
MD5 | 21aa316437c4803146bdf8c3b3618920 |
|
BLAKE2b-256 | 35f86cdf5fec8250206844eb03ee683ec732c211bffe178e6cbdab6073821802 |
Hashes for clickhouse_driver-0.1.1-cp27-cp27m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 97f44447c9a7fd2cff9d4ff75fe80af8f174d4ffbdd542433924647af7679800 |
|
MD5 | 4932f20e0a63d7405f25f037ba0510ee |
|
BLAKE2b-256 | a4d6a725ab06625adaabfb4d06df1cb1edec2d2bd5e01ed1d5dfce7639310e51 |
Hashes for clickhouse_driver-0.1.1-cp27-cp27m-manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8ca1f62f7a49b85222b6b4b5963eb059e99920d90c477b042970c762728b1462 |
|
MD5 | 4b0ebf6098e5db30cfbc6ddd4d7d4024 |
|
BLAKE2b-256 | c0cc8d97de1b25cb2fc62b05e3a1ab063e075acf2eab87ce0b1c2c244af23e83 |
Hashes for clickhouse_driver-0.1.1-cp27-cp27m-manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 86c708d72881b21d5958fdd5559a6c54a483045d13f3d6e23ffab6f5132da7c2 |
|
MD5 | 64d2ae80c4c9ad78478cd799efba496c |
|
BLAKE2b-256 | f75ca03fc4955e02240072fe5e04a09b5ef97a4575e18298241fd5a7b1a8ad6c |
Hashes for clickhouse_driver-0.1.1-cp27-cp27m-macosx_10_6_intel.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d3c9ab20eeacd39598757916a5186fe45f6fd5047ce54251cf95ab1d788f61a0 |
|
MD5 | b8295fddfa35ac221d27497570436860 |
|
BLAKE2b-256 | 8881a79d96efa668e88bb2f2f9887eee5eb1ac005dec66d0a68a839279d68d81 |