using sub-queries
in the FROM using join instead.
For example:
SELECT
FROM mytable A
JOIN ( SELECT ) B
ON A.mycol = B.mycol
WHERE ...
hope that helps.
-- amr
On 2/19/2010 8:58 AM, Andy Kent wrote:
I couldn't find anything on the wiki so thought I would try here.
Does Hive
No, but it's relatively easy to implement custom UDF
(http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF)
that will implement the same functionality
On Feb 19, 2010, at 7:58 PM, Andy Kent wrote:
> I couldn't find anything on the wiki so thought I would try here.
>
> D
I couldn't find anything on the wiki so thought I would try here.
Does Hive have an IN() operator similar to in MySQL?
If not then is there an alternative way of testing for inclusion?
Thanks,
Andy.
