Help wanted!
The following content of this documentation page has been machine-translated. But unlike other websites, it is not done on the fly. This translated text lives on GitHub repository alongside main ClickHouse codebase and waits for fellow native speakers to make it more human-readable. You can also use the original English version as a reference.
jdbc
jdbc(jdbc_connection_uri, schema, table)
- retourne la table qui est connectée via le pilote JDBC.
Ce tableau fonction nécessite séparé clickhouse-jdbc-bridge
programme en cours d'exécution.
Il prend en charge les types Nullable (basé sur DDL de la table distante qui est interrogée).
Exemple
SELECT * FROM jdbc('jdbc:mysql://localhost:3306/?user=root&password=root', 'schema', 'table')
SELECT * FROM jdbc('mysql://localhost:3306/?user=root&password=root', 'schema', 'table')
SELECT * FROM jdbc('datasource://mysql-local', 'schema', 'table')