Hi,
I am working on the Cloudera's Hadoop Training VM that has Hadoop and
Hive installed in it. I basically connect via the Hive DOBC driver to
the front end of MicroStrategy BI tool, to run reports. I saw that in my
version of Hive, I am unable to run queries like:
CREATE TABLE ZZTA41IFUZBMD000 AS
SELECT a11.REGION_NBR REGION_NBR,
sum(a11.CLE_SLS_DLR) WJXBFS1
FROM region_division a11 LEFT SEMI JOIN lookup_store s21
ON (s21.MARKET_NBR = 2 and s21.STORE_NBR = 1
and s21.REGION_NBR = a11.REGION_NBR)
group by a11.REGION_NBR;
It errors out with the message of: mismatched input 'SEMI' expecting
OUTER in join type specifier
As I downloaded this VM from Cloudera long time ago the hive version may
be older. I need to upgrade this to 0.5. What would be the best way to
go about this? Does Cloudera have a VM with the latest hive in it? If
not, then can I just upgrade, and how may I do so.
Thanks very much.
- Farah
