hen expand it to
> two joins and so on, this will help you isolate the issue.
>
> ** **
>
> Clay
>
> ** **
>
> ** **
>
> *From:* Nitin Pawar [mailto:nitinpawar...@gmail.com]
> *Sent:* Thursday, October 17, 2013 5:30 AM
> *To:* user@hive.apache.org
>
, 2013 5:30 AM
To: user@hive.apache.org
Subject: Re: Where clause position
Echoing wat Ed said,
its too hard to understand a 2 page query over an email .. so may be something
like
select * from (select blah from abc where condition)a join (select blah from
xyz where condition)b on (blah) where
Echoing wat Ed said,
its too hard to understand a 2 page query over an email .. so may be
something like
select * from (select blah from abc where condition)a join (select blah
from xyz where condition)b on (blah) where condition may help to understand
On Thu, Oct 17, 2013 at 2:51 PM, Ed Soniat
Would it be possible to simply this query removing as much as possible
keeping just enough to demonstrate the where issue.
On Wed, Oct 16, 2013 at 2:22 PM, Xiu Guo wrote:
> The following query does not work:
>
> SELECT
>
> T1.ACCOUNT_NUM
>
> ,T1.ACCOUNT_MODIFIER_NUM
>
> ,T1.DEPOSIT_TYPE_CD
>
>
The following query does not work:
SELECT
T1.ACCOUNT_NUM
,T1.ACCOUNT_MODIFIER_NUM
,T1.DEPOSIT_TYPE_CD
,T1.DEPOSIT_TERM
,CASE
WHEN T1.DEPOSIT_TYPE_CD='5021' THEN
'9255'
ELSE
CASE
WHEN T4.LEDGER_SUBJECT_ID_01= '' THEN ''
ELSE COALESCE(T4.LEDGER_SUBJECT_ID_01,'')
END
END V_LE