Download Apache Pinot JDBC Driver

Download the Apache Pinot JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

About the Apache Pinot JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to Apache Pinot. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each Apache Pinot driver uses its own syntax — see the connection details below.

The Apache Pinot JDBC driver

Apache Pinot is a distributed, real-time OLAP datastore built for low-latency analytics on large-scale event streams. It is designed to ingest data from sources like Apache Kafka and query it with sub-second latency, making it popular for user-facing analytics applications. Pinot's columnar storage and inverted indexes enable high-throughput, high-concurrency analytical queries.

The Apache Pinot JDBC URL

• Required File(s): pinot-jdbc-client-xxx.jar
• Java Driver Class: org.apache.pinot.client.PinotDriver
• JDBC URL: jdbc:pinot://{HOST}:{PORT}
• Website: Apache Pinot

Connect to the Pinot Broker on port 9000. The JDBC driver is part of the Pinot client distribution and can be obtained from the Apache Pinot release artifacts or Maven Central. Authentication and TLS settings can be configured via additional JDBC URL parameters.

Connecting to Apache Pinot

Pinot's JDBC driver connects to the controller, not to a broker — which is the opposite of what most people assume, since brokers are what answer queries.

1. Use the controller port, 9000. The URL is jdbc:pinot://controller-host:9000. The driver asks the controller which brokers exist and then queries them, so a URL aimed straight at a broker on 8099 does not work.
2. Make the brokers reachable too. Because the driver is redirected to brokers on 8099, opening only the controller port is not enough — both have to be reachable from your machine. On a cluster where brokers advertise internal host names, name them explicitly with the brokers= parameter.
3. Name the tenant if the cluster uses more than one. The optional tenant= parameter selects which broker tenant serves the queries; DefaultTenant is the usual value.
4. Open port 9000 in the server's firewall. The database listens on port 9000 unless it was installed with a different one. A host firewall on the server blocks incoming connections on that port until a rule allows them. The firewall guide has the commands for Windows, ufw, firewalld and iptables.
5. Connect from DbSchema. In the Connection Dialog choose Remote computer or custom port, fill in the server host and the port, then press Test Connection to check that the server answers before you connect.

DbSchema and Apache Pinot

DbSchema connects to Apache Pinot via the Pinot JDBC driver, letting teams visualize real-time OLAP schemas, explore segment contents, and write low-latency analytical SQL queries through an interactive editor.