Oracle Plugin Error

[Baskar Sikkayan]

Hi,

  I use presto oracle connector and getting the following error when i run a simple query.

2016-01-20T15:48:44.210-0800 ERROR Query-20160120_234810_00002_mpatk-121 com.facebook.presto.execution.QueryStateMachine Query 20160120_234810_00002_mpatk failed

java.lang.IllegalArgumentException: Multiple entries with same key: addr_type_cd=JdbcColumnHandle{connectorId=oracle, columnName=ADDR_TYPE_CD, columnType=varchar} and addr_type_cd=JdbcColumnHandle{connectorId=oracle, columnName=ADDR_TYPE_CD, columnType=varchar}

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

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

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

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

at com.facebook.presto.plugin.jdbc.JdbcMetadata.getColumnHandles(JdbcMetadata.java:115)

at com.facebook.presto.transaction.LegacyConnectorMetadata.getColumnHandles(LegacyConnectorMetadata.java:111)

at com.facebook.presto.metadata.MetadataManager.getColumnHandles(MetadataManager.java:386)

at com.facebook.presto.sql.analyzer.StatementAnalyzer.visitTable(StatementAnalyzer.java:835)

at com.facebook.presto.sql.analyzer.StatementAnalyzer.visitTable(StatementAnalyzer.java:209)

at com.facebook.presto.sql.tree.Table.accept(Table.java:50)

at com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:22)

at com.facebook.presto.sql.analyzer.StatementAnalyzer.analyzeFrom(StatementAnalyzer.java:1607)

at com.facebook.presto.sql.analyzer.StatementAnalyzer.visitQuerySpecification(StatementAnalyzer.java:935)

at com.facebook.presto.sql.analyzer.StatementAnalyzer.visitQuerySpecification(StatementAnalyzer.java:209)

at com.facebook.presto.sql.tree.QuerySpecification.accept(QuerySpecification.java:125)

at com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:22)

at com.facebook.presto.sql.analyzer.StatementAnalyzer.visitQuery(StatementAnalyzer.java:735)

at com.facebook.presto.sql.analyzer.StatementAnalyzer.visitQuery(StatementAnalyzer.java:209)

at com.facebook.presto.sql.tree.Query.accept(Query.java:103)

at com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:22)

at com.facebook.presto.sql.analyzer.Analyzer.analyze(Analyzer.java:60)

at com.facebook.presto.execution.SqlQueryExecution.doAnalyzeQuery(SqlQueryExecution.java:254)

at com.facebook.presto.execution.SqlQueryExecution.analyzeQuery(SqlQueryExecution.java:240)

at com.facebook.presto.execution.SqlQueryExecution.start(SqlQueryExecution.java:204)

at com.facebook.presto.execution.QueuedExecution.lambda$start$335(QueuedExecution.java:68)

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

Query 20160120_234810_00002_mpatk failed: Multiple entries with same key: addr_type_cd=JdbcColumnHandle{connectorId=oracle, columnName=ADDR_TYPE_CD, columnType=varchar} and addr_type_cd=JdbcColumnHandle{connectorId=oracle, columnName=ADDR_TYPE_CD, columnType=varchar}

Is there any configuration I am missing?

Thanks,

Baskar.S