[
https://issues.apache.org/jira/browse/HIVE-4286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14249447#comment-14249447
]
Prabhu Joseph commented on HIVE-4286:
-------------------------------------
Hi Uri Laserson, Which hive version this issue reproduced ?. In Hive 0.14,
altering table itself throws error,
ERROR exec.DDLTask: org.apache.hadoop.hive.ql.metadata.HiveException: at
least one column must be specified for the table
> 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
> ---------------------------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-4286
> URL: https://issues.apache.org/jira/browse/HIVE-4286
> Project: Hive
> Issue Type: Bug
> Reporter: Uri Laserson
>
> 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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
