Skip to content

Latest commit

 

History

History
20 lines (12 loc) · 886 Bytes

flightsql.md

File metadata and controls

20 lines (12 loc) · 886 Bytes
Raw

Flight SQL

InfluxDB IOx supports running SQL queries via Apache Arrow Flight SQL

You can use either a native FlightSQL client as well as JDBC / ODBC Flight SQL drivers

JDBC:

To use the JDBC driver with IOx:

  1. Download the driver by following the link from Maven or Dremio
  2. Use a jdbc conection of the format: jdbc:arrow-flight-sql://hostname:port?useEncryption=false&database=NAME

hostname:port is the host / port on which the IOx query gRPC API is running (default port is 8082), and NAME is the database name (for example, 26f7e5a4b7be365b_917b97a92e883afc)

An example JDBC URL is:

jdbc:arrow-flight-sql://localhost:8082?useEncryption=false&database=26f7e5a4b7be365b_917b97a92e883afc