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-unsubscr...@pinot.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
