Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-6562

Support implicit table references for nested fields in SQL

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.3.0, 1.4.0
    • Component/s: Table API & SQL
    • Labels:
      None

      Description

      Currently nested fields can only be accessed through fully qualified identifiers. For example, users need to specify the following query for the table f that has a nested field foo.bar

      SELECT f.foo.bar FROM f
      

      Other query engines like Hive / Presto supports implicit table references. For example:

      SELECT foo.bar FROM f
      

      This jira proposes to support the latter syntax in the SQL API.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                wheat9 Haohui Mai
                Reporter:
                wheat9 Haohui Mai
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: