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

Reply via email to