hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Oleksiy MapR <osayankin.maprt...@gmail.com>
Subject Re: Hive-2.0.1 Release date
Date Tue, 01 Mar 2016 10:35:06 GMT
>> 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 <dmtolpeko@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 <dmtolpeko@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 <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’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 <mich.talebzadeh@gmail.com>
>>>>> Reply-To: "user@hive.apache.org" <user@hive.apache.org>
>>>>> Date: Monday, February 29, 2016 at 15:53
>>>>> To: "user@hive.apache.org" <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=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 <osayankin.maprtech@gmail.com>
>>>>>> Reply-To: "user@hive.apache.org" <user@hive.apache.org>
>>>>>> 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.
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>

Mime
View raw message