[HIVE-4286] When I run `CREATE TABLE new_table LIKE avro_table`, the schema does not get mapped properly from an Avro schema to a Hive schema

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Uri Laserson
• Created: 02/Apr/13 22:52
• Updated: 17/Dec/14 04:26

Description

I have an Avro-backed table called vcf_flat. I run the following commands from the Hive shell:

CREATE TABLE vcf_flat_whitelisted LIKE vcf_flat;
ALTER TABLE vcf_flat_whitelisted SET FILEFORMAT SEQUENCEFILE;

No errors, and I can see the table when I run `SHOW TABLES;`:

hive> SHOW TABLES;
OK
cosmic
dbsnp
sample_07
sample_08
vcf_flat
vcf_flat_text
vcf_flat_whitelisted
Time taken: 0.061 seconds

However, this is the output for `DESCRIBE vcf_flat_whitelisted`:

FAILED: SemanticException [Error 10001]: Table not found vcf_flat_whitelisted