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
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
, 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
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
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
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
, 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
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
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
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
...
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
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,
.
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
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
}'
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
,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
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
: 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
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
,
COALESCE(pnvente.id_produit,dem.id_produit)
Thanks.
--
*Jérôme VERDIER*
06.72.19.17.31
verdier.jerom...@gmail.com
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
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
@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
--
*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
-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
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
, 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
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
28 matches
Mail list logo