Can't get metadata from Amazon Redshift (Postgres) using Teiid 8.7
ichanjasper May 29, 2014 1:02 PMHi all,
I have a few questions about Amazon Redshift. Do you guys support Amazon Redshift? Amazon Redshift is based on PostgreSQL 8.0.2. Therefore, I tried to use PostgreSQLExecutionFactory for Redshift with Teiid 8.7, but I got the following exception.
aused by: org.teiid.core.TeiidComponentException: TEIID30489 Unable to load metadata for VDB -686816004 1.
at org.teiid.dqp.internal.process.Request.initMetadata(Request.java:191)
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:433)
at org.teiid.dqp.internal.process.PreparedStatementRequest.processRequest(PreparedStatementRequest.java:289)
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:609)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:315)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254)
at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:295)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:170)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:258)
at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:168)
at $Proxy160.executeRequest(Unknown Source)
at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634)
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509)
Do you guys have any clue?
Thanks,
Ivan