search

electroly / sqlnotebook

Casual data exploration in SQL
https://sqlnotebook.com
MIT License
596 stars 35 forks source link

TABLESAMPLE on import fails for views #35

Closed Jongmassey closed 3 years ago

Jongmassey commented 6 years ago

Importing data from a view causes a select query with a TABLESAMPLE clause to be run against that view which causes the following error:

The Import Failed AdoCreate: The TABLESAMPLE clause can only be used with local tables

electroly commented 6 years ago

Great catch! Thank you for reporting this. That is an issue that I will need to fix.