Hi Farah, A new version of the Cloudera VM will be released in the next month or so. In the meantime, it is fairly easy to upgrade Hive. Download and extract hive-0.5.0-bin.tar.gz, then set HIVE_HOME and update your path.
Cheers, Sarah On Fri, May 21, 2010 at 3:23 PM, Omer, Farah <[email protected]> wrote: > 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 > > -- get hadoop: cloudera.com/hadoop online training: cloudera.com/hadoop-training blog: cloudera.com/blog twitter: twitter.com/cloudera
