You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by "vrajat (via GitHub)" <gi...@apache.org> on 2025/05/27 11:11:56 UTC
[I] MSE does not parse Fully-Qualified Table Names [pinot]
vrajat opened a new issue, #15911:
URL: https://github.com/apache/pinot/issues/15911
_Case 1: fully-qualified table name does errors out with MSE. (Error is 190=TableDoesNotExistError)_
```
❯ curl --request POST http://localhost:8000/query/sql -d '{"sql": "select count(*) from meeshoOfflineTables.events", "queryOptions":"useMultiStageEngine=true"}' | jq ".resultTable"
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 1492 100 1391 100 101 22836 1658 --:--:-- --:--:-- --:--:-- 24866
null
```
Case 2: fully-qualified table name works with SSE
```
❯ curl --request POST http://localhost:8000/query/sql -d '{"sql": "select count(*) from meeshoOfflineTables.events"}' | jq ".resultTable"
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 1321 100 1263 100 58 27722 1273 --:--:-- --:--:-- --:--:-- 29355
{
"dataSchema": {
"columnNames": [
"count(*)"
],
"columnDataTypes": [
"LONG"
]
},
"rows": [
[
1000
]
]
}
```
Case 3: Table name with database in header works with MSE
```
❯ curl --request POST -H "database: meeshoOfflineTables" http://localhost:8000/query/sql -d '{"sql": "select count(*) from events", "queryOptions":"useMultiStageEngine=true"}' | jq ".resultTable"
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 2231 100 2150 100 81 44056 1659 --:--:-- --:--:-- --:--:-- 46479
{
"dataSchema": {
"columnNames": [
"EXPR$0"
],
"columnDataTypes": [
"LONG"
]
},
"rows": [
[
1000
]
]
}
```
Case 4: Database in header works with SSE
```
❯ curl --request POST -H "database: meeshoOfflineTables" http://localhost:8000/query/sql -d '{"sql": "select count(*) from events"}' | jq ".resultTable"
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 1300 100 1262 100 38 94270 2838 --:--:-- --:--:-- --:--:-- 97k
{
"dataSchema": {
"columnNames": [
"count(*)"
],
"columnDataTypes": [
"LONG"
]
},
"rows": [
[
1000
]
]
}
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
Re: [I] MSE does not parse Fully-Qualified Table Names [pinot]
Posted by "vrajat (via GitHub)" <gi...@apache.org>.
vrajat commented on issue #15911:
URL: https://github.com/apache/pinot/issues/15911#issuecomment-2913133778
I had a offline discussion and the actual bug is in SSE (case 2) and not case 1.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
Re: [I] SSE allows queries on tables in a different database with Fully-Qualified Table Names [pinot]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #15911:
URL: https://github.com/apache/pinot/issues/15911#issuecomment-4300860852
This issue has been closed because it has been inactive for 180 days. If you believe this issue is still relevant, please feel free to reopen it or create a new issue. Thank you!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
Re: [I] SSE allows queries on tables in a different database with Fully-Qualified Table Names [pinot]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #15911:
URL: https://github.com/apache/pinot/issues/15911#issuecomment-4114559774
This issue has been automatically marked as stale because it has not had any activity in the last 150 days. It will be closed in 30 days if no further activity occurs. If this issue is still relevant, please leave a comment to keep it open. Thank you for your contributions!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
Re: [I] SSE allows queries on tables in a different database with Fully-Qualified Table Names [pinot]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #15911: SSE allows queries on tables in a different database with Fully-Qualified Table Names
URL: https://github.com/apache/pinot/issues/15911
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org