Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-4362

Unable to parse queries that use BigQuery pseudo columns _PARTITIONDATE/_PARTITIONTIME

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: babel
    • Labels:
      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' ;

        Attachments

          Activity

            People

            • Assignee:
              julianhyde Julian Hyde
              Reporter:
              jswett Justin Swett

              Dates

              • Created:
                Updated:

                Issue deployment