Support database concept to create like dbname.tablename
- 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
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