Hi everybody,
I faced a strange error in hive this morning.
The error message is this one :
FAILED: Execution Error, return code 2 from
org.apache.hadoop.hive.ql.exec.MapRedTask
after a quick search on Google, it appears that this is a Hive bug :
https://issues.apache.org/jira/browse/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
[email protected]
INSERT INTO TABLE default.THM_RENTA_RGRP_PRODUITS_JOUR
SELECT * FROM (
-- Cumul OS
SELECT
'${hiveconf:in_co_societe}' as co_societe, -- A modifier
renta_prod.dt_jour,
renta_prod.type_entite,
renta_prod.code_entite,
renta_prod.type_rgrp_produits as type_rgrp_produits,
renta_prod.co_rgrp_produits as co_rgrp_produits,
renta_prod.co_type_ref,
-2 as co_os,
renta_prod.co_trad_ls as co_trad_ls,
min(flg_demarque_valide) as flg_demarque_valide,
sum(me_vente_ht) as me_vente_ht,
sum(me_marge_avt_dem) as me_marge_avt_dem,
sum(me_cession) as me_cession,
sum(qt_vente) as qt_vente,
sum(me_stickers) as me_stickers,
sum(MT_CA_BRUT_TTC) as MT_CA_BRUT_TTC,
SUM(MT_AVANTAGE_AFFECTE) as MT_AVANTAGE_AFFECTE,
SUM(MT_AVANTAGE_NON_AFFECTE) as MT_AVANTAGE_NON_AFFECTE,
SUM(MT_COUPON) as MT_COUPON,
NULL
as FLG_DEM_INC_PRX_CS_VAL,
SUM(MT_CHEQUE_FIDELITE_TTC) as MT_CHEQUE_FIDELITE_TTC,
SUM(MT_CA_NET_TTC) as MT_CA_NET_TTC,
SUM(MT_CHEQUE_FIDELITE_HT) as MT_CHEQUE_FIDELITE_HT,
SUM(NB_PT_AFFECTE) as NB_PT_AFFECTE,
SUM(NB_PT_VALORISE_HT) as NB_PT_VALORISE_HT,
SUM(MT_PT_NON_AFFECTE_HT) as MT_PT_NON_AFFECTE_HT,
SUM(MT_POINTS_FINANCES_HT) as MT_POINTS_FINANCES_HT,
SUM(MT_REMISE_IMMEDIATE_MP_FIN_HT) as MT_REMISE_IMMEDIATE_MP_FIN_HT,
SUM(MT_TARIF_BRUT_TTC) as MT_TARIF_BRUT_TTC,
sum(me_dem_prx_cs) as me_dem_prx_cs,
sum(me_dem_con_prx_cs) as me_dem_con_prx_cs,
sum(me_dem_inc_prx_cs) as me_dem_inc_prx_cs,
sum(me_dem_prov_stk_cs) as me_dem_prov_stk_cs,
sum(qt_dem) as qt_dem,
sum(qt_dem_con) as qt_dem_con,
sum(qt_dem_inc) as qt_dem_inc,
sum(qt_dem_prov_stk) as qt_dem_prov_stk
from
default.THM_RENTA_RGRP_PRODUITS_JOUR renta_prod
WHERE
renta_prod.co_societe = '${hiveconf:in_co_societe}' --A modifier
and renta_prod.dt_jour = '${hiveconf:in_dt_jour}' -- A modifier
and renta_prod.co_os >= 0
GROUP BY
renta_prod.dt_jour,
renta_prod.type_entite,
renta_prod.code_entite,
renta_prod.type_rgrp_produits,
renta_prod.co_rgrp_produits,
renta_prod.co_type_ref,
renta_prod.co_trad_ls
UNION ALL
-- Cumul Total
SELECT
'${hiveconf:in_co_societe}' as co_societe, -- A modifier
renta_prod.dt_jour,
renta_prod.type_entite,
renta_prod.code_entite,
renta_prod.type_rgrp_produits as type_rgrp_produits,
renta_prod.co_rgrp_produits as co_rgrp_produits,
renta_prod.co_type_ref,
-3 as co_os,
renta_prod.co_trad_ls as co_trad_ls,
min(flg_demarque_valide) as flg_demarque_valide,
sum(me_vente_ht) as me_vente_ht,
sum(me_marge_avt_dem) as me_marge_avt_dem,
sum(me_cession) as me_cession,
sum(qt_vente) as qt_vente,
sum(me_stickers) as me_stickers,
sum(MT_CA_BRUT_TTC) as MT_CA_BRUT_TTC,
SUM(MT_AVANTAGE_AFFECTE) as MT_AVANTAGE_AFFECTE,
SUM(MT_AVANTAGE_NON_AFFECTE) as MT_AVANTAGE_NON_AFFECTE,
SUM(MT_COUPON) as MT_COUPON,
NULL as FLG_DEM_INC_PRX_CS_VAL,
SUM(MT_CHEQUE_FIDELITE_TTC) as MT_CHEQUE_FIDELITE_TTC,
SUM(MT_CA_NET_TTC) as MT_CA_NET_TTC,
SUM(MT_CHEQUE_FIDELITE_HT) as MT_CHEQUE_FIDELITE_HT,
SUM(NB_PT_AFFECTE) as NB_PT_AFFECTE,
SUM(NB_PT_VALORISE_HT) as NB_PT_VALORISE_HT,
SUM(MT_PT_NON_AFFECTE_HT) as MT_PT_NON_AFFECTE_HT,
SUM(MT_POINTS_FINANCES_HT) as MT_POINTS_FINANCES_HT,
SUM(MT_REMISE_IMMEDIATE_MP_FIN_HT) as MT_REMISE_IMMEDIATE_MP_FIN_HT,
SUM(MT_TARIF_BRUT_TTC) as MT_TARIF_BRUT_TTC,
sum(me_dem_prx_cs) as me_dem_prx_cs,
sum(me_dem_con_prx_cs) as me_dem_con_prx_cs,
sum(me_dem_inc_prx_cs) as me_dem_inc_prx_cs,
sum(me_dem_prov_stk_cs) as me_dem_prov_stk_cs,
sum(qt_dem) as qt_dem,
sum(qt_dem_con) as qt_dem_con,
sum(qt_dem_inc) as qt_dem_inc,
sum(qt_dem_prov_stk) as qt_dem_prov_stk
from
default.THM_RENTA_RGRP_PRODUITS_JOUR renta_prod
WHERE
renta_prod.co_societe = '${hiveconf:in_co_societe}' -- A modifier
and renta_prod.dt_jour = '${hiveconf:in_dt_jour}' -- A modifier
and renta_prod.co_os >= -1
GROUP BY
renta_prod.dt_jour,
renta_prod.type_entite,
renta_prod.code_entite,
renta_prod.type_rgrp_produits,
renta_prod.co_rgrp_produits,
renta_prod.co_type_ref,
renta_prod.co_trad_ls) test;
