Johndee Burks created HIVE-9056:
-----------------------------------
Summary: 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.13.0, 0.12.0
Environment: CDH5.2
Reporter: Johndee Burks
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)
