Can you check the output of the query without the insert clause? SELECT COUNT(actor_id) AS value FROM activities WHERE ( account='80c27664-b047-4c0a-86f3-342c0cdf36c7' AND application='myproduct' AND dataset='purchase' AND hour=341165 )
Is it empty? On 12/10/08 1:08 AM, "Josh Ferguson" <[EMAIL PROTECTED]> wrote: > 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 >
