Please disregard my previous email. I figured out that the correct syntax should be
FROM a JOIN b on a.col1 = b.col1
INSERT a.col1, a.col2
From: Chen Song <[EMAIL PROTECTED]>
To: hive user list <[EMAIL PROTECTED]>
Sent: Friday, January 20, 2012 10:47 AM
Subject: question on hive multiple insert
I am reading on Hive's multiple insert syntax manual and wondering if it is possible to utilize join in any individual insert. e.g.,
INSERT a.col1, a.col2 join b on a.col1 = b.col1
Apparently, Hive doesn't like this query and give syntax error.
In other words, my question in general is, for multiple insert, can we specify multiple tables as data sources (of course, can benefit from one pass scan on only one table), or only one table from which the data can be pulled from?