Click here to Skip to main content
15,868,016 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

I have written a hive query language as below. It is giving me error as written in title.
the query is :

select clnt_nbr, case when clnt_nbr in (select clnt_NBR from crd_master where crd_typ = '198 or crd_typ = '199' ) then 1 else 0 end) as f_ultima from INT_CLNT_master order by clnt_nbr;

I am getting error in this hive query as "currently subquery expressions are only allowed as where clause predicates in hive".
please help!!

What I have tried:

i have tried to remove in in the query but didn't succeeded.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900