Hey Everybody,
This problem still did not work. Any advice?
Thanks and Regards,
Mainak.
From: Mainak Ghosh/Almaden/IBM@IBMUS
To: user@hive.apache.org,
Date: 07/17/2013 02:12 PM
Subject:Re: Question regarding external table and csv in NFS
Hey Saurabh,
I tried this command a
Below you can find the 3 working queries from my script :
rank() over (partition by sg.co_societe,sg.id_produit order by sg.date_maj
desc,sg.co_type_ref) as rang
RANK(pnvente.dt_debut_commercial,
COALESCE(pnvente.id_produit,dem.id_produit)) OVER (PARTITION BY
mag.co_magasin, dem.id_produit ORDER
Please send the fnal working queries.
On Friday, July 19, 2013, Jérôme Verdier wrote:
> Hi,
>
> The error is resolved.
>
> I have 3 RANK() function in my script.
>
> 2 are working with arguments, but one is working without arguments.
>
> I don't understand it, but the fact is it's working =)
>
>
> Error: Java heap space
Guess this should give a hint.
On Fri, Jul 19, 2013 at 4:22 AM, ch huang wrote:
> why the task failed? anyone can help?
>
>
> hive> select cookieid,count(url) as visit_num from alex_test_big_seq group
> by cookieid order by visit_num desc limit 10;
>
> MapReduce Total
why the task failed? anyone can help?
hive> select cookieid,count(url) as visit_num from alex_test_big_seq group
by cookieid order by visit_num desc limit 10;
MapReduce Total cumulative CPU time: 49 minutes 20 seconds 870 msec
Ended Job = job_1374214993631_0037 with errors
Error during job, obta
Huang, the number of records are huge and we do not know what your table
definition is or what your cluster capacity is?
there are multiple reasons that query is slow
Can you share all the details on
1) Whats your table definition?
2) Whats the cluster capacity?
3) when you launched query did the
Why not?
Try and let us know as well :)
On Fri, Jul 19, 2013 at 7:54 AM, ch huang wrote:
> ATT
--
Nitin Pawar
You may have to write a udf to do the actions performed by the script as a
function side query
or use your query in transformed by clause and you will have to manipulate
data with subqueries
On Fri, Jul 19, 2013 at 1:28 PM, Jérôme Verdier
wrote:
> Wrong manipulation, mail was sent but not finish
Wrong manipulation, mail was sent but not finished...
so, the script who call another script is here :
SELECT
cal.dt_jour_deb
FROM default.calendrier_hebdo cal -- Importer
ods.calendrier_hebdo
WHERE cal.co_societe = '${hiveconf:in_co_societe}'
Hi,
I'm working on another PL/SQL script, and i have to translate it in HiveQL.
This PL/SQL script is calling another script, like this :
SELECT
cal.dt_jour_deb
FROM default.calendrier_hebdo cal -- Importer
ods.calendrier_hebdo
WHERE cal.co_societe =
Hi,
The error is resolved.
I have 3 RANK() function in my script.
2 are working with arguments, but one is working without arguments.
I don't understand it, but the fact is it's working =)
Thanks everyone for your help.
2013/7/18 Jérôme Verdier
> Hi,
>
> Since we saw that we have to give a
11 matches
Mail list logo
