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

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

          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: