Kotlin / Kotlin/dataframe

Add Apache Pinot® as supported database

Open
#637 5 comments 4 reactions 1 assignee Claimed by @zaleslaw View on GitHub
databases enhancement
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.