Reply
Highlighted
Explorer
Posts: 11
Registered: ‎04-24-2019

Hue Lines chart

Hi Cloudera Family,

am working on some queries using IMPALA with HUE and i want to get result for my BI research but when i select Lines chart i dont get any result ! can anyone help me ! this is the code :

 

WITH q2 AS (
SELECT c2.compteur,
( SUM(c1.jan2016 + c1.feb2016 + c1.mar2016+c1.april2016+c1.may2016+c1.jun2016) * 100 /
SUM(SUM(c1.jan2016 + c1.feb2016 + c1.mar2016+c1.april2016+c1.may2016+c1.jun2016)) OVER ()
) as Perc16
FROM compteur2016 c1 JOIN
compteur c2
ON c1.compteur = c2.compteur
GROUP BY c2.compteur)
, q1 AS
(SELECT c2.compteur, c2.naturebat,
( SUM(c1.jan15 + c1.feb15 + c1.mar15 + c1.apr15 + c1.may15 + c1.jun15) * 100 /
SUM(SUM(c1.jan15 + c1.feb15 + c1.mar15 + c1.apr15 + c1.may15 + c1.jun15)) OVER ()
) as Perc15
FROM compteur2015 c1 JOIN
compteur c2
ON c1.compteur = c2.compteur
GROUP BY c2.naturebat , c2.compteur )
select q1.compteur, q1.Perc15 , q2.Perc16, q1.naturebat
FROM q1
JOIN q2 ON q1.compteur = q2.compteur
ORDER BY q2.Perc16 DESC
LIMIT 50

 

Screenshot from 2019-06-01 03-51-20.png