[explore] [v1/v2] exploring a datasource throws error

[ascott]

• i can repro this on master, on staging, but not on the latest release.

[bkyryliuk]

@ascott - it is a release blocker?

[ascott]

@bkyryliuk yes, we shouldn't push this bug to a release.

[ascott]

@mistercrunch do you think this could be related to your changes ?e46ba2b#diff-3b162e04e00bcf00c104545b856a4105

[ascott]

this is happening on /expore/table/{id} as well as on Table View slices where there are no group by clauses.

https://github.com/ascott/superset/blob/master/superset/viz.py#L202
self.datasource.query(**query_obj) is returning a failed query with this error.

'(sqlite3.OperationalError) near "FROM": syntax error [SQL: u"SELECT\\nFROM 
birth_names\\nWHERE ds >= \'2017-01-23 21:45:44.000000\'\\n  AND ds <= \'2017-01-30 
21:45:44.000000\' LIMIT 50000\\nOFFSET 0"]'

the query it's trying to run is

SELECT\nFROM birth_names\nWHERE ds >= '2017-01-23 21:45:44.000000'\n 
AND ds <= '2017-01-30 21:45:44.000000' LIMIT 50000\nOFFSET 0

when it should be

SELECT *\nFROM birth_names\nWHERE ds >= '2017-01-23 21:45:44.000000'\n  
AND ds <= '2017-01-30 21:45:44.000000' LIMIT 50000\nOFFSET 0

this is as far as I've gotten with this one. @bkyryliuk @mistercrunch @vera-liu anyone have any ideas how to fix this? the backend is not my strong point.