Hi guys! So Have you ever tried Presto DB? It is awesome.
I used it to integrate Hive, ElasticSearch and Oracle. It is very fast, I mean not real time, but fast.
When I tried to use it to integrate with Oracle I got a surprise. There is no Oracle plugin.
Then I scream and cry and create my own Presto Oracle Plugin. XD
If you have the same issue, please take a look. Just click in the link below:
Presto Oracle Connector
Regards.
This comment has been removed by the author.
ReplyDeleteHi, I tried to use the oracle plugin and getting the below error.
ReplyDelete2016-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.(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)
Any help?