Prasad, Thanks for the response. However, as far as I can tell, in the example query Peter gave we are already casting the non-string columns to string, but we're still seeing a ClassCastException. Any other suggestions?
Thanks, Neil On Sun, May 3, 2009 at 7:29 AM, Prasad Chakka <pcha...@facebook.com> wrote: > 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 > >
