Re: Executing HQL files from JAVA application.

2015-03-25 Thread Steve Howard
t; Sent: Wednesday, March 25, 2015 8:49 AM > To: user@hive.apache.org > Cc: Amal Gupta > Subject: Re: Executing HQL files from JAVA application. > > Hi, > > Any mechanism which bypasses schema layers for SQL is a bad idea. > > See this example for how you can

RE: Executing HQL files from JAVA application.

2015-03-25 Thread Amal Gupta
Message- From: Gopal Vijayaraghavan [mailto:go...@hortonworks.com] On Behalf Of Gopal Vijayaraghavan Sent: Wednesday, March 25, 2015 8:49 AM To: user@hive.apache.org Cc: Amal Gupta Subject: Re: Executing HQL files from JAVA application. Hi, Any mechanism which bypasses schema layers for SQL is a

Re: Executing HQL files from JAVA application.

2015-03-24 Thread Gopal Vijayaraghavan
F8"); System.out.println(output); return RepeatStatus.FINISHED; } It will be great if you can share the piece of code that worked for you. May be it will give me some pointers on how to go ahead. Best Regards, Amal From: Mich Talebzadeh [mailto:m

RE: Executing HQL files from JAVA application.

2015-03-23 Thread Amal Gupta
trying to see if a particular configuration succeeds. Will keep you posted on my progress. Thanks again for all the help that you are providing. :) Regards, Amal From: Amal Gupta Sent: Sunday, March 22, 2015 7:52 AM To: user@hive.apache.org Subject: RE: Executing HQL files from JAVA application

RE: Executing HQL files from JAVA application.

2015-03-21 Thread Amal Gupta
stem.out.println(output); return RepeatStatus.FINISHED; } It will be great if you can share the piece of code that worked for you. May be it will give me some pointers on how to go ahead. Best Regards, Amal From: Mich Talebzadeh [mailto:m...@peridale.co.uk] Sent: Sunday,

RE: Executing HQL files from JAVA application.

2015-03-21 Thread Mich Talebzadeh
ail is virus free, therefore neither Peridale Ltd, its subsidiaries nor their employees accept any responsibility. From: Amal Gupta [mailto:amal.gup...@aexp.com] Sent: 21 March 2015 18:16 To: user@hive.apache.org Subject: RE: Executing HQL files from JAVA application. Hi Mich, Thank you

RE: Executing HQL files from JAVA application.

2015-03-21 Thread Amal Gupta
ridale.co.uk] Sent: Saturday, March 21, 2015 6:59 PM To: user@hive.apache.org Subject: RE: Executing HQL files from JAVA application. Hi Amal, Do you have hiveserver2 running? You can use beeline to execute the query outside of JAVA beeline -u jdbc:hive2://rhes564:10010/default org.apache.hive.

RE: Executing HQL files from JAVA application.

2015-03-21 Thread Amal Gupta
: Saturday, March 21, 2015 3:03 PM To: user@hive.apache.org Subject: Re: Executing HQL files from JAVA application. There are more elegant ways I am sure, but you could also use a java.io.BufferedReader and read the file content into a string and execute it much as you would a hard coded SQL

RE: Executing HQL files from JAVA application.

2015-03-21 Thread Mich Talebzadeh
g Subject: Executing HQL files from JAVA application. Hi Everyone, I am trying to execute a hive *.hql file from a java application. I had tried a couple of ways of doing it through JDBC driver for hive and through spring jdbc template but yet, the only way which was successful for me was to

Executing HQL files from JAVA application.

2015-03-21 Thread Amal Gupta
Hi Everyone, I am trying to execute a hive *.hql file from a java application. I had tried a couple of ways of doing it through JDBC driver for hive and through spring jdbc template but yet, the only way which was successful for me was to create a runtime process and then execute it. The java

Re: Executing HQL files from JAVA application.

2015-03-21 Thread Steve Howard
There are more elegant ways I am sure, but you could also use a java.io.BufferedReader and read the file content into a string and execute it much as you would a hard coded SQL statement in your class. Sent from my iPad > On Mar 21, 2015, at 5:04 AM, Amal Gupta wrote: > > Hi Everyone, > > I