[GitHub] syzuhdi opened a new issue #4770: Cannot display Time Series Line Chart

[GitBox]

syzuhdi opened a new issue #4770: Cannot display Time Series Line Chart
URL: https://github.com/apache/incubator-superset/issues/4770
 
 
   Make sure these boxes are checked before submitting your issue - thank you!
   
   - [X] I have checked the superset logs for python stacktraces and included 
it here as text if any
   - [X] I have reproduced the issue with at least the latest released version 
of superset
   - [X] I have checked the issue tracker for the same issue and I haven't 
found one similar
   
   
   ### Superset version
   0.22.1
   
   
   ### Expected results
   Data shown in Time series Line Chart
   
   
   ### Actual results
   
   
![image](https://user-images.githubusercontent.com/3960310/38398637-94b51a42-3977-11e8-9f44-10c815f87431.png)
   
   When I click Run Query button in Slices, an error occur.
   Error u'CITY'
   
   Traceback (most recent call last):
     File "/usr/local/venv/lib/python2.7/site-packages/superset/viz.py", line 
278, in get_payload
       data = self.get_data(df)
     File "/usr/local/venv/lib/python2.7/site-packages/superset/viz.py", line 
1045, in get_data
       df = self.process_data(df)
     File "/usr/local/venv/lib/python2.7/site-packages/superset/viz.py", line 
981, in process_data
       values=fd.get('metrics'))
     File 
"/usr/local/venv/lib/python2.7/site-packages/pandas/core/reshape/pivot.py", 
line 135, in pivot_table
       grouped = data.groupby(keys)
     File "/usr/local/venv/lib/python2.7/site-packages/pandas/core/generic.py", 
line 4416, in groupby
       **kwargs)
     File "/usr/local/venv/lib/python2.7/site-packages/pandas/core/groupby.py", 
line 1699, in groupby
       return klass(obj, by, **kwds)
     File "/usr/local/venv/lib/python2.7/site-packages/pandas/core/groupby.py", 
line 392, in __init__
       mutated=self.mutated)
     File "/usr/local/venv/lib/python2.7/site-packages/pandas/core/groupby.py", 
line 2690, in _get_grouper
       raise KeyError(gpr)
   KeyError: u'CITY'
   
   And this is the QUERY
   
   SELECT "CITY",
          "__timestamp",
          "count_QTY"
   FROM
     (SELECT "CITY" AS "CITY",
             "REGN_DATE" AS "__timestamp",
             count(VIN_NO) AS "count_QTY"
      FROM
        (SELECT *
         FROM mycrm_registration) expr_qry
      JOIN
        (SELECT "CITY__",
                mme_inner__
         FROM
           (SELECT "CITY" AS "CITY__",
                   count(VIN_NO) AS mme_inner__
            FROM
              (SELECT *
               FROM mycrm_registration) expr_qry
            WHERE "REGN_DATE" >= TO_TIMESTAMP('2018-03-30T00:00:00', 
'YYYY-MM-DD"T"HH24:MI:SS.ff6')
              AND "REGN_DATE" <= TO_TIMESTAMP('2018-04-06T08:20:13', 
'YYYY-MM-DD"T"HH24:MI:SS.ff6')
            GROUP BY "CITY"
            ORDER BY count(VIN_NO) DESC)
         WHERE ROWNUM <= 100) anon_1 ON "CITY" = "CITY__"
      WHERE "REGN_DATE" >= TO_TIMESTAMP('2018-03-30T00:00:00', 
'YYYY-MM-DD"T"HH24:MI:SS.ff6')
        AND "REGN_DATE" <= TO_TIMESTAMP('2018-04-06T08:20:13', 
'YYYY-MM-DD"T"HH24:MI:SS.ff6')
      GROUP BY "CITY",
               "REGN_DATE"
      ORDER BY count(VIN_NO) DESC)
   WHERE ROWNUM <= 50000
   
   Any idea?
   
   ### Steps to reproduce
   
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services