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

["Justin Swett (Jira)" <ji...@apache.org>]

Justin Swett created CALCITE-4362:
-------------------------------------

             Summary: Unable to parse queries that use BigQuery pseudo columns _PARTITIONDATE/_PARTITIONTIME
                 Key: CALCITE-4362
                 URL: https://issues.apache.org/jira/browse/CALCITE-4362
             Project: Calcite
          Issue Type: Bug
          Components: babel
            Reporter: Justin Swett


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
{code:java}
CREATE or REPLACE TABLE #{table} (            
  transaction_id STRING, 
  order_date DATE )
PARTITION BY _PARTITIONDATE
{code}
 

The following queries cannot be validated 
{code:java}
select * from #{table} where _PARTITIONDATE = '2020-11-03' ;
-- OR
select * from #{table} where _PARTITIONTIME = '2020-11-03' ;{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)