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.

        Issue Links

          Activity

          Hide
          githubbot ASF GitHub Bot added a comment -

          GitHub user haohui opened a pull request:

          https://github.com/apache/flink/pull/3879

          FLINK-6562 Support implicit table references for nested fields in SQL.

          You can merge this pull request into a Git repository by running:

          $ git pull https://github.com/haohui/flink FLINK-6562

          Alternatively you can review and apply these changes as the patch at:

          https://github.com/apache/flink/pull/3879.patch

          To close this pull request, make a commit to your master/trunk branch
          with (at least) the following in the commit message:

          This closes #3879


          commit 5ab697d32afa584a8683107006233889275ca73c
          Author: Haohui Mai <wheat9@apache.org>
          Date: 2017-05-11T22:35:39Z

          FLINK-6562 Support implicit table references for nested fields in SQL.


          Show
          githubbot ASF GitHub Bot added a comment - GitHub user haohui opened a pull request: https://github.com/apache/flink/pull/3879 FLINK-6562 Support implicit table references for nested fields in SQL. You can merge this pull request into a Git repository by running: $ git pull https://github.com/haohui/flink FLINK-6562 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/flink/pull/3879.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #3879 commit 5ab697d32afa584a8683107006233889275ca73c Author: Haohui Mai <wheat9@apache.org> Date: 2017-05-11T22:35:39Z FLINK-6562 Support implicit table references for nested fields in SQL.
          Hide
          githubbot ASF GitHub Bot added a comment -

          Github user fhueske commented on the issue:

          https://github.com/apache/flink/pull/3879

          Thanks for the PR @haohui. Looks good to me.
          I'll replace the test and extend `CompositeAccessTest` before merging.

          Show
          githubbot ASF GitHub Bot added a comment - Github user fhueske commented on the issue: https://github.com/apache/flink/pull/3879 Thanks for the PR @haohui. Looks good to me. I'll replace the test and extend `CompositeAccessTest` before merging.
          Hide
          githubbot ASF GitHub Bot added a comment -

          Github user asfgit closed the pull request at:

          https://github.com/apache/flink/pull/3879

          Show
          githubbot ASF GitHub Bot added a comment - Github user asfgit closed the pull request at: https://github.com/apache/flink/pull/3879
          Hide
          fhueske Fabian Hueske added a comment -

          Fixed for 1.3 with f49edf58ed0cb0e72394375fa63167c2d7bd907d
          Fixed for 1.4 with 88d56a9ce46ae0b7d73b64e340c2f59e76f79bf3

          Show
          fhueske Fabian Hueske added a comment - Fixed for 1.3 with f49edf58ed0cb0e72394375fa63167c2d7bd907d Fixed for 1.4 with 88d56a9ce46ae0b7d73b64e340c2f59e76f79bf3

            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:

                Development