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

Support AS STRUCT syntax to create named STRUCT in SQL similar to Google BigQuery

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • core
    • None

    Description

      See Google BigQuery grammar.

      We want to support something like the following:

      SELECT STRUCT(a as first_name, b as last_name, STRUCT(c as zip code, d as
      street, e as state) as address) as record FROM example_table
      

      Attachments

        Issue Links

          Activity

            People

              suez1224 Shuyi Chen
              suez1224 Shuyi Chen
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: