AndyN5 opened a new issue, #14887:
URL: https://github.com/apache/pinot/issues/14887
## Description
If any query options are provided, Apache Pinot presently limits queries
using the `SELECT *` syntax. Because of this restriction, users are unable to
use query options and execute simple exploratory queries that obtain every
field in the dataset.
In some situations where default options or particular query behaviours are
necessary, working with huge datasets becomes difficult due to the inability to
execute `SELECT *` queries with additional query options.
## Expected Behaviour:
Even with query options set, `SELECT *` queries need to be permitted.
- All of the dataset's fields should be returned by the query while
following the given parameters.
## Actual Behaviour:
When `SELECT *` is used with query options, an error occurs.
## How to Make It Again
1. In Pinot, write a `SELECT *` query.
2. Include any query parameter, such a timeout or a particular optimisation
parameter.
3. Run the query.
4. Take note of the error message stating that using query options with
`SELECT *` is prohibited.
## Proposed Resolution
To enable `SELECT *` queries with query options, modify the Pinot query
execution engine. Make sure you apply every query option without affecting the
retrieval of every field.
## Extra Background
Usability for analytics and data exploration workflows is impacted by this
problem. When working with Pinot, allowing such enquiries improves the user
experience and flexibility.
## References:
[#11422] is a related pull request.Pull 11422
(https://github.com/apache/pinot)
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
