hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dmitry Tolpeko <dmtolp...@gmail.com>
Subject Re: Hive-2.0.1 Release date
Date Tue, 01 Mar 2016 07:12:08 GMT
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