You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by "Omer, Farah" <fo...@microstrategy.com> on 2010/05/22 00:23:24 UTC

Upgrade the hive version on Cloudera training VM

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

 


Re: Upgrade the hive version on Cloudera training VM

Posted by Sarah Sproehnle <sa...@cloudera.com>.
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 <fo...@microstrategy.com> 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