hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <mich.talebza...@gmail.com>
Subject Re: Hive-2.0.1 Release date
Date Tue, 01 Mar 2016 06:50:01 GMT
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