[CALCITE-4362] Unable to parse queries that use BigQuery pseudo columns _PARTITIONDATE/_PARTITIONTIME

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: babel
• Assignee: Julian Hyde
• Reporter: Justin Swett
• Created: 28/Oct/20 21:06
• Updated: 16/Nov/22 09:38

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' ;