Add Apache Pinot® as supported database
- Dominant language
- Kotlin
- Stars
- 1.1k
- Forks
- 83
- Avg merge
- 4d 12h
- Merged PRs (30d)
- 30
Description
**Description**
As part of our ongoing efforts to expand the range of databases supported by the Kotlin DataFrame project, I propose adding support for [Apache Pinot®](https://pinot.apache.org/). Apache Pinot® is a real-time distributed OLAP datastore designed to deliver scalable real-time analytics with low latency. It can ingest data from batch and stream data sources in real time, making it a versatile choice for real-time analytics applications.
```kotlin
import org.jetbrains.kotlinx.dataframe.io.DatabaseConfiguration
import org.jetbrains.kotlinx.dataframe.api.print
import java.sql.DriverManager
val url = "jdbc:pinot://localhost:9000?brokers=localhost:8099"
val dbConfig = DatabaseConfiguration(url)
var dataFrame = DataFrame.readMySqlTable(dbConfig, "order_items_enriched", 10)
dataFrame.print()
```
getting error
```
Unsupported database type in the url: jdbc:pinot:localhost#8099. Only H2, MariaDB, MySQL, SQLite and PostgreSQL are supported!
java.lang.IllegalArgumentException: Unsupported database type in the url: jdbc:pinot:localhost#8099. Only H2, MariaDB, MySQL, SQLite and PostgreSQL are supported!
```
Contributor guide
Assessment
This issue has not been assessed yet.