You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Sergey Shelukhin <se...@hortonworks.com> on 2016/03/01 00:46:26 UTC
Re: Hive-2.0.1 Release date
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 <os...@gmail.com>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Date: Monday, February 29, 2016 at 00:43
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@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.
Re: Hive-2.0.1 Release date
Posted by Mich Talebzadeh <mi...@gmail.com>.
Thanks Alan much appreciated
Dr Mich Talebzadeh
LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
http://talebzadehmich.wordpress.com
On 1 March 2016 at 00:38, Alan Gates <al...@gmail.com> wrote:
> HPLSQL released with Hive in 2.0, but it hasn’t been integrated as in
> there isn’t a single parser that handles HPLSQL and Hive SQL. The work to
> integrate it is significant, and a new feature, so it definitely won’t be
> done in a bug fix release but in a feature bearing release (that is 2.x,
> not 2.0.x). AFAIK no one is working on this at the moment.
>
> Alan.
>
> > On Feb 29, 2016, at 16:08, Mich Talebzadeh <mi...@gmail.com>
> 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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> >
> > http://talebzadehmich.wordpress.com
> >
> >
> > On 1 March 2016 at 00:05, Sergey Shelukhin <se...@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’t involved in that work.
> > As far as I understand HPLSQL and Hive on Spark are kind of orthogonal…
> >
> > 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 <mi...@gmail.com>
> > Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
> > Date: Monday, February 29, 2016 at 15:53
> > To: "user@hive.apache.org" <us...@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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> >
> > http://talebzadehmich.wordpress.com
> >
> >
> > On 29 February 2016 at 23:46, Sergey Shelukhin <se...@hortonworks.com>
> 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 <os...@gmail.com>
> > Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
> > Date: Monday, February 29, 2016 at 00:43
> > To: "user@hive.apache.org" <us...@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.
> >
> >
>
>
Re: Hive-2.0.1 Release date
Posted by Alan Gates <al...@gmail.com>.
HPLSQL released with Hive in 2.0, but it hasn’t been integrated as in there isn’t a single parser that handles HPLSQL and Hive SQL. The work to integrate it is significant, and a new feature, so it definitely won’t be done in a bug fix release but in a feature bearing release (that is 2.x, not 2.0.x). AFAIK no one is working on this at the moment.
Alan.
> On Feb 29, 2016, at 16:08, Mich Talebzadeh <mi...@gmail.com> 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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>
> http://talebzadehmich.wordpress.com
>
>
> On 1 March 2016 at 00:05, Sergey Shelukhin <se...@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’t involved in that work.
> As far as I understand HPLSQL and Hive on Spark are kind of orthogonal…
>
> 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 <mi...@gmail.com>
> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
> Date: Monday, February 29, 2016 at 15:53
> To: "user@hive.apache.org" <us...@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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>
> http://talebzadehmich.wordpress.com
>
>
> On 29 February 2016 at 23:46, Sergey Shelukhin <se...@hortonworks.com> 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 <os...@gmail.com>
> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
> Date: Monday, February 29, 2016 at 00:43
> To: "user@hive.apache.org" <us...@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.
>
>
Re: Hive-2.0.1 Release date
Posted by Oleksiy MapR <os...@gmail.com>.
>> 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?
Hi Sergey!
Thanks for the information. There is no particular fix I want to see. It is
common case to have additional release with small fixed after a great
release, so I wanted to know the terms of it.
Oleksiy.
On Tue, Mar 1, 2016 at 9:12 AM, Dmitry Tolpeko <dm...@gmail.com> wrote:
> Mich,
>
> >What is best way of using with Hive now?
>
> If we are talking about the command line: Hive/beeline CLI to execute
> standalone SQL statements; Hplsql if you need to surround them with
> procedural SQL (flow of control, loops, exception handlers, dynamic SQL
> etc.)
>
> Dmitry
>
>
> On Tue, Mar 1, 2016 at 9:50 AM, Mich Talebzadeh <mich.talebzadeh@gmail.com
> > wrote:
>
>> Thanks Dmitry
>>
>> I can see
>>
>> cd $HIVE_HOME
>> find ./ -name '*hplsql*'
>> ./bin/ext/hplsql.sh
>> ./bin/hplsql.cmd
>> ./bin/hplsql
>> ./lib/hive-hplsql-2.0.0.jar
>>
>> hplsql
>> usage: hplsql
>> -d,--define <key=value> Variable subsitution e.g. -d A=B or
>> --define A=B
>> -e <quoted-query-string> HPL/SQL from command line
>> -f <filename> HPL/SQL from a file
>> -H,--help Print help information
>> --hiveconf <property=value> Value for given property
>> --hivevar <key=value> Variable subsitution e.g. --hivevar A=B
>> -main <procname> Entry point (procedure or function name)
>> -offline,--offline Offline mode - skip SQL execution
>> -trace,--trace Print debug information
>> -version,--version Print HPL/SQL version
>>
>> What is best way of using with Hive now?
>>
>>
>> Cheers
>>
>>
>> Dr Mich Talebzadeh
>>
>>
>>
>> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>>
>>
>>
>> http://talebzadehmich.wordpress.com
>>
>>
>>
>> On 1 March 2016 at 06:39, Dmitry Tolpeko <dm...@gmail.com> wrote:
>>
>>> 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 <
>>> mich.talebzadeh@gmail.com> 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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>>>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>>>>
>>>>
>>>>
>>>> http://talebzadehmich.wordpress.com
>>>>
>>>>
>>>>
>>>> On 1 March 2016 at 00:05, Sergey Shelukhin <se...@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’t involved in that work.
>>>>> As far as I understand HPLSQL and Hive on Spark are kind of orthogonal…
>>>>>
>>>>> 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 <mi...@gmail.com>
>>>>> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
>>>>> Date: Monday, February 29, 2016 at 15:53
>>>>> To: "user@hive.apache.org" <us...@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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>>>>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>>>>>
>>>>>
>>>>>
>>>>> http://talebzadehmich.wordpress.com
>>>>>
>>>>>
>>>>>
>>>>> On 29 February 2016 at 23:46, Sergey Shelukhin <sergey@hortonworks.com
>>>>> > 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 <os...@gmail.com>
>>>>>> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
>>>>>> Date: Monday, February 29, 2016 at 00:43
>>>>>> To: "user@hive.apache.org" <us...@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.
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>
Re: Hive-2.0.1 Release date
Posted by Dmitry Tolpeko <dm...@gmail.com>.
Mich,
>What is best way of using with Hive now?
If we are talking about the command line: Hive/beeline CLI to execute
standalone SQL statements; Hplsql if you need to surround them with
procedural SQL (flow of control, loops, exception handlers, dynamic SQL
etc.)
Dmitry
On Tue, Mar 1, 2016 at 9:50 AM, Mich Talebzadeh <mi...@gmail.com>
wrote:
> Thanks Dmitry
>
> I can see
>
> cd $HIVE_HOME
> find ./ -name '*hplsql*'
> ./bin/ext/hplsql.sh
> ./bin/hplsql.cmd
> ./bin/hplsql
> ./lib/hive-hplsql-2.0.0.jar
>
> hplsql
> usage: hplsql
> -d,--define <key=value> Variable subsitution e.g. -d A=B or
> --define A=B
> -e <quoted-query-string> HPL/SQL from command line
> -f <filename> HPL/SQL from a file
> -H,--help Print help information
> --hiveconf <property=value> Value for given property
> --hivevar <key=value> Variable subsitution e.g. --hivevar A=B
> -main <procname> Entry point (procedure or function name)
> -offline,--offline Offline mode - skip SQL execution
> -trace,--trace Print debug information
> -version,--version Print HPL/SQL version
>
> What is best way of using with Hive now?
>
>
> Cheers
>
>
> Dr Mich Talebzadeh
>
>
>
> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> http://talebzadehmich.wordpress.com
>
>
>
> On 1 March 2016 at 06:39, Dmitry Tolpeko <dm...@gmail.com> wrote:
>
>> 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 <
>> mich.talebzadeh@gmail.com> 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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>>>
>>>
>>>
>>> http://talebzadehmich.wordpress.com
>>>
>>>
>>>
>>> On 1 March 2016 at 00:05, Sergey Shelukhin <se...@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’t involved in that work.
>>>> As far as I understand HPLSQL and Hive on Spark are kind of orthogonal…
>>>>
>>>> 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 <mi...@gmail.com>
>>>> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
>>>> Date: Monday, February 29, 2016 at 15:53
>>>> To: "user@hive.apache.org" <us...@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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>>>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>>>>
>>>>
>>>>
>>>> http://talebzadehmich.wordpress.com
>>>>
>>>>
>>>>
>>>> On 29 February 2016 at 23:46, Sergey Shelukhin <se...@hortonworks.com>
>>>> 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 <os...@gmail.com>
>>>>> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
>>>>> Date: Monday, February 29, 2016 at 00:43
>>>>> To: "user@hive.apache.org" <us...@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.
>>>>>
>>>>
>>>>
>>>
>>
>
Re: Hive-2.0.1 Release date
Posted by Mich Talebzadeh <mi...@gmail.com>.
Thanks Dmitry
I can see
cd $HIVE_HOME
find ./ -name '*hplsql*'
./bin/ext/hplsql.sh
./bin/hplsql.cmd
./bin/hplsql
./lib/hive-hplsql-2.0.0.jar
hplsql
usage: hplsql
-d,--define <key=value> Variable subsitution e.g. -d A=B or
--define A=B
-e <quoted-query-string> HPL/SQL from command line
-f <filename> HPL/SQL from a file
-H,--help Print help information
--hiveconf <property=value> Value for given property
--hivevar <key=value> Variable subsitution e.g. --hivevar A=B
-main <procname> Entry point (procedure or function name)
-offline,--offline Offline mode - skip SQL execution
-trace,--trace Print debug information
-version,--version Print HPL/SQL version
What is best way of using with Hive now?
Cheers
Dr Mich Talebzadeh
LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
http://talebzadehmich.wordpress.com
On 1 March 2016 at 06:39, Dmitry Tolpeko <dm...@gmail.com> wrote:
> 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 <mich.talebzadeh@gmail.com
> > 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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>>
>>
>>
>> http://talebzadehmich.wordpress.com
>>
>>
>>
>> On 1 March 2016 at 00:05, Sergey Shelukhin <se...@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’t involved in that work.
>>> As far as I understand HPLSQL and Hive on Spark are kind of orthogonal…
>>>
>>> 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 <mi...@gmail.com>
>>> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
>>> Date: Monday, February 29, 2016 at 15:53
>>> To: "user@hive.apache.org" <us...@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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>>>
>>>
>>>
>>> http://talebzadehmich.wordpress.com
>>>
>>>
>>>
>>> On 29 February 2016 at 23:46, Sergey Shelukhin <se...@hortonworks.com>
>>> 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 <os...@gmail.com>
>>>> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
>>>> Date: Monday, February 29, 2016 at 00:43
>>>> To: "user@hive.apache.org" <us...@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.
>>>>
>>>
>>>
>>
>
Re: Hive-2.0.1 Release date
Posted by Dmitry Tolpeko <dm...@gmail.com>.
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 <mi...@gmail.com>
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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> http://talebzadehmich.wordpress.com
>
>
>
> On 1 March 2016 at 00:05, Sergey Shelukhin <se...@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’t involved in that work.
>> As far as I understand HPLSQL and Hive on Spark are kind of orthogonal…
>>
>> 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 <mi...@gmail.com>
>> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
>> Date: Monday, February 29, 2016 at 15:53
>> To: "user@hive.apache.org" <us...@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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>>
>>
>>
>> http://talebzadehmich.wordpress.com
>>
>>
>>
>> On 29 February 2016 at 23:46, Sergey Shelukhin <se...@hortonworks.com>
>> 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 <os...@gmail.com>
>>> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
>>> Date: Monday, February 29, 2016 at 00:43
>>> To: "user@hive.apache.org" <us...@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.
>>>
>>
>>
>
Re: Hive-2.0.1 Release date
Posted by Dmitry Tolpeko <dm...@gmail.com>.
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 <mi...@gmail.com>
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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> http://talebzadehmich.wordpress.com
>
>
>
> On 1 March 2016 at 00:05, Sergey Shelukhin <se...@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’t involved in that work.
>> As far as I understand HPLSQL and Hive on Spark are kind of orthogonal…
>>
>> 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 <mi...@gmail.com>
>> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
>> Date: Monday, February 29, 2016 at 15:53
>> To: "user@hive.apache.org" <us...@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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>>
>>
>>
>> http://talebzadehmich.wordpress.com
>>
>>
>>
>> On 29 February 2016 at 23:46, Sergey Shelukhin <se...@hortonworks.com>
>> 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 <os...@gmail.com>
>>> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
>>> Date: Monday, February 29, 2016 at 00:43
>>> To: "user@hive.apache.org" <us...@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.
>>>
>>
>>
>
Re: Hive-2.0.1 Release date
Posted by Mich Talebzadeh <mi...@gmail.com>.
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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
http://talebzadehmich.wordpress.com
On 1 March 2016 at 00:05, Sergey Shelukhin <se...@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’t involved in that work.
> As far as I understand HPLSQL and Hive on Spark are kind of orthogonal…
>
> 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 <mi...@gmail.com>
> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
> Date: Monday, February 29, 2016 at 15:53
> To: "user@hive.apache.org" <us...@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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> http://talebzadehmich.wordpress.com
>
>
>
> On 29 February 2016 at 23:46, Sergey Shelukhin <se...@hortonworks.com>
> 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 <os...@gmail.com>
>> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
>> Date: Monday, February 29, 2016 at 00:43
>> To: "user@hive.apache.org" <us...@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.
>>
>
>
Re: Hive-2.0.1 Release date
Posted by Sergey Shelukhin <se...@hortonworks.com>.
HPLSQL is available as part of Hive 2.0. I am not sure to which extent the integration goes as I wasn’t involved in that work.
As far as I understand HPLSQL and Hive on Spark are kind of orthogonal…
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 <mi...@gmail.com>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Date: Monday, February 29, 2016 at 15:53
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
http://talebzadehmich.wordpress.com<http://talebzadehmich.wordpress.com/>
On 29 February 2016 at 23:46, Sergey Shelukhin <se...@hortonworks.com>> 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 <os...@gmail.com>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Date: Monday, February 29, 2016 at 00:43
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@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.
Re: Hive-2.0.1 Release date
Posted by Mich Talebzadeh <mi...@gmail.com>.
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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
http://talebzadehmich.wordpress.com
On 29 February 2016 at 23:46, Sergey Shelukhin <se...@hortonworks.com>
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 <os...@gmail.com>
> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
> Date: Monday, February 29, 2016 at 00:43
> To: "user@hive.apache.org" <us...@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.
>