Re: Hive + mongoDB

mongo and hive . now how to import the data from mongodb to hive ? Thanks in advance. -- --Regards Sandeep Nemuri -- *Jérôme VERDIER* 06.72.19.17.31 verdier.jerom...@gmail.com

Re: Problème with min function in HiveQL

prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You. -- *Jérôme VERDIER* 06.72.19.17.31 verdier.jerom...@gmail.com

Re: Problème with min function in HiveQL

, Aug 30, 2013 at 1:17 AM, Jérôme Verdier verdier.jerom...@gmail.com wrote: Ok, thanks for this solution. Unfortunately, i have rewrited my script like this : INSERT INTO TABLE default.THM_CA_RGRP_PRODUITS_SEM SELECT '${hiveconf:in_co_societe}' as co_societe

Re: Problème with min function in HiveQL

Hi, Is it possible to have multiple conditions in Having clause ? I get an error when i'm trying this. Thanks a lot. 2013/8/30 Jérôme Verdier verdier.jerom...@gmail.com Thanks Stephen, Yes i realise that it was so a stupid questionMaybe i wasn't really awaked this morning ;-) now

Problème with min function in HiveQL

Hi everybody, I am coding some HiveQL script to do some calculations. I have a problem with the min() function. My hive script is below : INSERT INTO TABLE default.THM_CA_RGRP_PRODUITS_SEM SELECT '${hiveconf:in_co_societe}' as co_societe,

Re: Problème with min function in HiveQL

: Re: Problème with min function in HiveQL the min function at column 62 is on on the column b.dt_jour. what datatype is that? if its of type 'timestamp' that might explain it. On Thu, Aug 29, 2013 at 3:01 AM, Jérôme Verdier verdier.jerom...@gmail.comwrote: Hi everybody, I am coding some

Re: Strange error in Hive - Insert INTO

, Jérôme Verdier verdier.jerom...@gmail.com wrote: Hi everybody, I faced a strange error in Hive today. I have launch a hive script to make some calculations, joins, union, etc... and then insert these results in over hive table. Everything is working fine (.hql is working, full ok

Strange error in Hive - Insert INTO

Hi everybody, I faced a strange error in Hive today. I have launch a hive script to make some calculations, joins, union, etc... and then insert these results in over hive table. Everything is working fine (.hql is working, full ok, data are imported), but one field (CO_RGRP_PRODUITS) is very

Problem in Hive Right Outer Join

Hi, I encountered a problem with Right Outer Join in Hive. Here is where is the problem : FROM default.ca ca JOIN default.kpi_magasin mtransf ON mtransf.co_societe = (CASE WHEN ca.co_societe = 1 THEN 1 ELSE 2 END) AND mtransf.id_magasin = ca.id_magasin

Re: PL/SQL to HiveQL translation

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.com wrote: Hi, Thanks everyone for your help. Has anyone have

Re: PL/SQL to HiveQL translation

... 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.com wrote: Hi Bennie, I was trying some solutions to pass through my problem, and a problem occurs here

PL/SQL to HiveQL translation

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,

Re: PL/SQL to HiveQL translation

. Op 25-7-2013 09:50, Jérôme Verdier schreef: 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

Calling Hive script in another Hive script

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

Re: Calling Hive script in another Hive script

}' AND cal.co_an_semaine = ods.package_date.get_semaine( -- script call ods.package_date.fcalc_idjour( -- Script call What is the best way to do this in Hive ? 2013/7/19 Jérôme Verdier verdier.jerom...@gmail.com Hi, I'm working on another PL/SQL script, and i have

Re: Use RANK OVER PARTITION function in Hive 0.11

,dem.id_produit) DESC) as rang 2013/7/19 Edward Capriolo edlinuxg...@gmail.com Please send the fnal working queries. On Friday, July 19, 2013, Jérôme Verdier verdier.jerom...@gmail.com wrote: Hi, The error is resolved. I have 3 RANK() function in my script. 2 are working

Re: Use RANK OVER PARTITION function in Hive 0.11

