[HIVE-4299] exported metadata by HIVE-3068 cannot be imported because of wrong file name

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.11.0
• Fix Version/s: 0.12.0
• Component/s: Query Processor
• Assignee: Edward Capriolo
• Reporter: Sho Shimauchi
• Created: 05/Apr/13 13:14
• Updated: 15/Oct/13 23:29
• Resolved: 20/Aug/13 14:56

Description

Symptom

When DROP TABLE a table, metadata of the table is generated to be able to import the dropped table again.
However, the exported metadata name is '<table name>.metadata'.
Since ImportSemanticAnalyzer allows only '_metadata' as metadata filename, user have to rename the metadata file to import the table.

How to reproduce

Set the following setting to hive-site.xml:

 <property>
   <name>hive.metastore.pre.event.listeners</name>
   <value>org.apache.hadoop.hive.ql.parse.MetaDataExportListener</value>
 </property>

Then run the following queries:

> CREATE TABLE test_table (id INT, name STRING);
> DROP TABLE test_table;
> IMPORT TABLE test_table_imported FROM '/path/to/metadata/file';
FAILED: SemanticException [Error 10027]: Invalid path

Issue Links

• is related to: HIVE-1918 Add export/import facilities to the hive system
• is related to: HIVE-3068 Add ability to export table metadata as JSON on table drop