walterddr opened a new issue, #10825:
URL: https://github.com/apache/pinot/issues/10825
currently, we are not 100% supported for TPC-H syntax. we would like to
track our progress towards TPC-H here
1. run TPC-H data loading and TPC-H queries in integration test (See: #9559)
- disable the ones that are not supported
- [ ] add query dbgen dataset for TPC-H
- [ ] add query with properly filled in parameters for TPC-H (we don't
support parametric replacement at the moment)
2. add features and TPC-H query supported
- [ ] DateTime functions are not supported (e.g. `orderdate < date
'2000-01-01' + interval '3' month`)
- [ ] some JOIN filter parsing (e.g. `(a=b AND c > 0) OR (a=b AND d <
0)` doesn't get converted to `a=b AND (c > 0 OR d < 0)`)
- [ ] logical correlate
- [ ] single-value sub query join (`WHERE EXIST (SELECT ...)`, `WHERE a
> (SELECT COUNT(*) FROM ...)`)
- [ ] table view not supported
CC @ankitsultana @kishoreg @xiangfu0
--
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]
