Baoqi / metabase-dremio-driver

Dremio driver for Metabase BI
Eclipse Public License 2.0
50 stars 10 forks source link

(Upgrade 1.46 -> 1.48) - PARSE ERROR: Failure parsing the query. SQL Query SET ROLE NONE; #13

Closed leonardonhesi closed 8 months ago

leonardonhesi commented 8 months ago

I have upgraded Metabase from version 1.46.4 to the new version 1.48.7 and updated the Dremio driver "dremio.metabase-driver.jar" to its latest version 1.3.0. After the update, database access stopped working across the board, presenting the following errors:

Evd01 ( Aqui está a mensagem de erro completa PARSE ERROR: Failure parsing the query.

SQL Query SET ROLE NONE; startLine 1 startColumn 10 endLine 1 endColumn 13 SQL Query SET ROLE NONE;

[Error Id: 06b4f288-cc1e-4958-bdfe-109b56562d95 on 390836d074dc:31010]

(org.apache.calcite.sql.parser.SqlParseException) Encountered "NONE" at line 1, column 10. Was expecting one of: "=" ... "." ... "[" ...

com.dremio.exec.planner.sql.parser.impl.ParserImpl.convertException():361
com.dremio.exec.planner.sql.parser.impl.ParserImpl.normalizeException():146
org.apache.calcite.sql.parser.SqlParser.handleException():133
org.apache.calcite.sql.parser.SqlParser.parseStmtList():188
com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172
com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187
com.dremio.exec.planner.sql.SqlConverter.parse():199
com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317
com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269
com.dremio.exec.work.foreman.AttemptManager.plan():516
com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422
com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140
com.dremio.service.commandpool.CommandWrapper.run():70
com.dremio.context.RequestContext.run():96
com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212
com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192
java.util.concurrent.Executors$RunnableAdapter.call():511
java.util.concurrent.FutureTask.run():266
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():750

Caused By (com.dremio.exec.planner.sql.parser.impl.ParseException) Encountered "NONE" at line 1, column 10. Was expecting one of: "=" ... "." ... "[" ...

com.dremio.exec.planner.sql.parser.impl.ParserImpl.generateParseException():39272
com.dremio.exec.planner.sql.parser.impl.ParserImpl.jj_consume_token():39074
com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlSetOption():8464
com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmt():1026
com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmtList():900
com.dremio.exec.planner.sql.parser.impl.ParserImpl.parseSqlStmtList():197
com.dremio.exec.planner.sql.parser.impl.ParserWithCompoundIdConverter.parseSqlStmtList():73
org.apache.calcite.sql.parser.SqlParser.parseStmtList():186
com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172
com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187
com.dremio.exec.planner.sql.SqlConverter.parse():199
com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317
com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269
com.dremio.exec.work.foreman.AttemptManager.plan():516
com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422
com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140
com.dremio.service.commandpool.CommandWrapper.run():70
com.dremio.context.RequestContext.run():96
com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212
com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192
java.util.concurrent.Executors$RunnableAdapter.call():511
java.util.concurrent.FutureTask.run():266
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():750

) Evd02 (

{:via [{:type java.sql.SQLException, :message "PARSE ERROR: Failure parsing the query.\n\nSQL Query SET ROLE NONE;\nstartLine 1\nstartColumn 10\nendLine 1\nendColumn 13\nSQL Query SET ROLE NONE;\n\n[Error Id: ce594109-4177-4e22-9577-e629399b947c on 390836d074dc:31010]\n\n (org.apache.calcite.sql.parser.SqlParseException) Encountered \"NONE\" at line 1, column 10.\nWas expecting one of:\n \"=\" ...\n \".\" ...\n \"[\" ...\n \n com.dremio.exec.planner.sql.parser.impl.ParserImpl.convertException():361\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.normalizeException():146\n org.apache.calcite.sql.parser.SqlParser.handleException():133\n org.apache.calcite.sql.parser.SqlParser.parseStmtList():188\n com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172\n com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187\n com.dremio.exec.planner.sql.SqlConverter.parse():199\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269\n com.dremio.exec.work.foreman.AttemptManager.plan():516\n com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422\n com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140\n com.dremio.service.commandpool.CommandWrapper.run():70\n com.dremio.context.RequestContext.run():96\n com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212\n com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192\n java.util.concurrent.Executors$RunnableAdapter.call():511\n java.util.concurrent.FutureTask.run():266\n java.util.concurrent.ThreadPoolExecutor.runWorker():1149\n java.util.concurrent.ThreadPoolExecutor$Worker.run():624\n java.lang.Thread.run():750\n Caused By (com.dremio.exec.planner.sql.parser.impl.ParseException) Encountered \"NONE\" at line 1, column 10.\nWas expecting one of:\n \"=\" ...\n \".\" ...\n \"[\" ...\n \n com.dremio.exec.planner.sql.parser.impl.ParserImpl.generateParseException():39272\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.jj_consume_token():39074\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlSetOption():8464\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmt():1026\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmtList():900\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.parseSqlStmtList():197\n com.dremio.exec.planner.sql.parser.impl.ParserWithCompoundIdConverter.parseSqlStmtList():73\n org.apache.calcite.sql.parser.SqlParser.parseStmtList():186\n com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172\n com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187\n com.dremio.exec.planner.sql.SqlConverter.parse():199\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269\n com.dremio.exec.work.foreman.AttemptManager.plan():516\n com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422\n com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140\n com.dremio.service.commandpool.CommandWrapper.run():70\n com.dremio.context.RequestContext.run():96\n com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212\n com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192\n java.util.concurrent.Executors$RunnableAdapter.call():511\n java.util.concurrent.FutureTask.run():266\n java.util.concurrent.ThreadPoolExecutor.runWorker():1149\n java.util.concurrent.ThreadPoolExecutor$Worker.run():624\n java.lang.Thread.run():750\n", :at [com.dremio.jdbc.impl.DremioCursor nextRowInternally "DremioCursor.java" 543]} {:type cdjd.com.dremio.common.exceptions.UserRemoteException, :message "PARSE ERROR: Failure parsing the query.\n\nSQL Query SET ROLE NONE;\nstartLine 1\nstartColumn 10\nendLine 1\nendColumn 13\nSQL Query SET ROLE NONE;\n\n[Error Id: ce594109-4177-4e22-9577-e629399b947c on 390836d074dc:31010]\n\n (org.apache.calcite.sql.parser.SqlParseException) Encountered \"NONE\" at line 1, column 10.\nWas expecting one of:\n \"=\" ...\n \".\" ...\n \"[\" ...\n \n com.dremio.exec.planner.sql.parser.impl.ParserImpl.convertException():361\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.normalizeException():146\n org.apache.calcite.sql.parser.SqlParser.handleException():133\n org.apache.calcite.sql.parser.SqlParser.parseStmtList():188\n com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172\n com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187\n com.dremio.exec.planner.sql.SqlConverter.parse():199\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269\n com.dremio.exec.work.foreman.AttemptManager.plan():516\n com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422\n com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140\n com.dremio.service.commandpool.CommandWrapper.run():70\n com.dremio.context.RequestContext.run():96\n com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212\n com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192\n java.util.concurrent.Executors$RunnableAdapter.call():511\n java.util.concurrent.FutureTask.run():266\n java.util.concurrent.ThreadPoolExecutor.runWorker():1149\n java.util.concurrent.ThreadPoolExecutor$Worker.run():624\n java.lang.Thread.run():750\n Caused By (com.dremio.exec.planner.sql.parser.impl.ParseException) Encountered \"NONE\" at line 1, column 10.\nWas expecting one of:\n \"=\" ...\n \".\" ...\n \"[\" ...\n \n com.dremio.exec.planner.sql.parser.impl.ParserImpl.generateParseException():39272\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.jj_consume_token():39074\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlSetOption():8464\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmt():1026\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmtList():900\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.parseSqlStmtList():197\n com.dremio.exec.planner.sql.parser.impl.ParserWithCompoundIdConverter.parseSqlStmtList():73\n org.apache.calcite.sql.parser.SqlParser.parseStmtList():186\n com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172\n com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187\n com.dremio.exec.planner.sql.SqlConverter.parse():199\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269\n com.dremio.exec.work.foreman.AttemptManager.plan():516\n com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422\n com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140\n com.dremio.service.commandpool.CommandWrapper.run():70\n com.dremio.context.RequestContext.run():96\n com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212\n com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192\n java.util.concurrent.Executors$RunnableAdapter.call():511\n java.util.concurrent.FutureTask.run():266\n java.util.concurrent.ThreadPoolExecutor.runWorker():1149\n java.util.concurrent.ThreadPoolExecutor$Worker.run():624\n java.lang.Thread.run():750\n", :at [cdjd.com.dremio.common.exceptions.UserRemoteException create "UserRemoteException.java" 94]}], :trace [[cdjd.com.dremio.common.exceptions.UserRemoteException create "UserRemoteException.java" 94] [cdjd.com.dremio.sabot.rpc.user.QueryResultHandler resultArrived "QueryResultHandler.java" 122] [cdjd.com.dremio.sabot.rpc.user.UserClient handleReponse "UserClient.java" 175] [cdjd.com.dremio.exec.rpc.BasicClientWithConnection handle "BasicClientWithConnection.java" 56] [cdjd.com.dremio.exec.rpc.BasicClientWithConnection handle "BasicClientWithConnection.java" 33] [cdjd.com.dremio.exec.rpc.RpcBus handle "RpcBus.java" 99] [cdjd.com.dremio.exec.rpc.RpcBus handle "RpcBus.java" 94] [cdjd.com.dremio.exec.rpc.RpcBus$RequestEvent run "RpcBus.java" 475] [cdjd.com.dremio.common.SerializedExecutor$RunnableProcessor run "SerializedExecutor.java" 96] [cdjd.com.dremio.exec.rpc.RpcBus$SameExecutor execute "RpcBus.java" 341] [cdjd.com.dremio.common.SerializedExecutor execute "SerializedExecutor.java" 129] [cdjd.com.dremio.exec.rpc.RpcBus$InboundHandler decode "RpcBus.java" 375] [cdjd.com.dremio.exec.rpc.RpcBus$InboundHandler decode "RpcBus.java" 346] [cdjd.io.netty.handler.codec.MessageToMessageDecoder channelRead "MessageToMessageDecoder.java" 88] [cdjd.io.netty.channel.AbstractChannelHandlerContext invokeChannelRead "AbstractChannelHandlerContext.java" 379] [cdjd.io.netty.channel.AbstractChannelHandlerContext invokeChannelRead "AbstractChannelHandlerContext.java" 365] [cdjd.io.netty.channel.AbstractChannelHandlerContext fireChannelRead "AbstractChannelHandlerContext.java" 357] [cdjd.io.netty.handler.timeout.IdleStateHandler channelRead "IdleStateHandler.java" 286] [cdjd.io.netty.channel.AbstractChannelHandlerContext invokeChannelRead "AbstractChannelHandlerContext.java" 379] [cdjd.io.netty.channel.AbstractChannelHandlerContext invokeChannelRead "AbstractChannelHandlerContext.java" 365] [cdjd.io.netty.channel.AbstractChannelHandlerContext fireChannelRead "AbstractChannelHandlerContext.java" 357] [cdjd.io.netty.handler.codec.ByteToMessageDecoder fireChannelRead "ByteToMessageDecoder.java" 324] [cdjd.io.netty.handler.codec.ByteToMessageDecoder channelRead "ByteToMessageDecoder.java" 296] [cdjd.io.netty.channel.AbstractChannelHandlerContext invokeChannelRead "AbstractChannelHandlerContext.java" 379] [cdjd.io.netty.channel.AbstractChannelHandlerContext invokeChannelRead "AbstractChannelHandlerContext.java" 365] [cdjd.io.netty.channel.AbstractChannelHandlerContext fireChannelRead "AbstractChannelHandlerContext.java" 357] [cdjd.io.netty.channel.DefaultChannelPipeline$HeadContext channelRead "DefaultChannelPipeline.java" 1410] [cdjd.io.netty.channel.AbstractChannelHandlerContext invokeChannelRead "AbstractChannelHandlerContext.java" 379] [cdjd.io.netty.channel.AbstractChannelHandlerContext invokeChannelRead "AbstractChannelHandlerContext.java" 365] [cdjd.io.netty.channel.DefaultChannelPipeline fireChannelRead "DefaultChannelPipeline.java" 919] [cdjd.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe read "AbstractNioByteChannel.java" 166] [cdjd.io.netty.channel.nio.NioEventLoop processSelectedKey "NioEventLoop.java" 719] [cdjd.io.netty.channel.nio.NioEventLoop processSelectedKeysOptimized "NioEventLoop.java" 655] [cdjd.io.netty.channel.nio.NioEventLoop processSelectedKeys "NioEventLoop.java" 581] [cdjd.io.netty.channel.nio.NioEventLoop run "NioEventLoop.java" 493] [cdjd.io.netty.util.concurrent.SingleThreadEventExecutor$4 run "SingleThreadEventExecutor.java" 986] [cdjd.io.netty.util.internal.ThreadExecutorMap$2 run "ThreadExecutorMap.java" 74] [java.lang.Thread run nil -1]], :cause "PARSE ERROR: Failure parsing the query.\n\nSQL Query SET ROLE NONE;\nstartLine 1\nstartColumn 10\nendLine 1\nendColumn 13\nSQL Query SET ROLE NONE;\n\n[Error Id: ce594109-4177-4e22-9577-e629399b947c on 390836d074dc:31010]\n\n (org.apache.calcite.sql.parser.SqlParseException) Encountered \"NONE\" at line 1, column 10.\nWas expecting one of:\n \"=\" ...\n \".\" ...\n \"[\" ...\n \n com.dremio.exec.planner.sql.parser.impl.ParserImpl.convertException():361\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.normalizeException():146\n org.apache.calcite.sql.parser.SqlParser.handleException():133\n org.apache.calcite.sql.parser.SqlParser.parseStmtList():188\n com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172\n com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187\n com.dremio.exec.planner.sql.SqlConverter.parse():199\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269\n com.dremio.exec.work.foreman.AttemptManager.plan():516\n com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422\n com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140\n com.dremio.service.commandpool.CommandWrapper.run():70\n com.dremio.context.RequestContext.run():96\n com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212\n com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192\n java.util.concurrent.Executors$RunnableAdapter.call():511\n java.util.concurrent.FutureTask.run():266\n java.util.concurrent.ThreadPoolExecutor.runWorker():1149\n java.util.concurrent.ThreadPoolExecutor$Worker.run():624\n java.lang.Thread.run():750\n Caused By (com.dremio.exec.planner.sql.parser.impl.ParseException) Encountered \"NONE\" at line 1, column 10.\nWas expecting one of:\n \"=\" ...\n \".\" ...\n \"[\" ...\n \n com.dremio.exec.planner.sql.parser.impl.ParserImpl.generateParseException():39272\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.jj_consume_token():39074\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlSetOption():8464\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmt():1026\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmtList():900\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.parseSqlStmtList():197\n com.dremio.exec.planner.sql.parser.impl.ParserWithCompoundIdConverter.parseSqlStmtList():73\n org.apache.calcite.sql.parser.SqlParser.parseStmtList():186\n com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172\n com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187\n com.dremio.exec.planner.sql.SqlConverter.parse():199\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269\n com.dremio.exec.work.foreman.AttemptManager.plan():516\n com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422\n com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140\n com.dremio.service.commandpool.CommandWrapper.run():70\n com.dremio.context.RequestContext.run():96\n com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212\n com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192\n java.util.concurrent.Executors$RunnableAdapter.call():511\n java.util.concurrent.FutureTask.run():266\n java.util.concurrent.ThreadPoolExecutor.runWorker():1149\n java.util.concurrent.ThreadPoolExecutor$Worker.run():624\n java.lang.Thread.run():750\n", :message "PARSE ERROR: Failure parsing the query.\n\nSQL Query SET ROLE NONE;\nstartLine 1\nstartColumn 10\nendLine 1\nendColumn 13\nSQL Query SET ROLE NONE;\n\n[Error Id: ce594109-4177-4e22-9577-e629399b947c on 390836d074dc:31010]\n\n (org.apache.calcite.sql.parser.SqlParseException) Encountered \"NONE\" at line 1, column 10.\nWas expecting one of:\n \"=\" ...\n \".\" ...\n \"[\" ...\n \n com.dremio.exec.planner.sql.parser.impl.ParserImpl.convertException():361\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.normalizeException():146\n org.apache.calcite.sql.parser.SqlParser.handleException():133\n org.apache.calcite.sql.parser.SqlParser.parseStmtList():188\n com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172\n com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187\n com.dremio.exec.planner.sql.SqlConverter.parse():199\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269\n com.dremio.exec.work.foreman.AttemptManager.plan():516\n com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422\n com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140\n com.dremio.service.commandpool.CommandWrapper.run():70\n com.dremio.context.RequestContext.run():96\n com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212\n com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192\n java.util.concurrent.Executors$RunnableAdapter.call():511\n java.util.concurrent.FutureTask.run():266\n java.util.concurrent.ThreadPoolExecutor.runWorker():1149\n java.util.concurrent.ThreadPoolExecutor$Worker.run():624\n java.lang.Thread.run():750\n Caused By (com.dremio.exec.planner.sql.parser.impl.ParseException) Encountered \"NONE\" at line 1, column 10.\nWas expecting one of:\n \"=\" ...\n \".\" ...\n \"[\" ...\n \n com.dremio.exec.planner.sql.parser.impl.ParserImpl.generateParseException():39272\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.jj_consume_token():39074\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlSetOption():8464\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmt():1026\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmtList():900\n com.dremio.exec.planner.sql.parser.impl.ParserImpl.parseSqlStmtList():197\n com.dremio.exec.planner.sql.parser.impl.ParserWithCompoundIdConverter.parseSqlStmtList():73\n org.apache.calcite.sql.parser.SqlParser.parseStmtList():186\n com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172\n com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187\n com.dremio.exec.planner.sql.SqlConverter.parse():199\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317\n com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269\n com.dremio.exec.work.foreman.AttemptManager.plan():516\n com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422\n com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140\n com.dremio.service.commandpool.CommandWrapper.run():70\n com.dremio.context.RequestContext.run():96\n com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212\n com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192\n java.util.concurrent.Executors$RunnableAdapter.call():511\n java.util.concurrent.FutureTask.run():266\n java.util.concurrent.ThreadPoolExecutor.runWorker():1149\n java.util.concurrent.ThreadPoolExecutor$Worker.run():624\n java.lang.Thread.run():750\n", :sql-exception-chain ["SQLException:" "Message: PARSE ERROR: Failure parsing the query." "SQL Query SET ROLE NONE;" "startLine 1" "startColumn 10" "endLine 1" "endColumn 13" "SQL Query SET ROLE NONE;" "[Error Id: ce594109-4177-4e22-9577-e629399b947c on 390836d074dc:31010]" "(org.apache.calcite.sql.parser.SqlParseException) Encountered \"NONE\" at line 1, column 10." "Was expecting one of:" "\"=\" ..." "\".\" ..." "\"[\" ..." "com.dremio.exec.planner.sql.parser.impl.ParserImpl.convertException():361" "com.dremio.exec.planner.sql.parser.impl.ParserImpl.normalizeException():146" "org.apache.calcite.sql.parser.SqlParser.handleException():133" "org.apache.calcite.sql.parser.SqlParser.parseStmtList():188" "com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172" "com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187" "com.dremio.exec.planner.sql.SqlConverter.parse():199" "com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317" "com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269" "com.dremio.exec.work.foreman.AttemptManager.plan():516" "com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422" "com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140" "com.dremio.service.commandpool.CommandWrapper.run():70" "com.dremio.context.RequestContext.run():96" "com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212" "com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192" "java.util.concurrent.Executors$RunnableAdapter.call():511" "java.util.concurrent.FutureTask.run():266" "java.util.concurrent.ThreadPoolExecutor.runWorker():1149" "java.util.concurrent.ThreadPoolExecutor$Worker.run():624" "java.lang.Thread.run():750" "Caused By (com.dremio.exec.planner.sql.parser.impl.ParseException) Encountered \"NONE\" at line 1, column 10." "Was expecting one of:" "\"=\" ..." "\".\" ..." "\"[\" ..." "com.dremio.exec.planner.sql.parser.impl.ParserImpl.generateParseException():39272" "com.dremio.exec.planner.sql.parser.impl.ParserImpl.jj_consume_token():39074" "com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlSetOption():8464" "com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmt():1026" "com.dremio.exec.planner.sql.parser.impl.ParserImpl.SqlStmtList():900" "com.dremio.exec.planner.sql.parser.impl.ParserImpl.parseSqlStmtList():197" "com.dremio.exec.planner.sql.parser.impl.ParserWithCompoundIdConverter.parseSqlStmtList():73" "org.apache.calcite.sql.parser.SqlParser.parseStmtList():186" "com.dremio.exec.planner.sql.SqlConverter.parseMultipleStatementsImpl():172" "com.dremio.exec.planner.sql.SqlConverter.parseSingleStatementImpl():187" "com.dremio.exec.planner.sql.SqlConverter.parse():199" "com.dremio.exec.planner.sql.handlers.commands.CommandCreator.getSqlCommand():317" "com.dremio.exec.planner.sql.handlers.commands.CommandCreator.toCommand():269" "com.dremio.exec.work.foreman.AttemptManager.plan():516" "com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():422" "com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():140" "com.dremio.service.commandpool.CommandWrapper.run():70" "com.dremio.context.RequestContext.run():96" "com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4():212" "com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():192" "java.util.concurrent.Executors$RunnableAdapter.call():511" "java.util.concurrent.FutureTask.run():266" "java.util.concurrent.ThreadPoolExecutor.runWorker():1149" "java.util.concurrent.ThreadPoolExecutor$Worker.run():624" "java.lang.Thread.run():750" "SQLState: null" "Error Code: 0"]}

)

Could you help me?

RonildoSouza commented 8 months ago

Hi @leonardonhesi make a test with this .jar

https://github.com/RonildoSouza/metabase-dremio-driver/releases/download/1.3.1-alpha.1/dremio.metabase-driver.jar

leonardonhesi commented 8 months ago

Just by using this new version, the error I reported no longer appears, and all tables and charts are being generated as expected. Man, I really appreciate your quick response.

Baoqi commented 8 months ago

Merged, and released 1.3.1, Thanks.