[GitHub] rumbin commented on issue #1929: Error with postgres columns of type "TIMESTAMP WITH TIME ZONE"

[GitBox <gi...@apache.org>]

rumbin commented on issue #1929: Error with postgres columns of type "TIMESTAMP WITH TIME ZONE"
URL: https://github.com/apache/incubator-superset/issues/1929#issuecomment-343766198
 
 
   ## Short update on superset 0.20.5:
   
   In SQLLab the issue ist still present:
   
   ```
   [2017-11-12 21:25:03,039: ERROR/ForkPoolWorker-18] zip argument #2 must support iteration
   Traceback (most recent call last):
     File "/opt/apps/superset/venv_superset_0.20.5/lib64/python3.4/site-packages/superset/sql_lab.py", line 94, in get_sql_results
       ctask, query_id, return_results, store_results, user_name)
     File "/opt/apps/superset/venv_superset_0.20.5/lib64/python3.4/site-packages/superset/sql_lab.py", line 241, in execute_sql
       'data': cdf.data if cdf.data else [],
     File "/opt/apps/superset/venv_superset_0.20.5/lib64/python3.4/site-packages/superset/dataframe.py", line 52, in data
       return self.__df.to_dict(orient='records')
     File "/opt/apps/superset/venv_superset_0.20.5/lib64/python3.4/site-packages/pandas/core/frame.py", line 898, in to_dict
       for row in self.values]
     File "/opt/apps/superset/venv_superset_0.20.5/lib64/python3.4/site-packages/pandas/core/frame.py", line 898, in <listcomp>
       for row in self.values]
   TypeError: zip argument #2 must support iteration
   ```
   
   ### How to reproduce
   
   ```
   select current_timestamp
   ```
   
   or equivalently
   ```
   select now()
   ```
   
   It is definitely caused by the combination of date and timezone, since the following selects work without any problems:
   
   Time with timezone:
   ```
   select current_time
   ```
   
   Timestamp without timezone:
   ```
   select localtimestamp
   ```
   or
   ```
   select now()::timestamp
   ```
   
   ### Impact
   In our configuration (Postgres, Celery backend for SQLLab, Redis Cache) this bug manages to paralyze SQLLab for quite some time, hindering subsequent queries to succeed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services