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

Database prefix does not work properly if table has same name

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: 2.0.0
    • Component/s: Database/Schema
    • Labels:
      None

      Description

      If you do the following it will fail:

      0: jdbc:hive2://cdh54-1.test.com:10000/defaul> create database test4; 
      No rows affected (0.881 seconds) 
      0: jdbc:hive2://cdh54-1.test.com:10000/defaul> use test4; 
      No rows affected (0.1 seconds) 
      0: jdbc:hive2://cdh54-1.test.com:10000/defaul> create table test4 (c1 char(200)); 
      No rows affected (0.306 seconds) 
      0: jdbc:hive2://cdh54-1.test.com:10000/defaul> desc test4.test4; 
      Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. cannot find field test4 from [0:c1] (state=08S01,code=1)
      

        Attachments

        1. HIVE-11241.patch
          0.7 kB
          Ferdinand Xu

          Issue Links

            Activity

              People

              • Assignee:
                Ferd Ferdinand Xu
                Reporter:
                johndee Johndee Burks
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: