andrewmusselman commented on issue #1690: SQL Lab exception when executed query is not limited or with a limit > SQL_MAX_ROW URL: https://github.com/apache/incubator-superset/issues/1690#issuecomment-614313886 Sure, here is the schema I'm running it against: ``` views date DATE time TIME WITHOUT TIME ZONE ip INET checksum VARCHAR media VARCHAR segment VARCHAR time_taken VARCHAR ua VARCHAR mapping id VARCHAR title VARCHAR checksum VARCHAR ``` Query: ``` select date , count(*) from (select distinct v.date as date , v.ip as ip from views v) as dist_user_asset_date group by date order by date asc; ``` This query ran okay in another install of superset, and works fine in the postgres repl.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to 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]
