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 8F48419296 for ; Tue, 1 Mar 2016 06:39:49 +0000 (UTC) Received: (qmail 26181 invoked by uid 500); 1 Mar 2016 06:39:47 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 26102 invoked by uid 500); 1 Mar 2016 06:39:47 -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 26083 invoked by uid 99); 1 Mar 2016 06:39:47 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Mar 2016 06:39:47 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 5DCFCC3355; Tue, 1 Mar 2016 06:39:47 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.179 X-Spam-Level: * X-Spam-Status: No, score=1.179 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id JDaob7w5m6sP; Tue, 1 Mar 2016 06:39:45 +0000 (UTC) Received: from mail-lf0-f50.google.com (mail-lf0-f50.google.com [209.85.215.50]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id A93F15F393; Tue, 1 Mar 2016 06:39:44 +0000 (UTC) Received: by mail-lf0-f50.google.com with SMTP id v124so13660348lff.0; Mon, 29 Feb 2016 22:39:44 -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; bh=inMQalnTEujtLl3ncfov6hps9nAbTrwyYhjVBZFZfZQ=; b=khUB3E2V/33sQXVE/mBIXKJ7uxu0zGQ1Kriz2b945c6rbQqEXN67G5JUKGsKH7CBfa mEalLWmTl8ebnJ5HTWnWRzYpSU45ZcGu0CzC9sT7PXEp0M6L78PwKxvjY41kzuYDGlFm 18PolZuAJZbNUdbrWw9x/qlxusLVbkUh2ZcBr6CHNmSOFgEC9TZW9U5oPnP4i0Nnm0Sj exqUbqg2fJpmUTFPNSjceJ8QGqpeG6lGiAzPDtlvb+icgvgcMCetF3qYJ4dmIW8DUwpp csWX4mwEuxwPX6P3t1NIkJ62NX9Q7OVkhGs6IjI0Nrbz9fU2kZEcZvW1z2uKPGcbj6K4 syhg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to; bh=inMQalnTEujtLl3ncfov6hps9nAbTrwyYhjVBZFZfZQ=; b=TpFzVCt0K2wt4OQbOaVvP+eaQT5Hx6GoEqfIBPzid2gUIYnABWVW5WcpJptWptYJid 8N582w6QQaCkIVR+JIz4pTY6sqJnoNF6J+Rgqt8NagE1UzvqqkEhy5NBVIQrBT74ZDZ8 Lm8ENaKjbbXGQ4k41MrQd8C887KcPn/BG+++4rywPp/nk771QldTWc/XLwsZxOTe/TCW BC0mpK67dEmCTMaCs1PZuNF4L/ybrhZ2dVHvRTapjru2DtF4N8B0V7jqiARlz/8JGpMh 6bgbOLzloW+/TV9Wp/V8N7ytY2Zlsycc2IV058W0Ikvi6NJXEtOXEYUuvTEi4khKgram aBkw== X-Gm-Message-State: AD7BkJIwugcmZoo37CKO7J/KuLYG7xEJYfPAaBnQMBQqe6tpiOi263qJ8oZQ9tV8miQ4yF0/vXjDsxK4rh4R2g== MIME-Version: 1.0 X-Received: by 10.25.44.15 with SMTP id s15mr7356218lfs.81.1456814383402; Mon, 29 Feb 2016 22:39:43 -0800 (PST) Received: by 10.112.139.131 with HTTP; Mon, 29 Feb 2016 22:39:43 -0800 (PST) In-Reply-To: References: Date: Tue, 1 Mar 2016 09:39:43 +0300 Message-ID: Subject: Re: Hive-2.0.1 Release date From: Dmitry Tolpeko To: user@hive.apache.org, dev@hive.apache.org Content-Type: multipart/alternative; boundary=001a11403c5cd39937052cf7073f --001a11403c5cd39937052cf7073f Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Mich, To avoid confusion: HPLSQL is shipped with Hive 2.0 (and will be shipped with all further versions). So you can use it with Hive on Tez, Hive on MR, and Hive on Spark. But now it is a separate tool: hplsql (like hive CLI, beeline CLI). What Alan meant is that it is not integrated to Hive *parser*, so there are 2 parsers now: Hive SQL and HPLSQL. HPLSQL acts as a SQL-skin, supports many SQL and PL/SQL dialects in order to avoid code conversions (there are a lot of legacy code to be ported to Hive), so it is verbose. I am not sure if it makes sense to merge it with Hive SQL parser, but definitely integration with Hive/beeline CLI, metastore (persistent store of procedures/functions), JDBC/ODBC will be helpful. Alan, I am ready to work on this, but we need to define the direction first so we have good and consistent design. Thanks, Dmitry On Tue, Mar 1, 2016 at 3:08 AM, Mich Talebzadeh wrote: > Thanks. I believe Alan Gate mentioned that HPLSQL is not yet integrated > into Hive 2.0.May be later? > > Dr Mich Talebzadeh > > > > LinkedIn * https://www.linkedin.com/profile/view?id=3DAAEAAAAWh2gBxianrbJ= d6zP6AcPCCdOABUrV8Pw > * > > > > http://talebzadehmich.wordpress.com > > > > On 1 March 2016 at 00:05, Sergey Shelukhin wrote= : > >> HPLSQL is available as part of Hive 2.0. I am not sure to which extent >> the integration goes as I wasn=E2=80=99t involved in that work. >> As far as I understand HPLSQL and Hive on Spark are kind of orthogonal= =E2=80=A6 >> >> Hive 2.0.1 is purely a bug fix release for Hive 2.0; Hive 2.1 will be th= e >> next feature release if some major feature is missing. >> >> From: Mich Talebzadeh >> Reply-To: "user@hive.apache.org" >> Date: Monday, February 29, 2016 at 15:53 >> To: "user@hive.apache.org" >> Subject: Re: Hive-2.0.1 Release date >> >> Hi Sergey, >> >> Will HPLSQL be part of 2.0.1.release? >> >> I am using 2.0 and found Hive on Spark to be much more stable. >> >> Thanks >> >> Dr Mich Talebzadeh >> >> >> >> LinkedIn * https://www.linkedin.com/profile/view?id=3DAAEAAAAWh2gBxianrb= Jd6zP6AcPCCdOABUrV8Pw >> * >> >> >> >> http://talebzadehmich.wordpress.com >> >> >> >> On 29 February 2016 at 23:46, Sergey Shelukhin >> wrote: >> >>> Hi. It will be released when some critical mass of bugfixes is >>> accumulated. We already found some issues that would be nice to fix, so= it >>> may be some time in March. Is there a particular fix that interests you= ? >>> >>> From: Oleksiy MapR >>> Reply-To: "user@hive.apache.org" >>> Date: Monday, February 29, 2016 at 00:43 >>> To: "user@hive.apache.org" >>> Subject: Hive-2.0.1 Release date >>> >>> Hi all! >>> >>> Are you planing to release Hive-2.0.1? If yes, when it probably may be? >>> >>> Thanks, >>> Oleksiy. >>> >> >> > --001a11403c5cd39937052cf7073f Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Mich,

To avoid confusion: HPLSQL is shi= pped with Hive 2.0 (and will be shipped with all further versions). So you = can use it with Hive on Tez, Hive on MR, and Hive on Spark. But now it is a= separate tool: hplsql (like hive CLI, beeline CLI). What Alan meant is tha= t it is not integrated to Hive *parser*, so there are 2 parsers now: Hive S= QL and HPLSQL.=C2=A0

HPLSQL acts as a SQL-skin, su= pports many SQL and PL/SQL dialects in order to avoid code conversions (the= re are a lot of legacy code to be ported to Hive), so it is verbose. I am n= ot sure if it makes sense to merge it with Hive SQL parser, but definitely = integration with Hive/beeline CLI, metastore (persistent store of procedure= s/functions), JDBC/ODBC will be helpful. =C2=A0

Al= an, I am ready to work on this, but we need to define the direction first s= o we have good and consistent design.

Thanks,=C2= =A0

Dmitry=C2=A0

On Tue, Mar 1, 2016 at 3:08 AM, Mich Ta= lebzadeh <mich.talebzadeh@gmail.com> wrote:
Thanks. I believe Alan Gate ment= ioned that HPLSQL is not yet integrated into Hive 2.0.May be later?


On 1 March 2016 at 00:05, Sergey Shelukhin <= span dir=3D"ltr"><sergey@hortonworks.com> wrote:
HPLSQL is available as part of Hive 2.0. I am not sure to which extent= the integration goes as I wasn=E2=80=99t involved in that work.
As far as I understand HPLSQL and Hive on Spark are kind of orthogonal= =E2=80=A6

Hive 2.0.1 is purely a bug fix release for Hive 2.0; Hive 2.1 will be = the next feature release if some major feature is missing.

From: Mich Talebzadeh <mich.talebzadeh@gma= il.com>
Reply-To: "user@hive.apache.org" <<= a href=3D"mailto:user@hive.apache.org" target=3D"_blank">user@hive.apache.o= rg>
Date: Monday, February 29, 2016 at = 15:53
To: "user@hive.apache.org" <user@hive.apache.org= >
Subject: Re: Hive-2.0.1 Release dat= e

Hi Sergey,

Will HPLSQL be part of 2.0.1.release?

I am using 2.0 and found Hive on Spark to be much more stable.

Thanks


On 29 February 2016 at 23:46, Sergey Shelukhin <= span dir=3D"ltr"> <sergey@hort= onworks.com> wrote:
Hi. It will be released when some critical mass of bugfixes is accumul= ated. We already found some issues that would be nice to fix, so it may be = some time in March. Is there a particular fix that interests you?

From: Oleksiy MapR <osayankin.maprtech@gm= ail.com>
Reply-To: "user@hive.apache.org" <<= a href=3D"mailto:user@hive.apache.org" target=3D"_blank">user@hive.apache.o= rg>
Date: Monday, February 29, 2016 at = 00:43
To: "user@hive.apache.org" <user@hive.apache.org= >
Subject: Hive-2.0.1 Release date

Hi all!

Are you planing to release Hive-2.0.1? If yes, when it probably may be?

Thanks,
Oleksiy.


--001a11403c5cd39937052cf7073f--