Can you do a describe extended PARTITION
and describe extended activities and post the results.. Ashish ________________________________ From: Josh Ferguson [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2008 1:09 AM To: [email protected] Subject: Re: Failed Query I should say this is during the last reduction step that occures in this query Josh On Dec 10, 2008, at 1:06 AM, Josh Ferguson wrote: This Query INSERT OVERWRITE TABLE aggregations PARTITION ( account='80c27664-b047-4c0a-86f3-342c0cdf36c7', application='myproduct', dataset='purchase', hour=341165, aggregation='count', aggregated_by='all' ) SELECT COUNT(actor_id) AS value FROM activities WHERE ( account='80c27664-b047-4c0a-86f3-342c0cdf36c7' AND application='myproduct' AND dataset='purchase' AND hour=341165 ) Generates this message java.lang.RuntimeException: Error while closing operators: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.hadoop.hive.serde2.SerDeException: org.apache.hadoop.hive.serde2.SerDeException: Trying to serialize 0 fields into a struct with 1 at org.apache.hadoop.hive.ql.exec.ExecReducer.close(ExecReducer.java:202) at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java:440) at org.apache.hadoop.mapred.Child.main(Child.java:155) Josh Ferguson
