Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
BigQuery supports partitioned tables using pseudo columns "_PARTITIONDATE"
e.g. The following table has two columns you can select from but also partitions the data by creation date
CREATE or REPLACE TABLE #{table} (
transaction_id STRING,
order_date DATE )
PARTITION BY _PARTITIONDATE
The following queries cannot be validated
select * from #{table} where _PARTITIONDATE = '2020-11-03' ;
-- OR
select * from #{table} where _PARTITIONTIME = '2020-11-03' ;