Error when trying to create reflection for MySQL

1

Hi,

I’m trying to create a reflection for a MySQL data source and I get the error below. Any suggestions why it doesn’t work?

        PLAN ERROR: index (8) must be less than size (8)

Sql Query CREATE TABLE “__accelerator”.“56a59b22-5eb5-4086-9e5d-2f473f06182a/67b50d27-0617-4731-bd4b-1d3ddb6e4913/1500547791032” AS SELECT * FROM “__materialization”.“56a59b22-5eb5-4086-9e5d-2f473f06182a”

(java.lang.IndexOutOfBoundsException) index (8) must be less than size (8)
com.google.common.base.Preconditions.checkElementIndex():310
com.google.common.base.Preconditions.checkElementIndex():292
com.google.common.collect.RegularImmutableList.get():65
org.apache.calcite.tools.RelBuilder.project():895
org.apache.calcite.plan.RelOptUtil.createProject():2858
org.apache.calcite.plan.RelOptUtil.createProject():2775
org.apache.calcite.sql2rel.RelStructuredTypeFlattener.rewriteRel():475
sun.reflect.GeneratedMethodAccessor339.invoke():-1
sun.reflect.DelegatingMethodAccessorImpl.invoke():43
java.lang.reflect.Method.invoke():498
org.apache.calcite.util.ReflectUtil.invokeVisitorInternal():257
org.apache.calcite.util.ReflectUtil.invokeVisitor():214
org.apache.calcite.util.ReflectUtil$1.invokeVisitor():471
org.apache.calcite.sql2rel.RelStructuredTypeFlattener$RewriteRelVisitor.visit():715
org.apache.calcite.sql2rel.RelStructuredTypeFlattener.rewrite():176
org.apache.calcite.sql2rel.SqlToRelConverter.flattenTypes():463
com.dremio.exec.planner.sql.SqlConverter.toConvertibleRelRoot():273
com.dremio.exec.planner.sql.handlers.PrelTransformer.toConvertibleRelRoot():636
com.dremio.exec.planner.sql.handlers.PrelTransformer.convertToRelRootAndJdbc():653
com.dremio.exec.planner.sql.handlers.PrelTransformer.convertToRel():712
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():157
com.dremio.exec.planner.sql.handlers.query.CreateTableHandler.getPlan():70
com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan():66
com.dremio.exec.work.foreman.AttemptManager.run():285
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():748

2

I believe, this error is specific to the dataset that you are trying.

To reproduce this error on my end, could you please share with me the following information:

  1. Mysql - Table Schema
  2. dataset definition (if any , created on top of the mysql table)
  3. Reflection Type/settings
  4. The output of the following queries:
    select * from sys.layouts
    select * from sys.materializations
    select * from sys.accelerations