Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-7527

DROP METADATA doesn't work with table name starting with '/' inside workspace

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.17.0
    • 1.18.0
    • None

    Description

      Description:

      • create parquet table with CTAS: CREATE TABLE dfs.tmp.`folder/file` AS SELECT * FROM cp.`employee.json`;
      • refresh metadata for table: ANALYZE TABLE dfs.tmp.`folder/file` REFRESH METADATA;
      • drop metadata: ANALYZE TABLE dfs.tmp.`/folder/file` DROP METADATA [IF EXISTS];

      Expexted result:
      Metadata for table [folder/file] dropped.
      Actual result:
      Error: VALIDATION ERROR: Metadata for table [/folder/file] not found.

      Shoud work as DROP TABLE:
      DROP TABLE dfs.tmp.`/folder/file`;
      Table [folder/file] dropped

      Attachments

        Issue Links

          Activity

            People

              volodymyr Vova Vysotskyi
              denysord88 Denys Ordynskiy
              Bohdan Kazydub Bohdan Kazydub
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: