apache / apache/pinot

Support database concept to create like dbname.tablename

Open
#7,072 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
6.1k
Forks
1.5k
Avg merge
1d 21h
Merged PRs (30d)
189

Description

Hi,

Need support something like Mysql where we can have multiple databases and same table inside it...
i.e., dbName.TableName

{
****"tableName": "myDb.myTable",****
"tableType": "OFFLINE",
"segmentsConfig": {
"timeColumnName": "outgoingName",
"timeType": "DAYS",
"retentionTimeUnit": "DAYS",
"retentionTimeValue": "365",
"segmentPushType": "APPEND",
"segmentAssignmentStrategy": "BalanceNumSegmentAssignmentStrategy",
"replication": "3"
},
"tenants": {
"broker": "brokerOne",
"server": "serverOne"
},
"tableIndexConfig": {
"loadMode": "HEAP",
"invertedIndexColumns": [
"column1",
"column2"
]
},
"metadata": {
"customConfigs": {
}
}
}

when i tested using above config to create table config, i got below error,

**{"code":400,"error":"Table name: 'myDb.myTable_OFFLINE' containing '.' or space is not allowed"}**

Please provide support for database concept, where i can create multi database with same/different table names

@xiangfu0

Thanks
Akram Syed

Contributor guide

Open the contributing guide

Research direction

The issue names no files, tests, or entry points; begin by tracing Pinot's table-name validation that rejects periods and reviewing how table names are represented. Done means Pinot supports creating and addressing tables with database-qualified names while preserving the requested same/different table-name behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql
Domain
backend, databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.