ByteHouse Cloud Data Warehouse Version
ByteHouse Cloud Data Warehouse Version
- Documentation
ByteHouse Cloud Data Warehouse VersionUser guideConnect ByteHouseUse driversOverview
Copy page
Download PDFCopy pageDownload PDFByteHouse Cloud Data Warehouse Edition provides a wide range of connection driver tools to help you quickly access ByteHouse and carry out data development using different programming languages and frameworks. This article provides an introduction to the core features of the driver, the logic for selecting it, and important notes for its use.
You can connect ByteHouse and your application through a connection driver, supporting data query, data insertion, management, and other operations. Dimensions to consider when selecting a driver:
- Development language: Give priority to aligning with your technology stack, for example, select JDBC drivers for Java;
- Protocol compatibility: Must be consistent with the connection protocol of the ByteHouse service (TCP 19000, HTTP 8123, MySQL-compatible port 3306);
- Functional requirements: Consider whether support is needed for ByteHouse custom Settings, long connections (KeepAlive), and other features.
The following presents each driver's core information, grouped by development language, to help you select the connection driver you need.
Language | Driver name | Supported protocols | Recommended version | Default timeout period configuration | Is KeepAlive supported | Does ByteHouse support custom settings |
|---|---|---|---|---|---|---|
Java | TCP（19000） | It is recommended to use the latest version | ping_timeout：10s | Support project (supported by default) | Support project | |
HTTP（8123） | It is recommended to use version 0.4.6. | socket_timeout：30000ms | Supported, requires JDK11 | Support project | ||
TCP（3306） | It is recommended to use version 8.3.0 | connectTimeout：0 | Supported; requires JDK 11 | Not supported | ||
Golang | TCP（19000） | It is recommended to use V2 versions or any version earlier than V2.30.0. | TCP： | TCP (19000): Supported (supported by default) | Support project | |
TCP（3306） | It is recommended to use version 1.8.1 | timeout：0s | Support (supported by default) | Not supported | ||
Python | TCP（19000） | It is recommended to use version 0.2.9. | connect_timeout：10s | Support project | Support project | |
TCP（3306） | It is recommended to use version 1.1.2 | connect_timeout：10s | Support project | Not supported | ||
TCP（19000） | Suggestion to use | None | Support project | Support project | ||
None | Suggestion to use
| None | Not supported | Not supported | ||
C# | HTTP（8123） | It is recommended to use version 7.13.0. | Timeout：120s | Not supported | Support project | |
Rust | HTTP（8123） | It is recommended to use version 0.13.1 | send_timeout：None | Support project | Support project | |
PHP | HTTP（8123） | It is recommended to use version 1.6.0. | setConnectTimeOut：5s | Not supported | Support project |
In addition to the language-specific drivers mentioned above, ByteHouse also supports connectors for the following tools/frameworks, which are suitable for specific scenarios:
- ClickHouse NodeJSHTTP protocol driver for the Node.js environment that supports server-side JavaScript development scenarios.
- Flink Connector DriverFor data synchronization between the Flink real-time computing engine and ByteHouse, to satisfy streaming data processing requirements;
- Spark Connector DriverFor data interaction between the Spark batch processing engine and ByteHouse, adapted for offline big data analysis scenarios.
