Error: SYSTEM ERROR: IllegalArgumentException: Multiple entries with same key

[Raj Raj]

Hi

This is my first request; apologize if it's not properly framed.

I have setup a "RedShift" storage plugin and able to query as
*redshift.`dbname`.`schemaname`.`tablename`*   , but, when I try to do
"Show tables" I receive an error as follows. Generally,  executing the
query is not predictable.

Also, I see two database when I do "Show Databases" as "redshift" and
"redshift.databasename", where "redshift" is the storage plugin name.

Please let me know if I have to change my storage plugin or any other
settings. Appreciated,
My storage plugin entry.
{
  "type": "jdbc",
  "driver": "org.postgresql.Driver",
  "url": "jdbc:redshift://<servername>:5439/<dbname>",
  "username": "<username>",
  "password": "<password>",
  "enabled": true
}


*THE PROBLEM*

0: jdbc:drill:zk=local> show tables;

*Error: SYSTEM ERROR: IllegalArgumentException: Multiple entries with same
key: *dim_brand_parent_pkey=JdbcTable {dim_brand_parent_pkey} and
dim_brand_parent_pkey=JdbcTable {dim_brand_parent_pkey}


Fragment 0:0


[Error Id: 0653cbf6-0f0a-4338-a593-ffc03f339f97 on localhost:31010]


  (java.lang.IllegalArgumentException) Multiple entries with same key:
dim_brand_parent_pkey=JdbcTable {dim_brand_parent_pkey} and
dim_brand_parent_pkey=JdbcTable {dim_brand_parent_pkey}

    com.google.common.collect.ImmutableMap.checkNoConflict():150


com.google.common.collect.RegularImmutableMap.checkNoConflictInBucket():104

    com.google.common.collect.RegularImmutableMap.<init>():70

    com.google.common.collect.ImmutableMap$Builder.build():254

    org.apache.calcite.adapter.jdbc.JdbcSchema.computeTables():218

    org.apache.calcite.adapter.jdbc.JdbcSchema.getTableMap():234

    org.apache.calcite.adapter.jdbc.JdbcSchema.getTableNames():359


org.apache.drill.exec.store.jdbc.JdbcStoragePlugin$CapitalizingJdbcSchema.getTableNames():282

    org.apache.drill.exec.store.AbstractSchema.getTableNamesAndTypes():251


org.apache.drill.exec.store.ischema.InfoSchemaRecordGenerator$Tables.visitTables():299


org.apache.drill.exec.store.ischema.InfoSchemaRecordGenerator.scanSchema():215


org.apache.drill.exec.store.ischema.InfoSchemaRecordGenerator.scanSchema():208


org.apache.drill.exec.store.ischema.InfoSchemaRecordGenerator.scanSchema():208


org.apache.drill.exec.store.ischema.InfoSchemaRecordGenerator.scanSchema():195


org.apache.drill.exec.store.ischema.InfoSchemaTableType.getRecordReader():58

    org.apache.drill.exec.store.ischema.InfoSchemaBatchCreator.getBatch():36

    org.apache.drill.exec.store.ischema.InfoSchemaBatchCreator.getBatch():30

    org.apache.drill.exec.physical.impl.ImplCreator.getRecordBatch():148

    org.apache.drill.exec.physical.impl.ImplCreator.getChildren():171

    org.apache.drill.exec.physical.impl.ImplCreator.getRecordBatch():128

    org.apache.drill.exec.physical.impl.ImplCreator.getChildren():171

    org.apache.drill.exec.physical.impl.ImplCreator.getRootExec():101

    org.apache.drill.exec.physical.impl.ImplCreator.getExec():79

    org.apache.drill.exec.work.fragment.FragmentExecutor.run():206

    org.apache.drill.common.SelfCleaningRunnable.run():38

    java.util.concurrent.ThreadPoolExecutor.runWorker():1142

    java.util.concurrent.ThreadPoolExecutor$Worker.run():617

    java.lang.Thread.run():745 (state=,code=0)

Thanks
Raj