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