Dustin DeMeo created ZEPPELIN-1493:
--------------------------------------

             Summary: %sql charting errors for negative values when using 
groupby
                 Key: ZEPPELIN-1493
                 URL: https://issues.apache.org/jira/browse/ZEPPELIN-1493
             Project: Zeppelin
          Issue Type: Bug
          Components: GUI
    Affects Versions: 0.6.1
         Environment: Google Compute, Linux Ubuntu 16.04, Zeppelin 0.6.1 
(download), Spark 2.0.0, Scala 2.11
            Reporter: Dustin DeMeo
            Priority: Minor


Issues when using groupby:
1) "Histogram" chart displays negative values after positive values
2) "Line" charts do not display information for negative values

To reproduce:
1) Create spark zeppelin notebook with default spark interpreter and type code:
{quote}
{{
%spark
val df = Seq((-2), (-1), (-1), (0), (0), (0), (1), (1), (2)).toDF("value")
df.createOrReplaceTempView("df")

%sql
SELECT value, COUNT(1) AS value
FROM   df
GROUP BY value
ORDER BY value
}}
{quote}

2) Check outputs by choosing different chart types. Note that the "table" 
correctly shows the correct values in order. The "histogram" chart treats the 
vales as if they were unsigned. Both "line" charts fail to display information 
for negative values (but are ordered correctly).



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to