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

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.17.0
    • Fix Version/s: 1.18.0
    • Component/s: None
    • Labels:

      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

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

                Dates

                • Created:
                  Updated:
                  Resolved: