[ https://issues.apache.org/jira/browse/HIVE-9056?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14240553#comment-14240553 ]
Chaoyu Tang commented on HIVE-9056: ----------------------------------- [~johndee] I could not reproduce this error in Hive trunk. The output I got for DESC episodes_partitioned PARTITION (doctor_pt=4) is {code} title string from deserializer air_date string from deserializer doctor int from deserializer doctor_pt int # Partition Information # col_name data_type comment doctor_pt int {code} > 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)