pokyu opened a new issue #5441: the charts error when it include three "group 
by"
URL: https://github.com/apache/incubator-superset/issues/5441
 
 
   Make sure these boxes are checked before submitting your issue - thank you!
   
   - [ ] I have checked the superset logs for python stacktraces and included 
it here as text if any
   - [ ] I have reproduced the issue with at least the latest released version 
of superset
   - [ ] I have checked the issue tracker for the same issue and I haven't 
found one similar
   
   
   ### Superset version
   0.25.6
   
   ### Expected results
   
   
   ### Actual results
   KeyError: u'the label [\u5176\u4ed6] is not in the [index]'
   
   ### Steps to reproduce
   create a charts , the charts sql include three column for "group by"
   
   you can see:
   ```
   2018-07-19 18:51:18,950:ERROR:root:u'the label [\u5176\u4ed6] is not in the 
[index]'
   Traceback (most recent call last):
     File 
"/data/superset/venv/lib/python2.7/site-packages/superset/views/core.py", line 
1107, in generate_json
       payload = viz_obj.get_payload()
     File "/data/superset/venv/lib/python2.7/site-packages/superset/viz.py", 
line 329, in get_payload
       payload['data'] = self.get_data(df)
     File "/data/superset/venv/lib/python2.7/site-packages/superset/viz.py", 
line 722, in get_data
       for metric in df.columns]
     File "/data/superset/venv/lib/python2.7/site-packages/superset/viz.py", 
line 716, in _nest
       for l in df.index.levels[0]]
     File "/data/superset/venv/lib/python2.7/site-packages/superset/viz.py", 
line 716, in _nest
       for l in df.index.levels[0]]
     File 
"/data/superset/venv/lib/python2.7/site-packages/pandas/core/indexing.py", line 
1478, in __getitem__
       return self._getitem_axis(maybe_callable, axis=axis)
     File 
"/data/superset/venv/lib/python2.7/site-packages/pandas/core/indexing.py", line 
1911, in _getitem_axis
       self._validate_key(key, axis)
     File 
"/data/superset/venv/lib/python2.7/site-packages/pandas/core/indexing.py", line 
1798, in _validate_key
       error()
     File 
"/data/superset/venv/lib/python2.7/site-packages/pandas/core/indexing.py", line 
1785, in error
       axis=self.obj._get_axis_name(axis)))
   KeyError: u'the label [\u5176\u4ed6] is not in the [index]'
   ```
   
   sulotion:
   you can update the package pandas to version "0.22.0" , the version "0.23.x" 
will error.
   
   so please update the file "setup.py" ,
   update the row "'pandas>=0.18.0',"  to "'pandas>=0.18.0', <=0.22.0"
   
   
   

----------------------------------------------------------------
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:
[email protected]


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to