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

DESCRIBE TABLE syntax doesn't support specifying a database qualified table name

    XMLWordPrintableJSON

    Details

    • Hadoop Flags:
      Reviewed

      Description

      The syntax for DESCRIBE is broken. It should be:

      DESCRIBE [EXTENDED] [database DOT]table [column]

      but is actually

      DESCRIBE [EXTENDED] table[DOT col_name]

      Ref: http://dev.mysql.com/doc/refman/5.0/en/describe.html

        Attachments

        1. HIVE-1977.1.patch.txt
          53 kB
          Zhenxiao Luo
        2. HIVE-1977.2.patch.txt
          51 kB
          Zhenxiao Luo
        3. HIVE-1977.3.patch.txt
          51 kB
          Zhenxiao Luo
        4. HIVE-1977.4.patch.txt
          50 kB
          Zhenxiao Luo
        5. HIVE-1977.5.patch.txt
          51 kB
          Zhenxiao Luo
        6. HIVE-1977.6.patch.txt
          30 kB
          Zhenxiao Luo

          Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-3589 describe/show partition/show tblproperties command should accept database name

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. HIVE-4064 Handle db qualified names consistently across all HiveQL statements

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-2228 Can't use DB qualified column names in WHERE or GROUP BY clauses

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-1517 ability to select across a database

          • Blocker - Blocks development and/or testing work, production could not run
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-2290 Improve error messages for DESCRIBE command

          • Major - Major loss of function.
          • Closed

            Activity

              People

              • Assignee:
                zhenxiao Zhenxiao Luo
                Reporter:
                cwsteinbach Carl Steinbach
              • Votes:
                0 Vote for this issue
                Watchers:
                17 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: