Repository navigation
Metabase not fully working #161
Answered
by
jgreet
leonardobork
asked this question in
Bug Reports
|
Hey, I was able to query native SQL into my Metabase instance via a PlanetScale connection. Although some features seem not to be fully functional.
Has anyone ever looked into it? Thanks, 😊 |
Answered by
jgreet
Feb 11, 2022
Replies: 3 comments 10 replies
|
I tried to hook up Metabase Cloud and I think see what's happening. When Metabase scans the table schema, it issues a query that Vitess can't currently handle: The good news is, testing with the upcoming Gen4 query planner things seem to work better. I can't guarantee full compatibility but I was at least able to explore and filter tables without those Unfortunately I don't have a rollout date for the new query planner. We might be able to flag your database in early to test it, let us know if you're interested. |
9 replies
|
@jgreet Any chance there's an update on this? Thank you. |
|
@ambiguous48 The situation is the same as above. We don't have the Gen4 query planner rolled out by default, but it seems to solve that initial |
|
Thanks for the quick reponse. Sadly I'm still getting the same/similar error even after opting into the Gen4 query planner. I'm not sure if it's a configuration error on my part or if some update broke the compatibility since you posted your original answer. The error shown in the UI is Digging though the logs, it seems there's an issue happening when metabase tries to sync with the database: Curiously enough, writing a an sql query by hand in the Metabase SQL editor works fine. Details``` java.sql.SQLSyntaxErrorException: (conn=3189) Comparing table schema name with a column name not yet supported at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:153) at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:274) at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:363) at org.mariadb.jdbc.MariaDbStatement.executeQuery(MariaDbStatement.java:612) at org.mariadb.jdbc.MariaDbDatabaseMetaData.executeQuery(MariaDbDatabaseMetaData.java:510) at org.mariadb.jdbc.MariaDbDatabaseMetaData.getPrimaryKeys(MariaDbDatabaseMetaData.java:611) at com.mchange.v2.c3p0.impl.NewProxyDatabaseMetaData.getPrimaryKeys(NewProxyDatabaseMetaData.java:3198) at metabase.driver.sql_jdbc.sync.describe_table$add_table_pks$fn__53592.invoke(describe_table.clj:147) at metabase.driver.sql_jdbc.sync.common$reducible_results$reify__53521.reduce(common.clj:34) at clojure.core$reduce.invokeStatic(core.clj:6829) at clojure.core$into.invokeStatic(core.clj:6897) at clojure.core$into.invoke(core.clj:6889) at metabase.driver.sql_jdbc.sync.describe_table$add_table_pks.invokeStatic(describe_table.clj:147) at metabase.driver.sql_jdbc.sync.describe_table$add_table_pks.invoke(describe_table.clj:144) at metabase.driver.sql_jdbc.sync.describe_table$describe_table_STAR_.invokeStatic(describe_table.clj:161) at metabase.driver.sql_jdbc.sync.describe_table$describe_table_STAR_.invoke(describe_table.clj:156) at metabase.driver.sql_jdbc.sync.describe_table$describe_table.invokeStatic(describe_table.clj:170) at metabase.driver.sql_jdbc.sync.describe_table$describe_table.invoke(describe_table.clj:163) at metabase.driver.sql_jdbc$fn__82005.invokeStatic(sql_jdbc.clj:66) at metabase.driver.sql_jdbc$fn__82005.invoke(sql_jdbc.clj:64) at clojure.lang.MultiFn.invoke(MultiFn.java:239) at metabase.sync.fetch_metadata$fn__62829$table_metadata__62834$fn__62835.invoke(fetch_metadata.clj:18) at metabase.sync.fetch_metadata$fn__62829$table_metadata__62834.invoke(fetch_metadata.clj:15) at metabase.sync.sync_metadata.fields.fetch_metadata$fn__63073$db_metadata__63078$fn__63079.invoke(fetch_metadata.clj:87) at metabase.sync.sync_metadata.fields.fetch_metadata$fn__63073$db_metadata__63078.invoke(fetch_metadata.clj:83) at metabase.sync.sync_metadata.fields$fn__63568$sync_fields_for_table_BANG___63577$fn__63580$fn__63581.invoke(fields.clj:72) at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158) at metabase.sync.util$do_with_error_handling.invoke(util.clj:151) at metabase.sync.sync_metadata.fields$fn__63568$sync_fields_for_table_BANG___63577$fn__63580.invoke(fields.clj:71) at metabase.sync.sync_metadata.fields$fn__63568$sync_fields_for_table_BANG___63577.invoke(fields.clj:65) at clojure.core$partial$fn__5857.invoke(core.clj:2628) at clojure.core$map$fn__5884.invoke(core.clj:2757) at clojure.lang.LazySeq.sval(LazySeq.java:42) at clojure.lang.LazySeq.seq(LazySeq.java:51) at clojure.lang.RT.seq(RT.java:535) at clojure.core$seq__5419.invokeStatic(core.clj:139) at clojure.core$filter$fn__5911.invoke(core.clj:2813) at clojure.lang.LazySeq.sval(LazySeq.java:42) at clojure.lang.LazySeq.seq(LazySeq.java:51) at clojure.lang.Cons.next(Cons.java:39) at clojure.lang.RT.boundedLength(RT.java:1793) at clojure.lang.RestFn.applyTo(RestFn.java:130) at clojure.core$apply.invokeStatic(core.clj:669) at clojure.core$apply.invoke(core.clj:662) at metabase.sync.sync_metadata.fields$fn__63606$sync_fields_BANG___63611$fn__63612.invoke(fields.clj:85) at metabase.sync.sync_metadata.fields$fn__63606$sync_fields_BANG___63611.invoke(fields.clj:77) at clojure.lang.AFn.applyToHelper(AFn.java:154) at clojure.lang.AFn.applyTo(AFn.java:144) at clojure.core$apply.invokeStatic(core.clj:669) at clojure.core$apply.invoke(core.clj:662) at metabase.sync.util$fn__40630$run_step_with_metadata__40635$fn__40639$fn__40641.doInvoke(util.clj:388) at clojure.lang.RestFn.invoke(RestFn.java:397) at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100) at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94) at metabase.sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:117) at metabase.sync.util$with_start_and_finish_debug_logging.invoke(util.clj:114) at metabase.sync.util$fn__40630$run_step_with_metadata__40635$fn__40639.invoke(util.clj:383) at metabase.sync.util$fn__40630$run_step_with_metadata__40635.invoke(util.clj:378) at metabase.sync.util$fn__40846$run_sync_operation__40851$fn__40852$fn__40860.invoke(util.clj:489) at metabase.sync.util$fn__40846$run_sync_operation__40851$fn__40852.invoke(util.clj:487) at metabase.sync.util$fn__40846$run_sync_operation__40851.invoke(util.clj:481) at metabase.sync.sync_metadata$fn__65100$sync_db_metadata_BANG___65105$fn__65106$fn__65107.invoke(sync_metadata.clj:50) at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158) at metabase.sync.util$do_with_error_handling.invoke(util.clj:151) at clojure.core$partial$fn__5859.invoke(core.clj:2634) at metabase.driver$fn__19203.invokeStatic(driver.clj:562) at metabase.driver$fn__19203.invoke(driver.clj:562) at clojure.lang.MultiFn.invoke(MultiFn.java:239) at metabase.sync.util$sync_in_context$fn__40539.invoke(util.clj:136) at metabase.sync.util$with_db_logging_disabled$fn__40536.invoke(util.clj:127) at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100) at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94) at metabase.sync.util$with_start_and_finish_logging$fn__40525.invoke(util.clj:112) at metabase.sync.util$with_sync_events$fn__40520.invoke(util.clj:86) at metabase.sync.util$with_duplicate_ops_prevented$fn__40511.invoke(util.clj:65) at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:179) at metabase.sync.util$do_sync_operation.invoke(util.clj:176) at metabase.sync.sync_metadata$fn__65100$sync_db_metadata_BANG___65105$fn__65106.invoke(sync_metadata.clj:49) at metabase.sync.sync_metadata$fn__65100$sync_db_metadata_BANG___65105.invoke(sync_metadata.clj:46) at metabase.sync$fn__65157$sync_database_BANG___65166$fn__65172$fn__65174$fn__65176.invoke(sync.clj:45) at clojure.core$mapv$fn__8468.invoke(core.clj:6914) at clojure.lang.ArrayChunk.reduce(ArrayChunk.java:58) at clojure.core.protocols$fn__8176.invokeStatic(protocols.clj:136) at clojure.core.protocols$fn__8176.invoke(protocols.clj:124) at clojure.core.protocols$fn__8136$G__8131__8145.invoke(protocols.clj:19) at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:31) at clojure.core.protocols$fn__8168.invokeStatic(protocols.clj:75) at clojure.core.protocols$fn__8168.invoke(protocols.clj:75) at clojure.core.protocols$fn__8110$G__8105__8123.invoke(protocols.clj:13) at clojure.core$reduce.invokeStatic(core.clj:6830) at clojure.core$mapv.invokeStatic(core.clj:6905) at clojure.core$mapv.invoke(core.clj:6905) at metabase.sync$fn__65157$sync_database_BANG___65166$fn__65172$fn__65174.invoke(sync.clj:45) at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158) at metabase.sync.util$do_with_error_handling.invoke(util.clj:151) at clojure.core$partial$fn__5859.invoke(core.clj:2634) at metabase.driver$fn__19203.invokeStatic(driver.clj:562) at metabase.driver$fn__19203.invoke(driver.clj:562) at clojure.lang.MultiFn.invoke(MultiFn.java:239) at metabase.sync.util$sync_in_context$fn__40539.invoke(util.clj:136) at metabase.sync.util$with_db_logging_disabled$fn__40536.invoke(util.clj:127) at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100) at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94) at metabase.sync.util$with_start_and_finish_logging$fn__40525.invoke(util.clj:112) at metabase.sync.util$with_sync_events$fn__40520.invoke(util.clj:86) at metabase.sync.util$with_duplicate_ops_prevented$fn__40511.invoke(util.clj:65) at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:179) at metabase.sync.util$do_sync_operation.invoke(util.clj:176) at metabase.sync$fn__65157$sync_database_BANG___65166$fn__65172.invoke(sync.clj:44) at metabase.sync$fn__65157$sync_database_BANG___65166.invoke(sync.clj:30) at metabase.sync$fn__65157$sync_database_BANG___65166$fn__65167.invoke(sync.clj:40) at metabase.sync$fn__65157$sync_database_BANG___65166.invoke(sync.clj:30) at metabase.events.sync_database$process_sync_database_event$fn__80218.invoke(sync_database.clj:37) at clojure.core$binding_conveyor_fn$fn__5772.invoke(core.clj:2034) at clojure.lang.AFn.call(AFn.java:18) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Comparing table schema name with a column name not yet supported at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:262) at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:357) ... 116 more Caused by: java.sql.SQLException: Comparing table schema name with a column name not yet supported at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1688) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1550) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1513) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:256) ... 117 more [3e41a401-9188-44fb-b233-41e4e33e7e81] 2022-03-19T00:06:47+03:00 WARN metabase.sync.util Error syncing Fields for Table 'Table 6 'Unit'' java.sql.SQLSyntaxErrorException: (conn=3189) Comparing table schema name with a column name not yet supported at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:153) at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:274) at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:363) at org.mariadb.jdbc.MariaDbStatement.executeQuery(MariaDbStatement.java:612) at org.mariadb.jdbc.MariaDbDatabaseMetaData.executeQuery(MariaDbDatabaseMetaData.java:510) at org.mariadb.jdbc.MariaDbDatabaseMetaData.getPrimaryKeys(MariaDbDatabaseMetaData.java:611) at com.mchange.v2.c3p0.impl.NewProxyDatabaseMetaData.getPrimaryKeys(NewProxyDatabaseMetaData.java:3198) at metabase.driver.sql_jdbc.sync.describe_table$add_table_pks$fn__53592.invoke(describe_table.clj:147) at metabase.driver.sql_jdbc.sync.common$reducible_results$reify__53521.reduce(common.clj:34) at clojure.core$reduce.invokeStatic(core.clj:6829) at clojure.core$into.invokeStatic(core.clj:6897) at clojure.core$into.invoke(core.clj:6889) at metabase.driver.sql_jdbc.sync.describe_table$add_table_pks.invokeStatic(describe_table.clj:147) at metabase.driver.sql_jdbc.sync.describe_table$add_table_pks.invoke(describe_table.clj:144) at metabase.driver.sql_jdbc.sync.describe_table$describe_table_STAR_.invokeStatic(describe_table.clj:161) at metabase.driver.sql_jdbc.sync.describe_table$describe_table_STAR_.invoke(describe_table.clj:156) at metabase.driver.sql_jdbc.sync.describe_table$describe_table.invokeStatic(describe_table.clj:170) at metabase.driver.sql_jdbc.sync.describe_table$describe_table.invoke(describe_table.clj:163) at metabase.driver.sql_jdbc$fn__82005.invokeStatic(sql_jdbc.clj:66) at metabase.driver.sql_jdbc$fn__82005.invoke(sql_jdbc.clj:64) at clojure.lang.MultiFn.invoke(MultiFn.java:239) at metabase.sync.fetch_metadata$fn__62829$table_metadata__62834$fn__62835.invoke(fetch_metadata.clj:18) at metabase.sync.fetch_metadata$fn__62829$table_metadata__62834.invoke(fetch_metadata.clj:15) at metabase.sync.sync_metadata.fields.fetch_metadata$fn__63073$db_metadata__63078$fn__63079.invoke(fetch_metadata.clj:87) at metabase.sync.sync_metadata.fields.fetch_metadata$fn__63073$db_metadata__63078.invoke(fetch_metadata.clj:83) at metabase.sync.sync_metadata.fields$fn__63568$sync_fields_for_table_BANG___63577$fn__63580$fn__63581.invoke(fields.clj:72) at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158) at metabase.sync.util$do_with_error_handling.invoke(util.clj:151) at metabase.sync.sync_metadata.fields$fn__63568$sync_fields_for_table_BANG___63577$fn__63580.invoke(fields.clj:71) at metabase.sync.sync_metadata.fields$fn__63568$sync_fields_for_table_BANG___63577.invoke(fields.clj:65) at clojure.core$partial$fn__5857.invoke(core.clj:2628) at clojure.core$map$fn__5884.invoke(core.clj:2757) at clojure.lang.LazySeq.sval(LazySeq.java:42) at clojure.lang.LazySeq.seq(LazySeq.java:51) at clojure.lang.RT.seq(RT.java:535) at clojure.core$seq__5419.invokeStatic(core.clj:139) at clojure.core$filter$fn__5911.invoke(core.clj:2813) at clojure.lang.LazySeq.sval(LazySeq.java:42) at clojure.lang.LazySeq.seq(LazySeq.java:51) at clojure.lang.Cons.next(Cons.java:39) at clojure.lang.RT.boundedLength(RT.java:1793) at clojure.lang.RestFn.applyTo(RestFn.java:130) at clojure.core$apply.invokeStatic(core.clj:669) at clojure.core$apply.invoke(core.clj:662) at metabase.sync.sync_metadata.fields$fn__63606$sync_fields_BANG___63611$fn__63612.invoke(fields.clj:85) at metabase.sync.sync_metadata.fields$fn__63606$sync_fields_BANG___63611.invoke(fields.clj:77) at clojure.lang.AFn.applyToHelper(AFn.java:154) at clojure.lang.AFn.applyTo(AFn.java:144) at clojure.core$apply.invokeStatic(core.clj:669) at clojure.core$apply.invoke(core.clj:662) at metabase.sync.util$fn__40630$run_step_with_metadata__40635$fn__40639$fn__40641.doInvoke(util.clj:388) at clojure.lang.RestFn.invoke(RestFn.java:397) at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100) at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94) at metabase.sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:117) at metabase.sync.util$with_start_and_finish_debug_logging.invoke(util.clj:114) at metabase.sync.util$fn__40630$run_step_with_metadata__40635$fn__40639.invoke(util.clj:383) at metabase.sync.util$fn__40630$run_step_with_metadata__40635.invoke(util.clj:378) at metabase.sync.util$fn__40846$run_sync_operation__40851$fn__40852$fn__40860.invoke(util.clj:489) at metabase.sync.util$fn__40846$run_sync_operation__40851$fn__40852.invoke(util.clj:487) at metabase.sync.util$fn__40846$run_sync_operation__40851.invoke(util.clj:481) at metabase.sync.sync_metadata$fn__65100$sync_db_metadata_BANG___65105$fn__65106$fn__65107.invoke(sync_metadata.clj:50) at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158) at metabase.sync.util$do_with_error_handling.invoke(util.clj:151) at clojure.core$partial$fn__5859.invoke(core.clj:2634) at metabase.driver$fn__19203.invokeStatic(driver.clj:562) at metabase.driver$fn__19203.invoke(driver.clj:562) at clojure.lang.MultiFn.invoke(MultiFn.java:239) at metabase.sync.util$sync_in_context$fn__40539.invoke(util.clj:136) at metabase.sync.util$with_db_logging_disabled$fn__40536.invoke(util.clj:127) at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100) at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94) at metabase.sync.util$with_start_and_finish_logging$fn__40525.invoke(util.clj:112) at metabase.sync.util$with_sync_events$fn__40520.invoke(util.clj:86) at metabase.sync.util$with_duplicate_ops_prevented$fn__40511.invoke(util.clj:65) at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:179) at metabase.sync.util$do_sync_operation.invoke(util.clj:176) at metabase.sync.sync_metadata$fn__65100$sync_db_metadata_BANG___65105$fn__65106.invoke(sync_metadata.clj:49) at metabase.sync.sync_metadata$fn__65100$sync_db_metadata_BANG___65105.invoke(sync_metadata.clj:46) at metabase.sync$fn__65157$sync_database_BANG___65166$fn__65172$fn__65174$fn__65176.invoke(sync.clj:45) at clojure.core$mapv$fn__8468.invoke(core.clj:6914) at clojure.lang.ArrayChunk.reduce(ArrayChunk.java:58) at clojure.core.protocols$fn__8176.invokeStatic(protocols.clj:136) at clojure.core.protocols$fn__8176.invoke(protocols.clj:124) at clojure.core.protocols$fn__8136$G__8131__8145.invoke(protocols.clj:19) at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:31) at clojure.core.protocols$fn__8168.invokeStatic(protocols.clj:75) at clojure.core.protocols$fn__8168.invoke(protocols.clj:75) at clojure.core.protocols$fn__8110$G__8105__8123.invoke(protocols.clj:13) at clojure.core$reduce.invokeStatic(core.clj:6830) at clojure.core$mapv.invokeStatic(core.clj:6905) at clojure.core$mapv.invoke(core.clj:6905) at metabase.sync$fn__65157$sync_database_BANG___65166$fn__65172$fn__65174.invoke(sync.clj:45) at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158) at metabase.sync.util$do_with_error_handling.invoke(util.clj:151) at clojure.core$partial$fn__5859.invoke(core.clj:2634) at metabase.driver$fn__19203.invokeStatic(driver.clj:562) at metabase.driver$fn__19203.invoke(driver.clj:562) at clojure.lang.MultiFn.invoke(MultiFn.java:239) at metabase.sync.util$sync_in_context$fn__40539.invoke(util.clj:136) at metabase.sync.util$with_db_logging_disabled$fn__40536.invoke(util.clj:127) at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100) at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94) at metabase.sync.util$with_start_and_finish_logging$fn__40525.invoke(util.clj:112) at metabase.sync.util$with_sync_events$fn__40520.invoke(util.clj:86) at metabase.sync.util$with_duplicate_ops_prevented$fn__40511.invoke(util.clj:65) at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:179) at metabase.sync.util$do_sync_operation.invoke(util.clj:176) at metabase.sync$fn__65157$sync_database_BANG___65166$fn__65172.invoke(sync.clj:44) at metabase.sync$fn__65157$sync_database_BANG___65166.invoke(sync.clj:30) at metabase.sync$fn__65157$sync_database_BANG___65166$fn__65167.invoke(sync.clj:40) at metabase.sync$fn__65157$sync_database_BANG___65166.invoke(sync.clj:30) at metabase.events.sync_database$process_sync_database_event$fn__80218.invoke(sync_database.clj:37) at clojure.core$binding_conveyor_fn$fn__5772.invoke(core.clj:2034) at clojure.lang.AFn.call(AFn.java:18) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Comparing table schema name with a column name not yet supported at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:262) at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:357) ... 116 more Caused by: java.sql.SQLException: Comparing table schema name with a column name not yet supported at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1688) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1550) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1513) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:256) ... 117 more ``` |
|
UPDATE: After using the pscale cli, metabase is able to find my fields and I am no longer getting the errors above. So it seems like it was an SSL related issue? Not really sure. |
|
@ambiguous48 I think we messed up and your existing DB wasn't actually using the Gen4 planner until a couple of minutes ago. Should be totally unrelated to SSL or your connection method. |
Answer selected by
jgreet
|
For anyone needing a workaround in the meantime, you can reconstruct a table by doing the following:
This allows you to filter and summarize like normal, so you can construct questions with the question builder. |
0 replies
1 reply
|
Hey @paoliniluis, Drop me an email, |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I tried to hook up Metabase Cloud and I think see what's happening. When Metabase scans the table schema, it issues a query that Vitess can't currently handle: