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. >>>>> >>>> >>>> >>> >> >
