Hi,
Thanks for this link, it was very helpful :-)
I have another question.
I have some HiveQL script wich are stored into .hql file.
What is the best way to execute these scripts with a Java/JDBC program ?
Thanks.
2013/7/29 Brendan Heussler bheuss...@gmail.com
Jerome,
There is a really
Hi,
Thanks everyone for your help.
Has anyone have a good tutorial to run Hive queries and scripts with Java
(over Eclipse). I have some Java Development basis but i'm pretty new
using Hive with Java/Eclipse.
Thanks.
2013/7/25 j.barrett Strausser j.barrett.straus...@gmail.com
The advice I
Jerome,
There is a really good page on the wiki:
https://cwiki.apache.org/Hive/hiveserver2-clients.html
I use the HiveServer2 JDBC driver. Maybe there are other ways?
Brendan
On Mon, Jul 29, 2013 at 5:47 AM, Jérôme Verdier
verdier.jerom...@gmail.comwrote:
Hi,
Thanks everyone for your
Hi,
I need some help to translate a PL/SQL script in HiveQL.
Problem : my PL/SQL script is calling two functions.
you can see the script below :
SELECT
in_co_societe as co_societe,
'SEMAINE' as co_type_periode,
Hi Jerome,
Yes it looks like you could stop using GET_SEMAINE and directly joining
calendrier_hebdo with calendrier for example. For FCALC_IDJOUR you
will have to make a udf so I hope you have some java skills :)
The calendrier tables suggests you have star schema with a calendar
table. If
Hi Bennie,
I was trying some solutions to pass through my problem, and a problem occurs
here is the error :
FAILED: ParseException line 26:14 cannot recognize input near 'SELECT'
'cal' '.' in expression specification
Is AND...BETWEEN ( SELECT. is possible in Hive?
2013/7/25 Bennie Schut
AFAIK,
Hive supports subqueries only in the FROM clause.
Maybe you have to split you query into more queries...
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+SubQueries
Edson Ramiro
On Thu, Jul 25, 2013 at 9:31 AM, Jérôme Verdier
verdier.jerom...@gmail.comwrote:
The advice I have always seen for your case is to transform the subquery in
the WHERE clause into a LEFT OUTER JOIN.
On Thu, Jul 25, 2013 at 11:04 AM, Edson Ramiro erlfi...@gmail.com wrote:
AFAIK,
Hive supports subqueries only in the FROM clause.
Maybe you have to split you query into
