Partition clause in SELECT Statement
I am trying to retrieve data from more than one partition in a Table.
SELECT * FROM TABLE_1 PARTITION(ABC,CDE);
I have found that we can apply the above statement as
SELECT * FROM TABLE_1 PARTITION(ABC)
UNION ALL
SELECT * FROM TABLE_1 PARTITION(CDE)
But I want to use it in a single select statement -> Is there a way to use multiple PARTITIONS in a single query
Thank you -