Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hue Lines chart

Highlighted

Hue Lines chart

Explorer

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