hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Johndee Burks (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-9056) Describe Avro Table Partition Fails
Date Tue, 09 Dec 2014 21:38:12 GMT
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)

Mime
View raw message