Member since
11-24-2016
5
Posts
0
Kudos Received
0
Solutions
12-13-2016
08:52 PM
1 Kudo
Hi, I can see the images now, but not sure why they did not show up before. I can see that you are trying to run a query that contains: (rel.i_prtitn,rel.i_mod_yr) in (select * from my_prtitn) I would like you know that this is currently not supported, please refer to Hive's Apache documentation below: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+SubQueries It mentions the following: IN/NOT IN subqueries may only select a single column If you want to acheive the same goal, you will need to use JOIN with subQuery on those two columns. Hope this helps. Regards Eric
... View more
12-01-2016
11:53 PM
Thnx @yshi . Your solution worked 🙂
... View more