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
> Jerome,
>
> There is a really good page on the
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
wrote:
> Hi,
>
> Thanks everyone for your help.
>
> Has anyone have
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
> The advice I have always seen for your cas
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 wrote:
> AFAIK,
>
> Hive supports subqueries only in the FROM clause.
>
> Maybe you have to split you query into more queries...
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
wrote:
> Hi Bennie,
>
> I was tryi
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
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
tabl
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,
a.
