RE: Passing parameters to Beeline

2016-01-14 Thread Mich Talebzadeh
:trainee1...@gmail.com] Sent: 14 January 2016 11:10 To: user@hive.apache.org Subject: Re: Passing parameters to Beeline My command is: beeline -u "jdbc:hive2://:10001/;principal=hive/@http://a.b.c.com> >?hive.server2.transport.mode=http;hive.server2.thrift.http.path=cliserv

Re: Passing parameters to Beeline

2016-01-14 Thread Trainee Bingo
nated recipient only, if you are not the intended > recipient, you should destroy it immediately. Any information in this > message shall not be understood as given or endorsed by Peridale Technology > Ltd, its subsidiaries or their employees, unless expressly so stated. It is >

RE: Passing parameters to Beeline

2016-01-14 Thread Mich Talebzadeh
its subsidiaries nor their employees accept any responsibility. From: Mich Talebzadeh [mailto:m...@peridale.co.uk] Sent: 14 January 2016 10:59 To: user@hive.apache.org Subject: RE: Passing parameters to Beeline That should work. No need for \ bl -e "use test;show ta

RE: Passing parameters to Beeline

2016-01-14 Thread Mich Talebzadeh
lity. From: Trainee Bingo [mailto:trainee1...@gmail.com] Sent: 14 January 2016 10:41 To: user@hive.apache.org Subject: Re: Passing parameters to Beeline Thanks Maciek ! Another issue is I am using Hive 0.13.0.2.1.7.0-784 and Beeline version 0.13.0.2.1.7.0-784 by Apache Hive. I am ab

Re: Passing parameters to Beeline

2016-01-14 Thread Trainee Bingo
Thanks Maciek ! Another issue is I am using *Hive 0.13.0.2.1.7.0-784 * and *Beeline version 0.13.0.2.1.7.0-784 by Apache Hive.* I am able to execute: *hive -e "use db_test; show tables"* But while executing same in beeline gives error: *beeline -u "" -e **"use db_test; sh

Re: Passing parameters to Beeline

2016-01-13 Thread matshyeq
Try *--hivevar **name=value* works for hive and should work for beeline too: https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-Beeline–NewCommandLineShell

Passing parameters to Beeline

2016-01-13 Thread Trainee Bingo
Hi All, Hope all are enjoying working in hive !!! I am having one question regarding hive and beeline: I am passing parameters to hive script using "-d". Eg: *hive -d table_name -f emp.hql* * emp.hql:* CREATE EXTERNAL TABLE ${table_name} ( ID STRI