Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-4350

support AS keyword for table alias

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.10.0, 0.11.0
    • Fix Version/s: 0.12.0
    • Component/s: SQL
    • Labels:
      None
    • Release Note:
      Support AS keyword for table alias.

      Description

      SQL standard supports AS optional keyword, while creating an table alias.

      http://savage.net.au/SQL/sql-92.bnf.html#table reference

      Hive gives a error when the optional keyword is used -
      select * from tiny as t1;
      org.apache.hive.service.cli.HiveSQLException: Error while processing statement: FAILED: ParseException line 1:19 mismatched input 'as' expecting EOF near 'tiny'

        Attachments

        1. HIVE-4350.D10503.1.patch
          2 kB
          Phabricator
        2. HIVE-4350.D10503.2.patch
          2 kB
          Phabricator
        3. HIVE-4350.D10503.3.patch
          4 kB
          Phabricator

          Activity

            People

            • Assignee:
              mweaverh Matthew Weaver
              Reporter:
              thejas Thejas Nair
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: