[JBoss JIRA] Created: (TEIID-587) Better pushdown support for exotic joins
by Steven Hawkins (JIRA)
Better pushdown support for exotic joins
----------------------------------------
Key: TEIID-587
URL: https://jira.jboss.org/jira/browse/TEIID-587
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 6.1.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 6.2.0
Our optimizations get in the way of Salesforce pushdown. Specifically rewriting like when possible to = and converting outer joins to inner joins. In both cases we would need to not perform the optimization in the first place or convert into an acceptable form prior to pushdown.
The next is that salesforce, while requiring key criteria also allows other criteria in the left outer join on clause (which would be the same as having criteria on the nested relationship query in the salesforce query). With the capabilities as currently defined this would cause the query to not be pushed down. We should consider adding a relational supported join criteria type that requires key criteria but allows for outside criteria. Also we should treat the lack of inner join support to mean that criteria on the inner side of an outer join cannot be pushed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 11 months
[JBoss JIRA] Created: (TEIID-1214) The translators displayed in the JOPR console need a full description, not just Teiid Translator, because a 2 char. name (i.e., ws) with no description isn't clear
by Van Halbert (JIRA)
The translators displayed in the JOPR console need a full description, not just Teiid Translator, because a 2 char. name (i.e., ws) with no description isn't clear
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: TEIID-1214
URL: https://jira.jboss.org/browse/TEIID-1214
Project: Teiid
Issue Type: Bug
Components: Jopr Plugin
Reporter: Van Halbert
Assignee: Steve Hawkins
Priority: Minor
The translators displayed in the JOPR console need a clear description, not just Teiid Translator, because a 2 char. name (i.e., ws) with essentially no description isn't clear.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 11 months
[JBoss JIRA] Created: (TEIID-1270) adminshell - getAdmin() returns: ERROR org.teiid.core.TeiidRuntimeException: toString
by Van Halbert (JIRA)
adminshell - getAdmin() returns: ERROR org.teiid.core.TeiidRuntimeException: toString
-------------------------------------------------------------------------------------
Key: TEIID-1270
URL: https://jira.jboss.org/browse/TEIID-1270
Project: Teiid
Issue Type: Bug
Components: AdminApi, Tools
Reporter: Van Halbert
Assignee: Steven Hawkins
Fix For: 7.1.1
sh ./adminshell.sh
======================================================================
Teiid AdminShell Bootstrap Environment
TEIID_HOME = /jboss/local/51_ER1/jboss-soa-p.5/teiid/adminshell
CLASSPATH = /jboss/local/51_ER1/jboss-soa-p.5/teiid/adminshell/lib/patches/*:/jboss/local/51_ER1/jboss-soa-p.5/teiid/adminshell/lib/teiid-adminshell-7.1.1.Alpha1.jar:/jboss/local/51_ER1/jboss-soa-p.5/teiid/adminshell/lib/*
JAVA = /usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0//bin/java
======================================================================
===> [import static org.teiid.adminshell.AdminShell.*; import static org.teiid.adminshell.GroovySqlExtensions.*; import org.teiid.adminapi.*;]
Groovy Shell (1.7.2, JVM: 1.6.0_0)
Type 'help' or '\h' for help.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
groovy:000> connectAsAdmin("mm://localhost:31443", "admin", "admin", "conn-1")
===> null
groovy:000> getAllConnections()
===> [conn-1]
groovy:000> getAdmin()
ERROR org.teiid.core.TeiidRuntimeException:
toString
at org.teiid.client.util.ExceptionUtil.convertException (ExceptionUtil.java:80)
at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke (SocketServerInstanceImpl.java:365)
at org.teiid.net.socket.SocketServerConnection$1.invoke (SocketServerConnection.java:216)
at $Proxy7.toString (Unknown Source)
at org.teiid.adminapi.AdminFactory$AdminProxy.invoke (AdminFactory.java:80)
at $Proxy7.toString (Unknown Source)
at java_lang_String$valueOf.call (Unknown Source)
at java_lang_String$valueOf.call (Unknown Source)
at java_lang_Runnable$run.call (Unknown Source)
at org.teiid.adminshell.GroovyAdminShell.main (GroovyAdminShell.java:30)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 11 months