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

mixed case tablename on lefthand side of LATERAL VIEW results in query failing with confusing error message

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.6.0
    • 0.7.0
    • Query Processor
    • None

    Description

      For the modified query below in lateral_view.q, the exception "org.apache.hadoop.hive.ql.parse.SemanticException: line 3:7 Invalid Table Alias or Column Reference myCol" is thrown. The query should succeed.

      SELECT myCol from tmp_PYANG_lv LATERAL VIEW explode(array(1,2,3)) myTab as myCol limit 3;

      Attachments

        1. HIVE-1857.1.patch
          17 kB
          John Sichi

        Activity

          People

            jvs John Sichi
            jvs John Sichi
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: