You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Chaoyu Tang (JIRA)" <ji...@apache.org> on 2014/12/11 20:43:14 UTC

[jira] [Resolved] (HIVE-9056) Describe Avro Table Partition Fails

     [ https://issues.apache.org/jira/browse/HIVE-9056?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chaoyu Tang resolved HIVE-9056.
-------------------------------
    Resolution: Cannot Reproduce

> Describe Avro Table Partition Fails
> -----------------------------------
>
>                 Key: HIVE-9056
>                 URL: https://issues.apache.org/jira/browse/HIVE-9056
>             Project: Hive
>          Issue Type: Bug
>          Components: CLI
>    Affects Versions: 0.12.0, 0.13.0
>         Environment: CDH5.2
>            Reporter: Johndee Burks
>            Assignee: Chaoyu Tang
>            Priority: Minor
>
> If you describe a partition of a table that is avro then you get the schema error. 
> {code}
> DROP TABLE IF EXISTS episodes_partitioned;
> CREATE TABLE episodes_partitioned
> PARTITIONED BY (doctor_pt INT)
> ROW FORMAT
> SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
> STORED AS
> INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
> OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
> TBLPROPERTIES ('avro.schema.literal'='{
>   "namespace": "testing.hive.avro.serde",
>   "name": "episodes",
>   "type": "record",
>   "fields": [
>     {
>       "name":"title",
>       "type":"string",
>       "doc":"episode title"
>     },
>     {
>       "name":"air_date",
>       "type":"string",
>       "doc":"initial date"
>     },
>     {
>       "name":"doctor",
>       "type":"int",
>       "doc":"main actor playing the Doctor in episode"
>     }
>   ]
> }');
> ALTER TABLE episodes_partitioned ADD PARTITION (doctor_pt=4);
> DESC episodes_partitioned  PARTITION (doctor_pt=4);
> {code}
> You will get the error: 
> {code}
> error_error_error_error_error_error_error	string              	from deserializer
> cannot_determine_schema	string              	from deserializer
> check               	string              	from deserializer
> schema              	string              	from deserializer
> url                 	string              	from deserializer
> and                 	string              	from deserializer
> literal             	string              	from deserializer
> doctor_pt           	int
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)