Re: Re: join on different data type

2015-05-06 Thread @Sanjiv Singh
Vijayaraghavan > *Date:* 2015-05-04 16:10 > *To:* user > *CC:* r7raul1...@163.com > *Subject:* Re: join on different data type > > > If A.col1 is of DOUBLE type, > > but B.col2 is of BIGINT, > > > The automatic conversion is not acceptable according to the java l

Re: Re: join on different data type

2015-05-04 Thread r7raul1...@163.com
IF join on A.col1 == B.col2 col1 is string col2 is bigint The automatic conversion is support? All cast to string? r7raul1...@163.com From: Gopal Vijayaraghavan Date: 2015-05-04 16:10 To: user CC: r7raul1...@163.com Subject: Re: join on different data type > If A.col1 is of DOUBLE t

Re: Re: join on different data type

2015-05-04 Thread r7raul1...@163.com
Thank you! r7raul1...@163.com From: Gopal Vijayaraghavan Date: 2015-05-04 16:10 To: user CC: r7raul1...@163.com Subject: Re: join on different data type > If A.col1 is of DOUBLE type, > but B.col2 is of BIGINT, The automatic conversion is not acceptable according to the java la

Re: join on different data type

2015-05-04 Thread Gopal Vijayaraghavan
> If A.col1 is of DOUBLE type, > but B.col2 is of BIGINT, The automatic conversion is not acceptable according to the java language spec (section 5.1.2) https://docs.oracle.com/javase/specs/jls/se7/html/jls-5.html#jls-5.1.2 Also to be noted here is that in general, that even if you cast, you