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

Reply via email to