[GitHub] Vishnuprasadverma commented on issue #3524: Cannot created temp table in redshift DB

[gi...@git.apache.org]

Vishnuprasadverma commented on issue #3524: Cannot created temp table in redshift DB
URL: https://github.com/apache/incubator-superset/issues/3524#issuecomment-331980569
 
 
   When i fire "create temp table" query in sqllab it does not work for redshift DB.
   exact query 
   create temp table hello(col1 int);
   output:
   The query returned no data
   
   stacktrace:
   [2017-09-25 19:00:18,088: WARNING/Worker-19] /usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/sqltypes.py:596: SAWarning: Dialect sqlite+pysqlite does *not* support Decimal objects natively, and SQLAlchemy must convert from floating point - rounding errors and other issues may occur. Please consider storing Decimal numbers as strings or integers on this platform for lossless storage.
     'storage.' % (dialect.name, dialect.driver))
   
   stacktrace
   2017-09-25 19:00:16,130:INFO:root:[stats_logger] (incr) results
   2017-09-25 19:00:16,133:INFO:root:Parsing with sqlparse statement create temp table hello(col1 int);
   2017-09-25 19:00:16,142:INFO:werkzeug:115.249.48.25 - - [25/Sep/2017 19:00:16] "GET /superset/results/a5cfeedf-03d5-4c0c-b505-8dce26c04341/ HTTP/1.1" 200 -
   2017-09-25 19:00:18,058:INFO:root:[stats_logger] (incr) sql_json
   2017-09-25 19:00:18,060:INFO:root:Parsing with sqlparse statement create temp table hello(col1 int);
   2017-09-25 19:00:18,071:INFO:root:Triggering query_id: 76
   2017-09-25 19:00:18,071:INFO:root:Running query on a Celery worker
   2017-09-25 19:00:18,083:INFO:werkzeug:115.249.48.25 - - [25/Sep/2017 19:00:18] "POST /superset/sql_json/ HTTP/1.1" 202 -
   
   
 
----------------------------------------------------------------
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