Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 4C296176BA for ; Wed, 25 Nov 2015 01:15:14 +0000 (UTC) Received: (qmail 53265 invoked by uid 500); 25 Nov 2015 01:15:11 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 53091 invoked by uid 500); 25 Nov 2015 01:15:11 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 52733 invoked by uid 99); 25 Nov 2015 01:15:11 -0000 Received: from Unknown (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Nov 2015 01:15:11 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 421001A293A for ; Wed, 25 Nov 2015 01:15:11 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.9 X-Spam-Level: ** X-Spam-Status: No, score=2.9 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-us-west.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id Tb35QHfv5f0A for ; Wed, 25 Nov 2015 01:14:57 +0000 (UTC) Received: from mail-vk0-f50.google.com (mail-vk0-f50.google.com [209.85.213.50]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id DF03F2306D for ; Wed, 25 Nov 2015 01:14:56 +0000 (UTC) Received: by vkfr145 with SMTP id r145so25160042vkf.0 for ; Tue, 24 Nov 2015 17:14:56 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=yy9EkOsDjDlJzzejQDPkRvqSB7j7HGJpjCt872H73Kc=; b=I2blLQs1JxYzo6IAJVJDWgNykObub1FBHkWaiXpKuZeoep+omIcVR31yJOU4bz2X9D QsPDp0QDhAkwV2fKG9jJhkmMZSvaicVzvXMgrG1vZfsILV7J8OZfSjHX2zMNnWw1r0ax cv/W3j0GgpaRe0R+lTdrT2l2iuXp/lWAkvmxEtE0hX9+m9E1jWteBy4FKqxWvb4bBIFe KxxlktA9slntJRnuVr6SUrRB4kBxldIjaoLRwLXUsVlsGc6VTFd4Ych5NXp59GWCboKF Kd6SzzXb0I2W8CVZOWyJVQlmjNcr+O0dIgV6B1KE3EPk8vH/W0m7q5gB/fFG9kx6mkKf a8RA== MIME-Version: 1.0 X-Received: by 10.31.138.74 with SMTP id m71mr30225139vkd.70.1448414096108; Tue, 24 Nov 2015 17:14:56 -0800 (PST) Received: by 10.31.193.196 with HTTP; Tue, 24 Nov 2015 17:14:56 -0800 (PST) In-Reply-To: References: <051801d126e2$a2e6e3c0$e8b4ab40$@peridale.co.uk> Date: Tue, 24 Nov 2015 20:14:56 -0500 Message-ID: Subject: Re: Upgrading from Hive 0.14.0 to Hive 1.2.1 From: Lefty Leverenz To: user@hive.apache.org Content-Type: multipart/alternative; boundary=001a11457f90afb32c0525532f31 --001a11457f90afb32c0525532f31 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Here's the documentation for Hive's schema tool: https://cwiki.apache.org/confluence/display/Hive/Hive+Schema+Tool. -- Lefty On Tue, Nov 24, 2015 at 2:12 PM, Xuefu Zhang wrote: > This upgrade should be no different from other upgrade. You can use Hive'= s > schema tool to upgrade your existing metadata. > > Thanks, > Xuefu > > On Tue, Nov 24, 2015 at 10:05 AM, Mich Talebzadeh > wrote: > >> Hi, >> >> >> >> I would like to upgrade to Hive 1.2.1 as I understand one cannot deploy >> Spark execution engine on 0.14 >> >> >> >> *Chooses execution engine. Options are: **mr** (Map reduce, default), * >> *tez** (Tez >> execution= , >> for Hadoop 2 only), or **spark** (Spark >> executi= on, >> for Hive 1.1.0 onward).* >> >> >> >> Is there any upgrade path (I don=E2=80=99t want to lose my existing data= bases in >> Hive) or I have to start from new including generating new metatsore etc= ? >> >> >> >> Thanks, >> >> >> >> >> >> Mich Talebzadeh >> >> >> >> *Sybase ASE 15 Gold Medal Award 2008* >> >> A Winning Strategy: Running the most Critical Financial Data on ASE 15 >> >> >> http://login.sybase.com/files/Product_Overviews/ASE-Winning-Strategy-091= 908.pdf >> >> Author of the books* "A Practitioner=E2=80=99s Guide to Upgrading to Syb= ase ASE >> 15", ISBN 978-0-9563693-0-7*. >> >> co-author *"Sybase Transact SQL Guidelines Best Practices", ISBN >> 978-0-9759693-0-4* >> >> *Publications due shortly:* >> >> *Complex Event Processing in Heterogeneous Environments*, ISBN: >> 978-0-9563693-3-8 >> >> *Oracle and Sybase, Concepts and Contrasts*, ISBN: 978-0-9563693-1-4, vo= lume >> one out shortly >> >> >> >> http://talebzadehmich.wordpress.com >> >> >> >> NOTE: The information in this email is proprietary and confidential. Thi= s >> message is for the designated recipient only, if you are not the intende= d >> recipient, you should destroy it immediately. Any information in this >> message shall not be understood as given or endorsed by Peridale Technol= ogy >> Ltd, its subsidiaries or their employees, unless expressly so stated. It= is >> the responsibility of the recipient to ensure that this email is virus >> free, therefore neither Peridale Ltd, its subsidiaries nor their employe= es >> accept any responsibility. >> >> >> > > --001a11457f90afb32c0525532f31 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Here's the documentation for Hive's schema tool: = =C2=A0https://cwiki.apache.org/confluence/display/Hive/Hive+Schema+Tool<= /a>.

-- Lefty

On Tue, Nov 24, 2015 at 2:12 PM, Xuefu Zhang= <xzhang@cloudera.com> wrote:
This upgrade should be no different from o= ther upgrade. You can use Hive's schema tool to upgrade your existing m= etadata.

Thanks,
Xuefu

On Tue, Nov 24, 2015 at 10:05 AM, Mich Talebzadeh <<= a href=3D"mailto:mich@peridale.co.uk" target=3D"_blank">mich@peridale.co.uk= > wrote:

Hi,

=

=C2=A0

I would like to upgrade to Hive 1.= 2.1 as I understand one cannot deploy Spark execution engine on 0.14=

=C2=A0

Chooses execution engine. Options are: = mr (Map reduce, default), = tez= (Tez execution, for Hadoop 2 only),= or spark (Spark<= /a> execution, for Hive 1.1.0 onward).

=C2=A0

Is there any upgrade path (I don=E2=80= =99t want to lose my existing databases in Hive) or I have to start from ne= w including generating new metatsore etc?

= =C2=A0

Thanks,

= =C2=A0

=C2=A0

Mich T= alebzadeh

=C2=A0

Sybase ASE 15 Gold Medal Award 2008

A Winning Strategy: Running the most Critical Financial Data on ASE 15=

http://login.sybase.com/files/Product_Overvie= ws/ASE-Winning-Strategy-091908.pdf

Author of the boo= ks "A Practitioner=E2=80=99s Guide to Upgrading to Sybase ASE 15&qu= ot;, ISBN 978-0-9563693-0-7.

co-author "Sybase Tra= nsact SQL Guidelines Best Practices", ISBN 978-0-9759693-0-4

<= span style=3D"letter-spacing:-.15pt">Publications due shortly:

Complex Event Pr= ocessing in Heterogeneous Environments, ISBN: 978-0-9= 563693-3-8

Oracle and Sybase, Concepts and Contrasts, ISBN: 97= 8-0-9563693-1-4, volume one out shortly<= u>

=C2=A0

http://talebzadehmich.wordpress.com<= /span>

=C2=A0

NOTE: The information in this = email is proprietary and confidential. This message is for the designated r= ecipient only, if you are not the intended recipient, you should destroy it= immediately. Any information in this message shall not be understood as gi= ven or endorsed by Peridale Technology Ltd, its subsidiaries or their emplo= yees, unless expressly so stated. It is the responsibility of the recipient= to ensure that this email is virus free, therefore neither Peridale Ltd, i= ts subsidiaries nor their employees accept any responsibility.

=C2=A0



--001a11457f90afb32c0525532f31--