I think this is a known bug. casting the non-string column should work. See the below email thread (and HIVE-405) http://mail-archives.apache.org/mod_mbox/hadoop-hive-user/200904.mbox/browser
________________________________ From: Neil Conway <neil.con...@gmail.com> Reply-To: <hive-dev@hadoop.apache.org> Date: Sat, 2 May 2009 23:15:06 -0700 To: <hive-dev@hadoop.apache.org> Subject: Re: more ClassCastExceptions with joins, group by and non-strings On Sat, Apr 25, 2009 at 4:47 PM, Peter Alvaro <palv...@gmail.com> wrote: > create table bar ( > bas string--, > --bat double > ) > ROW FORMAT DELIMITED FIELDS TERMINATED BY '\174'; "bat" shouldn't be commented-out, if you want to use the provided test data. > It appears that queries with all three of (join, group by, non-string > datatype) cause a crash in the serde code run at the reducer: I can reproduce this issue with the trunk Hive code (+ Hadoop 0.19.1). Has anyone from the Hive team had a chance to investigate this? Thanks, Neil