Export d'un fichier texte depuis une requete sql

jeankri_goodit · October 2, 2023, 3:22pm

Here is my request
SELECT *
INTO OUTFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/file11.txt'
FROM w_article_srvv_et_bo

here is my error message
The Select statement did not produce a ResultSet for the native query.

Luiggi · October 2, 2023, 3:27pm

Metabase always expects a result when you fire a query, it will return that error if the query does not return any result

Luiggi · October 2, 2023, 3:31pm

github.com/metabase/metabase

Catch "The Select statement did not produce a ResultSet for the native query" and show that we need a result

opened 03:30PM - 02 Oct 23 UTC

paoliniluis

Type:New Feature Querying/Native

**Is your feature request related to a problem? Please describe.** Many people …love to send queries to Metabase which don't return results and think that's an error on our end. We should catch the error and show a little message like: "The database didn't return anything, Metabase needs a response from the database to work" **Describe the solution you'd like** Catch "The Select statement did not produce a ResultSet for the native query" error and return a beautified message in the frontend **Describe alternatives you've considered** None **How important is this feature to you?** Nice to have **Additional context** NA