Hi Vijay, Could you give me an example, i'm not sure of what you're meaning. Thanks, 2013/7/17 Vijay tec...@gmail.com As the error message states: One ore more arguments are expected, you have to pass a column to the rank function. On Wed, Jul 17, 2013 at 1:12 AM, Jérôme Verdier

Re: Use RANK OVER PARTITION function in Hive 0.11

: One ore more arguments are expected, you have to pass a column to the rank function. On Wed, Jul 17, 2013 at 1:12 AM, Jérôme Verdier verdier.jerom...@gmail.com wrote: Hi Richa, I have tried a simple query without joins, etc SELECT RANK() OVER (PARTITION BY mag.co_societe ORDER

Re: Strange error in hive

Hi, I have apply this patch but unfortunately, the error is still the same when i run the script. Thanks, 2013/7/16 Navis류승우 navis@nexr.com patch -p0 -i file-name would work. https://cwiki.apache.org/confluence/display/Hive/HowToContribute 2013/7/15 Jérôme Verdier verdier.jerom

Use RANK OVER PARTITION function in Hive 0.11

, COALESCE(pnvente.id_produit,dem.id_produit) Thanks. -- *Jérôme VERDIER* 06.72.19.17.31 verdier.jerom...@gmail.com

Re: Use RANK OVER PARTITION function in Hive 0.11

and on top of it apply these aggregate functions Richa On Tue, Jul 16, 2013 at 2:15 PM, Jérôme Verdier verdier.jerom...@gmail.com wrote: Hi, I have a problem while using RANK OVER PARTITION function with Hive. Hive is in version 0.11 and, as we can see here : https://cwiki.apache.org/Hive

Re: Use RANK OVER PARTITION function in Hive 0.11

PM, Jérôme Verdier verdier.jerom...@gmail.com wrote: Hi Richa, I tried to execute the rank function alone, but the result is the same Thanks 2013/7/16 Richa Sharma mailtorichasha...@gmail.com Hi Jerome I think the problem is you are trying to use MIN, SUM and RANK function

Re: Strange error in hive

@nexr.com: Could you try to remove NULL as FLG_DEM_INC_PRX_CS_VALs in the query? It seemed not related to HIVE-4650 but still a bug (I'll book this) 2013/7/9 Jérôme Verdier verdier.jerom...@gmail.com: Hi, Thanks for your help. You can see logs below : java.lang.RuntimeException

Re: Strange error in hive

-- *From: * Jérôme Verdier verdier.jerom...@gmail.com *Date: *Mon, 8 Jul 2013 11:25:34 +0200 *To: *user@hive.apache.org *ReplyTo: * user@hive.apache.org *Subject: *Strange error in hive Hi everybody, I faced a strange error in hive this morning. The error message is this one

Strange error in hive

-4650 Is there a way to pass through this error ? Thanks. NB : my hive script is in the attachment. -- *Jérôme VERDIER* 06.72.19.17.31 verdier.jerom...@gmail.com INSERT INTO TABLE default.THM_RENTA_RGRP_PRODUITS_JOUR SELECT * FROM ( -- Cumul OS SELECT

Re: Dealing with differents date format

arithmetic to get the year and month. eg. year = floor( your int/1) and month = cast( your int % 100 as int) [% == modulus operator] or am i not even answering your question? On Tue, Jul 2, 2013 at 2:42 AM, Jérôme Verdier verdier.jerom...@gmail.com wrote: Hi, i trying

Re: Dealing with differents date format

, Jérôme Verdier verdier.jerom...@gmail.com wrote: Hi Stephen, Thanks for your reply. The problem is that my input date is this : in_co_an_mois (format : MM, integer), for example, this month, we have 201307 and i have to deal with this date : add one month, compare to over date

Dealing with differents date format

Hi, i trying to translate some PL/SQL script in HiveQL, and dealing with unusual date format. i added a variable in my hive script : '${hiveconf:in_co_an_mois}' which is a year/month date format, like this : 201307 (INT format). I would like to transform this in date format, because i have to