Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Some errors in the metabase logs seemingly related to this plugin #35

Open
ovizii opened this issue Dec 1, 2022 · 0 comments
Open

Some errors in the metabase logs seemingly related to this plugin #35

ovizii opened this issue Dec 1, 2022 · 0 comments

Comments

@ovizii
Copy link

ovizii commented Dec 1, 2022

I tried adding a sample user report to metabase v0.44.6 using this driver, and it worked. I can see and explore the content of the .csv file just fine but when I checked metabase's logs I see errors.

I'll post a partial error log here, if you need more please let me know.

[49cf1a7a-8997-4408-959e-ddc4e16679f0] 2022-12-01T19:26:24+01:00 INFO metabase.sync.util STARTING: Analyze data for csv Database 36 'GData sample reports'
[49cf1a7a-8997-4408-959e-ddc4e16679f0] 2022-12-01T19:26:24+01:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for csv Database 36 'GData sample reports'
[49cf1a7a-8997-4408-959e-ddc4e16679f0] 2022-12-01T19:26:24+01:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [************······································] 😒   25% Table 101 'PUBLIC.sample-user-report'
[49cf1a7a-8997-4408-959e-ddc4e16679f0] 2022-12-01T19:26:24+01:00 WARN metabase.sync.util Error fingerprinting Table 101 'PUBLIC.sample-user-report'
clojure.lang.ExceptionInfo: Error executing query: Syntax error: derived tables not supported {:sql "-- Metabase\nSELECT \"source\".\"substring594\" AS \"substring594\", \"source\".\"substring595\" AS \"substring595\", \"source\".\"substring596\" AS \"substring596\", \"source\".\"substring597\" AS \"substring597\", \"source\".\"substring598\" AS \"substring598\", \"source\".\"substring599\" AS \"substring599\", \"source\".\"substring600\" AS \"substring600\", \"source\".\"substring601\" AS \"substring601\", \"source\".\"substring602\" AS \"substring602\", \"source\".\"substring603\" AS \"substring603\" FROM (SELECT \"PUBLIC\".\"sample-user-report\".\"E-Mail-Adresse\" AS \"E-Mail-Adresse\", \"PUBLIC\".\"sample-user-report\".\"Letzter Zugriff des Benutzers\" AS \"Letzter Zugriff des Benutzers\", \"PUBLIC\".\"sample-user-report\".\"Nachname\" AS \"Nachname\", \"PUBLIC\".\"sample-user-report\".\"Vorname\" AS \"Vorname\", \"PUBLIC\".\"sample-user-report\".\"Zweige\" AS \"Zweige\", \"PUBLIC\".\"sample-user-report\".\"Name des Lernplans\" AS \"Name des Lernplans\", \"PUBLIC\".\"sample-user-report\".\"Abschlussdatum\" AS \"Abschlussdatum\", \"PUBLIC\".\"sample-user-report\".\"Einschreibungsdatum\" AS \"Einschreibungsdatum\", \"PUBLIC\".\"sample-user-report\".\"Fertigstellungsgrad\" AS \"Fertigstellungsgrad\", \"PUBLIC\".\"sample-user-report\".\"Status der Einschreibung zum Lernplan\" AS \"Status der Einschreibung zum Lernplan\", substring(\"PUBLIC\".\"sample-user-report\".\"Einschreibungsdatum\", 1, 1234) AS \"substring601\", substring(\"PUBLIC\".\"sample-user-report\".\"Vorname\", 1, 1234) AS \"substring602\", substring(\"PUBLIC\".\"sample-user-report\".\"E-Mail-Adresse\", 1, 1234) AS \"substring600\", substring(\"PUBLIC\".\"sample-user-report\".\"Letzter Zugriff des Benutzers\", 1, 1234) AS \"substring596\", substring(\"PUBLIC\".\"sample-user-report\".\"Nachname\", 1, 1234) AS \"substring595\", substring(\"PUBLIC\".\"sample-user-report\".\"Name des Lernplans\", 1, 1234) AS \"substring598\", substring(\"PUBLIC\".\"sample-user-report\".\"Zweige\", 1, 1234) AS \"substring594\", substring(\"PUBLIC\".\"sample-user-report\".\"Fertigstellungsgrad\", 1, 1234) AS \"substring597\", substring(\"PUBLIC\".\"sample-user-report\".\"Status der Einschreibung zum Lernplan\", 1, 1234) AS \"substring599\", substring(\"PUBLIC\".\"sample-user-report\".\"Abschlussdatum\", 1, 1234) AS \"substring603\" FROM \"PUBLIC\".\"sample-user-report\") \"source\" LIMIT 10000", :params nil, :type :invalid-query}

The important bits seem to be

Error executing query: Syntax error: derived tables not supported and
:invalid-query

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant