Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-29481

all the commands should look up catalog/table like v2 commands

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 3.0.0
    • None
    • SQL
    • None

    Description

      The newly added v2 commands support multi-catalog and respect the current catalog/namespace. However, it's not true for old v1 commands.

      This leads to very confusing behaviors, for example

      USE my_catalog
DESC t // success and describe the table t from my_catalog
ANALYZE TABLE t // report table not found as there is no table t in the session catalog

      We should make sure all the commands have the same behavior regarding table resolution

      Attachments

        1.
        		 REFRESH TABLE should look up catalog/table like v2 commands Sub-task Resolved Terry Kim
        2.
        		 ANALYZE TABLE should look up catalog/table like v2 commands Sub-task Resolved Wenchen Fan
        3.
        		 REPAIR TABLE should look up catalog/table like v2 commands Sub-task Resolved Terry Kim
        4.
        		 TRUNCATE TABLE should look up catalog/table like v2 commands Sub-task Resolved L. C. Hsieh
        5.
        		 UNCACHE TABLE should look up catalog/table like v2 commands Sub-task Resolved Terry Kim
        6.
        		 SHOW TBLPROPERTIES should look up catalog/table like v2 commands Sub-task Resolved Pablo Langa Blanco
        7.
        		 LOAD DATA INTO TABLE should look up catalog/table like v2 commands Sub-task Resolved L. C. Hsieh
        8.
        		 CACHE TABLE should look up catalog/table like v2 commands Sub-task Resolved L. C. Hsieh
        9.
        		 SHOW COLUMNS should look up catalog/table like v2 commands Sub-task Resolved Pablo Langa Blanco
        10.
        		 SHOW CREATE TABLE should look up catalog/table like v2 commands Sub-task Resolved L. C. Hsieh
        11.
        		 SHOW PARTITIONS should look up catalog/table like v2 commands Sub-task Resolved Huaxin Gao
        12.
        		 CREATE TABLE LIKE should look up catalog/table like v2 commands Sub-task In Progress Dilip Biswal
        13.
        		 ALTER TABLE (set partition location) should look up catalog/table like v2 commands Sub-task Resolved Terry Kim
        14.
        		 ALTER TABLE (RECOVER PARTITIONS) should look up catalog/table like v2 commands Sub-task Resolved Huaxin Gao
        15.
        		 ALTER TABLE (DROP PARTITION) should look up catalog/table like v2 commands Sub-task Resolved Huaxin Gao
        16.
        		 ALTER TABLE (RENAME PARTITION) should look up catalog/table like v2 commands Sub-task Resolved Huaxin Gao
        17.
        		 ALTER TABLE (add table partition) should look up catalog/table like v2 commands Sub-task Resolved Terry Kim
        18.
        		 ALTER TABLE (CHANGE COLUMN) should look up catalog/table like v2 commands Sub-task Resolved L. C. Hsieh
        19.
        		 ALTER TABLE (SerDe properties) should look up catalog/table like v2 commands Sub-task Resolved Huaxin Gao
        20.
        		 ALTER TABLE (RENAME TABLE) should look up catalog/table like v2 commands Sub-task Resolved Terry Kim
        21.
        		 ALTER VIEW QUERY should look up catalog/table like v2 commands Sub-task Resolved Huaxin Gao
        22.
        		 SHOW TABLE EXTENDED should look up catalog/table like v2 commands Sub-task Resolved Pablo Langa Blanco
        23.
        		 DESC DATABASE should look up catalog like v2 commands Sub-task Resolved Hu Fuwang
        24.
        		 ALTER DATABASE (SET DBPROPERTIES) should look up catalog like v2 commands Sub-task Resolved Hu Fuwang
        25.
        		 ALTER DATABASE (SET LOCATION) should look up catalog like v2 commands Sub-task Resolved Hu Fuwang
        26.
        		 CREATE (OR REPLACE) ... VIEW should look up catalog/table like v2 commands Sub-task Resolved Huaxin Gao
        27.
        		 SHOW FUNCTIONS should look up catalog/table like v2 commands Sub-task Resolved Pablo Langa Blanco
        28.
        		 DESCRIBE FUNCTION should look up catalog/table like v2 commands Sub-task Resolved Pablo Langa Blanco
        29.
        		 CREATE FUNCTION should look up catalog/table like v2 commands Sub-task Resolved Pablo Langa Blanco
        30.
        		 DROP FUNCTION should look up catalog/table like v2 commands Sub-task Resolved Pablo Langa Blanco
        31.
        		 create TEMPORARY VIEW USING should look up catalog/table like v2 commands Sub-task Resolved Unassigned
        32.
        		 ADD/LIST Resources should look up catalog/table like v2 commands Sub-task Open Unassigned

        Activity

          People

            Unassigned Unassigned
            cloud_fan Wenchen Fan
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated: