Planning Failed Error

2024-08-01 16:31:50,383 [19544788-ea36-1770-2ccc-2e355d641b00/0:foreman-planning] ERROR c.d.s.commandpool.CommandWrapper - command 19544788-ea36-1770-2ccc-2e355d641b00/0:foreman-planning failed
java.lang.AssertionError: Conversion to relational algebra failed to preserve datatypes:

at org.apache.calcite.sql2rel.SqlToRelConverter.checkConvertedType(SqlToRelConverter.java:480)
	at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:597)
	at org.apache.calcite.sql2rel.SqlToRelConverter.convertWith(SqlToRelConverter.java:4473)
	at org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:3443)
	at com.dremio.exec.planner.sql.DremioSqlToRelConverter.convertQueryRecursive(DremioSqlToRelConverter.java:223)
	at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:585)
	at com.dremio.exec.planner.sql.SqlValidatorAndToRelContext.toConvertibleRelRoot(SqlValidatorAndToRelContext.java:131)
	at com.dremio.exec.planner.sql.SqlValidatorAndToRelContext.toConvertibleRelRoot(SqlValidatorAndToRelContext.java:112)
	at com.dremio.exec.planner.sql.handlers.PrelTransformer.toConvertibleRelRoot(PrelTransformer.java:1062)
	at com.dremio.exec.planner.sql.handlers.PrelTransformer.convertToRelRoot(PrelTransformer.java:1084)
	at com.dremio.exec.planner.sql.handlers.PrelTransformer.convertToRel(PrelTransformer.java:1104)
	at com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert(PrelTransformer.java:219)
	at com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert(PrelTransformer.java:205)
	at com.dremio.exec.planner.sql.handlers.query.DataAdditionCmdHandler.getPlan(DataAdditionCmdHandler.java:157)
	at com.dremio.exec.planner.sql.handlers.query.CreateTableHandler.doCtas(CreateTableHandler.java:102)
	at com.dremio.exec.planner.sql.handlers.query.CreateTableHandler.getPlan(CreateTableHandler.java:70)
	at com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan(HandlerToExec.java:59)
	at com.dremio.exec.work.foreman.AttemptManager.plan(AttemptManager.java:565)
	at com.dremio.exec.work.foreman.AttemptManager.lambda$run$4(AttemptManager.java:462)
	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:226)
	at com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run(ContextMigratingExecutorService.java:206)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)

Hi mlafleur,

Are you able to download and provide the query profile for the below job id so we can take a further look?

Job Id: 19544788-ea36-1770-2ccc-2e355d641b00

Thanks.

278cf9e7-0a52-449f-98e4-f369ba7b12f6.zip (60.4 KB)

Thanks mlafleur.

Checking further, this looks to be a known issue and will be fixed in the future versions of Dremio.

Thank you for looking into this!