Issue with Querying Tables from MySQL Database on ARM64 Architecture with RMv8 CPU

Hi Experts,

On arm 64 architeture and processor model name of RMv8 CPU, I built Release 24.0.0. It could successfully establish a single mysql data source connection , however failed on query a tables from mysql db.
Could you please help point out the problems? Thanks a lot!

2023-06-15 06:37:23,787 [qtp2032266039-174] DEBUG c.d.e.s.jdbc.JdbcSchemaFetcherImpl - Getting row count for table mysql.db.
2023-06-15 06:37:23,798 [qtp2032266039-174] DEBUG c.d.e.s.jdbc.JdbcSchemaFetcherImpl - Query select count(*) from mysql.db`` returned 2 rows.
2023-06-15 06:37:23,798 [qtp2032266039-174] DEBUG c.d.e.store.jdbc.JdbcDatasetMetadata - Took 21 ms to get row count for [mysql, db]
2023-06-15 06:37:27,236 [1b754e5a-e5f8-8ea1-55a3-a0a81b69b900/0:foreman-planning] ERROR com.dremio.joust.Loader - Failure while loading joust native library.
java.io.IOException: Couldn’t load library library joust
at org.scijava.nativelib.NativeLoader.loadLibrary(NativeLoader.java:141)
at com.dremio.joust.Loader.(Loader.java:38)
at com.dremio.joust.geo.S2Geo.(S2Geo.java:22)
at com.dremio.joust.geo.DistanceRulesFactory.getRules(DistanceRulesFactory.java:41)
at com.dremio.exec.ops.QueryContext.lambda$getInjectedRules$1(QueryContext.java:306)
at java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:269)
at java.util.Collections$2.tryAdvance(Collections.java:4719)
at java.util.Collections$2.forEachRemaining(Collections.java:4727)
at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:482)
at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:472)
at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)
at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:566)
at com.dremio.exec.ops.QueryContext.getInjectedRules(QueryContext.java:307)
at com.dremio.exec.planner.sql.handlers.SqlHandlerConfig.getRules(SqlHandlerConfig.java:62)
at com.dremio.exec.planner.sql.handlers.PrelTransformer.transform(PrelTransformer.java:494)
at com.dremio.exec.planner.sql.handlers.PrelTransformer.toConvertibleRelRoot(PrelTransformer.java:1010)
at com.dremio.exec.planner.sql.handlers.PrelTransformer.convertToRelRoot(PrelTransformer.java:1021)
at com.dremio.exec.planner.sql.handlers.PrelTransformer.convertToRel(PrelTransformer.java:1041)
at com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert(PrelTransformer.java:193)
at com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert(PrelTransformer.java:179)
at com.dremio.exec.planner.sql.handlers.query.NormalHandler.getPlan(NormalHandler.java:68)
at com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan(HandlerToExec.java:59)
at com.dremio.exec.work.foreman.AttemptManager.plan(AttemptManager.java:524)
at com.dremio.exec.work.foreman.AttemptManager.lambda$run$4(AttemptManager.java:422)
at com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3(ReleasableBoundCommandPool.java:140)
at com.dremio.service.commandpool.CommandWrapper.run(CommandWrapper.java:70)
at com.dremio.context.RequestContext.run(RequestContext.java:96)
at com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$4(ContextMigratingExecutorService.java:212)
at com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run(ContextMigratingExecutorService.java:192)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.UnsatisfiedLinkError: no joust in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1860)
at java.lang.Runtime.loadLibrary0(Runtime.java:871)
at java.lang.System.loadLibrary(System.java:1124)
at org.scijava.nativelib.NativeLoader.loadLibrary(NativeLoader.java:136)
… 34 common frames omitted

@david_xu Let me check on this and get back to you

Balaji Ramswamy via Dremio <notifications@dremio.discoursemail.com>于2023年7月22日 周六01:18写道:

| balaji.ramaswamy
July 22 |

  • | - |

@david_xu Let me check on this and get back to you


访问话题或者回复此电子邮件以进行回复。

要退订这些电子邮件,请点击此处

Thank you so much!

@david_xu Engg did come back with the below response

“certain non free artifacts in the community edition are not yet supported on arm, however they are planned to be supported in the future.”