Discussion:
Error: SYSTEM ERROR: IllegalArgumentException: Multiple entries with same key
Add Reply
Raj Raj
2017-07-31 00:40:57 UTC
Reply
Permalink
Raw Message
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

Loading...