thanks! that works
On Mon, Oct 1, 2012 at 3:43 PM, Matt Tucker wrote:
> Hi Mohit,
>
>
>
> Hive doesn’t support correlated subqueries. In this instance, you can do
> a left outer join to find values that are not in a table.
>
>
>
> SELECT
>
> “”,
>
> a.pagename,
>
> a.pagedetail,
Hi Mohit,
Hive doesn’t support correlated subqueries. In this instance, you can do a
left outer join to find values that are not in a table.
SELECT
“”,
a.pagename,
a.pagedetail,
“”,
a.pagetitle,
a.page_id,
a.pagetype
FROM page_temp_ext a
LEFT OUTER JO
