Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-1061

Unqualified implicit table alias does not work with '*' expr or views.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • Impala 1.3.1
    • Impala 1.4
    • None
    • None

    Description

      This query works as expected:

      select alltypes.id from fnuctional.alltypes
      

      This query does not work:

      [localhost:21000] > select alltypes.* from functional.alltypes;
      Query: select alltypes.* from functional.alltypes
      ERROR: AnalysisException: unknown table: alltypes
      

      This query also does not work:

      [localhost:21000] > select alltypes_view.id from functional.alltypes_view;
      Query: select alltypes_view.id from functional.alltypes_view
      ERROR: AnalysisException: unknown table alias: 'alltypes_view'
      

      Attachments

        Activity

          People

            alex.behm Alexander Behm
            alex.behm Alexander Behm
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: