hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Prabhu Joseph (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (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
Date Wed, 17 Dec 2014 04:27:13 GMT

    [ 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)

Mime
View raw message