search

prestodb / presto

The official home of the Presto distributed SQL query engine for big data
http://prestodb.io
Apache License 2.0
16.04k stars 5.38k forks source link

Support `INTERSECT ALL` and `EXCEPT ALL` #15698

Open rongrong opened 3 years ago

rongrong commented 3 years ago

Trino introduced this feature: https://github.com/trinodb/trino/pull/5890

vasantteja commented 3 years ago

Can you please assign this to me?

dqmdev commented 1 year ago

Presto documentation implies supported, but not implemented. https://prestodb.io/docs/current/sql/select.html

Error: Query failed (#20230509_232558_07966_af77a): line 1:39: INTERSECT ALL not yet implemented SQLState:  null ErrorCode: 1

Error: Query failed (#20230509_232612_07967_af77a): line 1:39: EXCEPT ALL not yet implemented SQLState:  null ErrorCode: 1

image

bearownage commented 8 months ago

Can't tell if this has been completed, if not, could I try this?

tdcmeehan commented 8 months ago

@bearownage this has not been completed