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 <[email protected]> Reply-To: <[email protected]> Date: Sat, 2 May 2009 23:15:06 -0700 To: <[email protected]> Subject: Re: more ClassCastExceptions with joins, group by and non-strings On Sat, Apr 25, 2009 at 4:47 PM, Peter Alvaro <[email protected]> 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
