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

Using a table alias which also appears as a column name is not possible

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.0.0-alpha-1
    • None
    • None

    Description

      drop table if exists tableA;
      drop table if exists tableB;
      
      create table tableA (a integer,z integer);
      create table tableB (a integer,b integer,z integer);
      
      select a.z, b.b 
      from tableB as b JOIN 
      tableA as a
      on a.a=b.b;
      
      Error: Error while compiling statement: FAILED: SemanticException Column a Found in more than One Tables/Subqueries (state=42000,code=40000)
      

      Attachments

        1. HIVE-19993.1.patch
          4 kB
          Jaume M
        2. HIVE-19993.2.patch
          2 kB
          Jaume M
        3. HIVE-19993.3.patch
          4 kB
          Jaume M

        Activity

          People

            jmarhuen Jaume M
            kgyrtkirk Zoltan Haindrich
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: