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 <dmtolp...@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.talebza...@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 <ser...@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.talebza...@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 <ser...@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.maprt...@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.
>>>>
>>>
>>>
>>
>
