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

DESCRIBE of fully qualified table fails when db and table name match and non-default database is in use

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.1
    • Fix Version/s: 2.0.0
    • Component/s: SQL
    • Labels:
      None
    • Hadoop Flags:
      Incompatible change
    • Release Note:
      Document the incompatible change.

      Description

      DESCRIBE of fully qualified table fails when db and table name match and non-default database is in use.

      Repro:

      : jdbc:hive2://localhost:10000/default> create database foo;
      No rows affected (0.116 seconds)
      0: jdbc:hive2://localhost:10000/default> create table foo.foo(i int);
      
      0: jdbc:hive2://localhost:10000/default> describe foo.foo;
      +-----------+------------+----------+--+
      | col_name  | data_type  | comment  |
      +-----------+------------+----------+--+
      | i         | int        |          |
      +-----------+------------+----------+--+
      1 row selected (0.049 seconds)
      
      0: jdbc:hive2://localhost:10000/default> use foo;
      
      0: jdbc:hive2://localhost:10000/default> describe foo.foo;
      Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Error in getting fields from serde.Invalid Field foo (state=08S01,code=1)
      

        Attachments

        1. HIVE-12184.patch
          3 kB
          Naveen Gangam
        2. HIVE-12184.9.patch
          203 kB
          Naveen Gangam
        3. HIVE-12184.8.patch
          203 kB
          Naveen Gangam
        4. HIVE-12184.7.patch
          201 kB
          Naveen Gangam
        5. HIVE-12184.6.patch
          201 kB
          Naveen Gangam
        6. HIVE-12184.5.patch
          156 kB
          Naveen Gangam
        7. HIVE-12184.4.patch
          152 kB
          Naveen Gangam
        8. HIVE-12184.3.patch
          26 kB
          Naveen Gangam
        9. HIVE-12184.2.patch
          3 kB
          Naveen Gangam
        10. HIVE-12184.10.patch
          203 kB
          Naveen Gangam
        11. HIVE-12184.10.patch
          203 kB
          Naveen Gangam

          Issue Links

            Activity

              People

              • Assignee:
                ngangam Naveen Gangam
                Reporter:
                lskuff Lenni Kuff
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: