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