Noted for future queries, and thanks for the help! Works like a charm :).
Best,
--
Oliver Keyes
Product Analyst
Wikimedia Foundation
On 6 February 2014 17:09, Stephen Sprague wrote:
> ahh. we got ourselves a bona-fide head banger. Welcome to the club!! :)
>
> select
> a.col1 as foo,
>
ahh. we got ourselves a bona-fide head banger. Welcome to the club!! :)
select
a.col1 as foo,
a.col2 as bar,
a.col3 as baz
from
database1.table1 a
INNER JOIN database2.table2 b on a.col1 = b.col1
where
a.year = 2014
and a.month = 1
and a.day = 20
so lose the 'A
Hey all,
So, I'm new to hive (I come to it from MySQL/MariaDB) and I've spent the
last couple of days banging my head against the problem of trying to
retrieve data from a join of two tables in different databases. I
understand that the db.table.column syntax is not supported in hive, and
that ins
