在python 3.14 容器中安裝和使用chdb包
更新時間：2026年02月14日 14:01:19 作者：l1t
文章介紹了如何在Python容器中使用chdb包進行ClickHouse數(shù)據(jù)庫的查詢,本文給大家講解的非常詳細,對大家的學習或工作具有一定的參考借鑒價值,需要的朋友參考下吧
1.docker exec -it登錄容器用pip install 命令安裝
sudo docker exec -it python3143 bash
root@DESKTOP-59T6U68:/# pip install chdb
Looking in indexes: https://pypi.tuna.tsinghua.edu.cn/simple
Collecting chdb
Downloading https://pypi.tuna.tsinghua.edu.cn/packages/23/28/f3aa551b4af78b8ac967c191407301eff5906dc7239ddb232d4d34bf8ad4/chdb-4.0.1-cp39-abi3-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (149.4 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 149.4/149.4 MB 31.3 MB/s 0:00:04
Collecting pandas<3.0.0,>=2.1.0 (from chdb)
Downloading https://pypi.tuna.tsinghua.edu.cn/packages/15/b2/0e62f78c0c5ba7e3d2c5945a82456f4fac76c480940f805e0b97fcbc2f65/pandas-2.3.3-cp314-cp314-manylinux_2_24_x86_64.manylinux_2_28_x86_64.whl (12.3 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 12.3/12.3 MB 51.4 MB/s 0:00:00
Collecting pyarrow>=13.0.0 (from chdb)
Downloading https://pypi.tuna.tsinghua.edu.cn/packages/9c/86/95c61ad82236495f3c31987e85135926ba3ec7f3819296b70a68d8066b49/pyarrow-23.0.0-cp314-cp314-manylinux_2_28_x86_64.whl (47.6 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 47.6/47.6 MB 33.8 MB/s 0:00:01
Collecting numpy>=1.26.0 (from pandas<3.0.0,>=2.1.0->chdb)
Downloading https://pypi.tuna.tsinghua.edu.cn/packages/5d/6c/7f237821c9642fb2a04d2f1e88b4295677144ca93285fd76eff3bcba858d/numpy-2.4.2-cp314-cp314-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl (16.6 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 16.6/16.6 MB 43.4 MB/s 0:00:00
Collecting python-dateutil>=2.8.2 (from pandas<3.0.0,>=2.1.0->chdb)
Downloading https://pypi.tuna.tsinghua.edu.cn/packages/ec/57/56b9bcc3c9c6a792fcbaf139543cee77261f3651ca9da0c93f5c1221264b/python_dateutil-2.9.0.post0-py2.py3-none-any.whl (229 kB)
Collecting pytz>=2020.1 (from pandas<3.0.0,>=2.1.0->chdb)
Downloading https://pypi.tuna.tsinghua.edu.cn/packages/81/c4/34e93fe5f5429d7570ec1fa436f1986fb1f00c3e0f43a589fe2bbcd22c3f/pytz-2025.2-py2.py3-none-any.whl (509 kB)
Collecting tzdata>=2022.7 (from pandas<3.0.0,>=2.1.0->chdb)
Downloading https://pypi.tuna.tsinghua.edu.cn/packages/c7/b0/003792df09decd6849a5e39c28b513c06e84436a54440380862b5aeff25d/tzdata-2025.3-py2.py3-none-any.whl (348 kB)
Collecting six>=1.5 (from python-dateutil>=2.8.2->pandas<3.0.0,>=2.1.0->chdb)
Downloading https://pypi.tuna.tsinghua.edu.cn/packages/b7/ce/149a00dd41f10bc29e5921b496af8b574d8413afcd5e30dfa0ed46c2cc5e/six-1.17.0-py2.py3-none-any.whl (11 kB)
Installing collected packages: pytz, tzdata, six, pyarrow, numpy, python-dateutil, pandas, chdb
Successfully installed chdb-4.0.1 numpy-2.4.2 pandas-2.3.3 pyarrow-23.0.0 python-dateutil-2.9.0.post0 pytz-2025.2 six-1.17.0 tzdata-2025.3
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager, possibly rendering your system unusable. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv. Use the --root-user-action option if you know what you are doing and want to suppress this warning.
[notice] A new release of pip is available: 25.3 -> 26.0.1
[notice] To update, run: pip install --upgrade pip2.導入后就可以用chdb.query查詢
root@DESKTOP-59T6U68:/# python3
Python 3.14.3 (main, Feb 4 2026, 20:08:31) [GCC 14.2.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import chdb
>>> res = chdb.query('select version()', 'Pretty'); print(res)
┏━━━━━━━━━━━┓
┃ version() ┃
┡━━━━━━━━━━━┩
1. │ 25.8.2.1 │
└───────────┘
>>> res = chdb.query('select * from file("/par/duck.parquet", Parquet)'); print(res)
"13522500"
>>> res = chdb.query('select * from file("/par/duck.parquet", Parquet)','Pretty'); print(res)
┏━━━━━━━━━━┓
┃ mpz_sum ┃
┡━━━━━━━━━━┩
1. │ 13522500 │
└──────────┘
>>>
>>> res = chdb.query('select * from file("/par/duck.parquet", Parquet)', 'JSON'); print(res)
{
"meta":
[
{
"name": "mpz_sum",
"type": "Nullable(String)"
}
],
"data":
[
{
"mpz_sum": "13522500"
}
],
"rows": 1,
"statistics":
{
"elapsed": 0.037387861,
"rows_read": 0,
"bytes_read": 0
}
}
>>> res = chdb.query('select * from file("/par/duck.parquet", Parquet)','PrettyCompact'); print(res)
┌─mpz_sum──┐
1. │ 13522500 │
└──────────┘上面查詢了版本號和Parquet文件，query的第二個參數(shù)用來指定不同的格式，不加參數(shù)默認是無標題的字符串，加PrettyCompact參數(shù)才是clickhouse客戶端默認的格式。
如果要查詢帶\r的tsv文件，需要設置參數(shù)input_format_tsv_crlf_end_of_line，clickhouse客戶端中有兩種方式，一種是單獨用set命令設置，另一種是在查詢語句中用SETTINGS子句。
:) set input_format_tsv_crlf_end_of_line=true;
SET input_format_tsv_crlf_end_of_line = true
Query id: 60a7f1df-aad9-41fc-b100-d2c507da7949
Ok.
0 rows in set. Elapsed: 0.009 sec.
:) select * from file('/mnt/c/d/data/cxy.tsv', Tsv) ;
SELECT *
FROM file('/mnt/c/d/data/cxy.tsv', Tsv)
Query id: 5246c40d-2915-412c-8f28-97912d88e14f
┌─id─┬─name────┬─language───┐
1. │ 1 │ Joe │ Java │
2. │ 2 │ Alice │ JavaScript │
3. │ 3 │ Leon │ C/C++ │
4. │ 4 │ William │ Java │
5. │ 5 │ James │ C/C++ │
6. │ 6 │ Enson │ C/C++ │
└────┴─────────┴────────────┘
6 rows in set. Elapsed: 0.067 sec.
:) set input_format_tsv_crlf_end_of_line=false;
SET input_format_tsv_crlf_end_of_line = false
Query id: 591cf022-de92-4165-80e1-9744b8bdf93c
Ok.
0 rows in set. Elapsed: 0.000 sec.
:) select * from file('/mnt/c/d/data/cxy.tsv', Tsv) ;
SELECT *
FROM file('/mnt/c/d/data/cxy.tsv', Tsv)
Query id: d56dd6fe-b217-4c0b-b3a0-344202ed0fd9
Elapsed: 0.071 sec.
Received exception:
Code: 117. DB::Exception:
You have carriage return (\r, 0x0D, ASCII 13) at end of first row.
It's like your input data has DOS/Windows style line separators, that are illegal in TabSeparated format. You must transform your file to Unix format.
But if you really need carriage return at end of string value of last column, you need to escape it as \r
or else enable setting 'input_format_tsv_crlf_end_of_line': (while reading header): (in file/uri /mnt/c/d/data/cxy.tsv): While executing ParallelParsingBlockInputFormat: While executing File. (INCORRECT_DATA)
:)
:) select * from file('/mnt/c/d/data/cxy.tsv', Tsv) settings input_format_tsv_crlf_end_of_line =true;
SELECT *
FROM file('/mnt/c/d/data/cxy.tsv', Tsv)
SETTINGS input_format_tsv_crlf_end_of_line = true
Query id: 6bb8ec95-c597-4716-aee3-b60a001c76f2
┌─id─┬─name────┬─language───┐
1. │ 1 │ Joe │ Java │
2. │ 2 │ Alice │ JavaScript │
3. │ 3 │ Leon │ C/C++ │
4. │ 4 │ William │ Java │
5. │ 5 │ James │ C/C++ │
6. │ 6 │ Enson │ C/C++ │
└────┴─────────┴────────────┘
6 rows in set. Elapsed: 0.008 sec.
:) \q
Bye.在python中只能用后一種
>>> import chdb
>> res = chdb.query('select * from file("/par/data/cxy.tsv", Tsv)','Pretty'); print(res)
Traceback (most recent call last):
File "<python-input-7>", line 1, in <module>
res = chdb.query('select * from file("/par/data/cxy.tsv", Tsv)','Pretty'); print(res)
File "/usr/local/lib/python3.14/site-packages/chdb/__init__.py", line 205, in query
res = conn.query(sql, output_format, params=params)
RuntimeError: Code: 636. DB::Exception: The table structure cannot be extracted from a Tsv format file. Error:
Code: 117. DB::Exception:
You have carriage return (\r, 0x0D, ASCII 13) at end of first row.
It's like your input data has DOS/Windows style line separators, that are illegal in TabSeparated format. You must transform your file to Unix format.
But if you really need carriage return at end of string value of last column, you need to escape it as \r
or else enable setting 'input_format_tsv_crlf_end_of_line'. (INCORRECT_DATA) (version 25.8.2.1).
You can specify the structure manually: (in file/uri /par/data/cxy.tsv). (CANNOT_EXTRACT_TABLE_STRUCTURE)
>>> res = chdb.query('select * from file("/par/data/cxy.tsv", Tsv) settings input_format_tsv_crlf_end_of_line=true','Pretty'); print(res)
┏━━━━┳━━━━━━━━━┳━━━━━━━━━━━━┓
┃ id ┃ name ┃ language ┃
┡━━━━╇━━━━━━━━━╇━━━━━━━━━━━━┩
1. │ 1 │ Joe │ Java │
├────┼─────────┼────────────┤
2. │ 2 │ Alice │ JavaScript │
├────┼─────────┼────────────┤
3. │ 3 │ Leon │ C/C++ │
├────┼─────────┼────────────┤
4. │ 4 │ William │ Java │
├────┼─────────┼────────────┤
5. │ 5 │ James │ C/C++ │
├────┼─────────┼────────────┤
6. │ 6 │ Enson │ C/C++ │
└────┴─────────┴────────────┘
>>>
>>> res = chdb.query('select * from file("/par/data/cxy.tsv", Tsv) settings input_format_tsv_crlf_end_of_line=true','PrettyCompact'); print(res)
┌─id─┬─name────┬─language───┐
1. │ 1 │ Joe │ Java │
2. │ 2 │ Alice │ JavaScript │
3. │ 3 │ Leon │ C/C++ │
4. │ 4 │ William │ Java │
5. │ 5 │ James │ C/C++ │
6. │ 6 │ Enson │ C/C++ │
└────┴─────────┴────────────┘
>>> chdb.query('select * from file("/par/data/cxy.tsv", Tsv) settings input_format_tsv_crlf_end_of_line=true','PrettyCompact')
┌─id─┬─name────┬─language───┐
1. │ 1 │ Joe │ Java │
2. │ 2 │ Alice │ JavaScript │
3. │ 3 │ Leon │ C/C++ │
4. │ 4 │ William │ Java │
5. │ 5 │ James │ C/C++ │
6. │ 6 │ Enson │ C/C++ │
└────┴─────────┴────────────┘查詢結(jié)果可存入變量，然后用print()輸出，也可以執(zhí)行查詢時直接輸出。
到此這篇關(guān)于在python 3.14 容器中安裝和使用chdb包的文章就介紹到這了,更多相關(guān)python安裝和使用chdb包內(nèi)容請搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！
相關(guān)文章
Python整合Milvus向量數(shù)據(jù)庫的實戰(zhàn)指南
在向量數(shù)據(jù)庫技術(shù)快速發(fā)展的今天,Milvus作為開源領(lǐng)域的領(lǐng)軍產(chǎn)品,正成為AI應用開發(fā)的重要基礎(chǔ)設施,本章將深入講解Python與Milvus向量數(shù)據(jù)庫的整合實踐,感興趣的小伙伴可以了解下2025-05-05
這篇文章主要介紹了如何用python寫個模板引擎，幫助大家更好的理解和使用python，感興趣的朋友可以了解下2021-01-01
使用tf.keras.MaxPooling1D出現(xiàn)錯誤問題及解決
這篇文章主要介紹了使用tf.keras.MaxPooling1D出現(xiàn)錯誤問題及解決方案，具有很好的參考價值，希望對大家有所幫助。如有錯誤或未考慮完全的地方，望不吝賜教2022-12-12
Python3使用QT編寫基礎(chǔ)的對話框程序的詳細流程
Qt框架憑借其跨平臺能力和豐富的控件庫,在桌面應用開發(fā)領(lǐng)域占據(jù)重要地位,當Python的簡潔語法遇上Qt的成熟生態(tài),便誕生了PyQt/PySide這兩個黃金搭檔,本文給大家介紹了Python3如何使用QT編寫基礎(chǔ)的對話框程序,需要的朋友可以參考下2025-06-06
今天小編就為大家分享一篇Django forms表單 select下拉框的傳值實例。具有很好的參考價值，希望對大家有所幫助。一起跟隨小編過來看看吧2019-07-07
python實現(xiàn)簡易版學生成績管理系統(tǒng)
這篇文章主要為大家詳細介紹了python實現(xiàn)簡易版學生成績管理系統(tǒng)，文中示例代碼介紹的非常詳細，具有一定的參考價值，感興趣的小伙伴們可以參考一下2020-06-06
這篇文章主要介紹了python基于Selenium的web自動化框架，文中通過示例代碼介紹的非常詳細，對大家的學習或者工作具有一定的參考學習價值，需要的朋友們下面隨著小編來一起學習學習吧2019-07-07
這篇文章主要介紹了python 繪制斜率圖進行對比分析的實例，幫助大家更好的理解和學習使用python，感興趣的朋友可以了解下2021-03-03
下面小編就為大家?guī)硪黄狿ython的IDEL增加清屏功能實例。小編覺得挺不錯的，現(xiàn)在就分享給大家，也給大家做個參考。一起跟隨小編過來看看吧2017-06-06
基于Pyinstaller打包Python程序并壓縮文件大小
這篇文章主要介紹了基于Pyinstaller打包Python程序并壓縮文件大小,文中通過示例代碼介紹的非常詳細，對大家的學習或者工作具有一定的參考學習價值,需要的朋友可以參考下2020-05-05