[JBoss JIRA] (TEIID-4452) Pushdown SQL/XML
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4452?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4452:
---------------------------------------
TEIID-4459 will be looked at for 9.1 as well to provide a better solution at a baseline for using scalar subqueries in the select clause.
> Pushdown SQL/XML
> ----------------
>
> Key: TEIID-4452
> URL: https://issues.jboss.org/browse/TEIID-4452
> Project: Teiid
> Issue Type: Enhancement
> Components: JDBC Connector
> Affects Versions: 9.x
> Reporter: Tom Arnold
> Assignee: Steven Hawkins
>
> It would be helpful to pushdown SQL/XML functions for JDBC databases that support them.
> Databases:
> - Oracle
> - Postgres
> Functions:
> - XMLELEMENT
> - XMLATTRIBUTES
> - XMLAGG
> - XMLCONCAT
> We have an application that uses these functions and we support Oracle, Postgres, and Teiid (to integrate external data sources). Here's an example query generated by this application:
> {code:xml}
> select
> "ITEMS"."ITEM_ID" "ITEM_ID",
> (
> select xmlelement (
> name "attributes",
> xmlagg(
> xmlelement(
> name "attribute",
> xmlattributes(
> "ITEM_ATTRIBUTES"."ATTR_NAME" as "name",
> "ITEM_ATTRIBUTES"."ATTR_VALUE" as "value"
> )
> )
> )
> )
> from "ITEM_ATTRIBUTES" "ITEM_ATTRIBUTES"
> where (
> "ITEMS"."ITEM_ID" = "ITEM_ATTRIBUTES"."ITEM_ID"
> )
> ) "ITEM_ATTRIBUTES"
> {code}
> {code}
> ITEM_ID ITEM_ATTRIBUTES
> 3 <attributes><attribute name="foo" value="bar"></attribute><attribute name="baz" value="blah"></attribute></attributes>
> 4 <attributes><attribute name="foo" value="123"></attribute><attribute name="baz" value="456"></attribute></attributes>
> {code}
> When we are using Teiid queries like this do not work well because they cannot be pushed down, so we get N-many queries (one per row) and the query ends up taking much longer than if performed directly against Oracle/Postgres.
> Since SQL/XML is standard and supported by both Oracle/Postgres it would be good if queries like this could be pushed in their entirety so that there would be no performance difference between going through Teiid and native.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 6 months
[JBoss JIRA] (TEIID-4459) Convert project semi-joins to (dependent) join queries
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-4459:
-------------------------------------
Summary: Convert project semi-joins to (dependent) join queries
Key: TEIID-4459
URL: https://issues.jboss.org/browse/TEIID-4459
Project: Teiid
Issue Type: Quality Risk
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 9.1
In many situations subqueries in the where clause can be planned as semi-joins. The same logic should be updated to handle the select clause.
This will also help ensure better performance with odata generated array_agg queries.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 6 months
[JBoss JIRA] (TEIID-4234) Gradle blueprint
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-4234?page=com.atlassian.jira.plugin... ]
Ramesh Reddy edited comment on TEIID-4234 at 9/21/16 4:00 PM:
--------------------------------------------------------------
[~jayunit100] Per TEIID-4094 the JDBC driver can be accessed using maven config as
{code}
<dependency>
<groupId>org.jboss.teiid</groupId>
<artifactId>teiid</artifactId>
<version>9.0</version>
<classifier>jdbc</classifier>
</dependency>
{code}
would that suffice this requirement? This documented at https://teiid.gitbooks.io/documents/content/client-dev/Connecting_to_a_Te...
was (Author: rareddy):
[~jayunit100] Per TEIID-4094 the JDBC driver can be accessed using maven config as
{code}
<dependency>
<groupId>org.jboss.teiid</groupId>
<artifactId>teiid</artifactId>
<version>9.0</version>
<classifier>jdbc</classifier>
</dependency>
{code}
would that suffice this requirement? I will see if I can update the Teiid documents.
> Gradle blueprint
> ----------------
>
> Key: TEIID-4234
> URL: https://issues.jboss.org/browse/TEIID-4234
> Project: Teiid
> Issue Type: Feature Request
> Components: Tools
> Reporter: jay vyas
> Fix For: 9.1
>
> Attachments: build.gradle
>
>
> As a app developer, I'd like to spin up a teiid/JDV application with all client-side dependencies
> without needing to use an IDE.
> Currently, most of the TEiid resources and videos are based on IDE features, bootstrapping teiid on the local machine.
> Ideally, we might host a simple Teiid server that can run in a dockerfile with sample data, along side a gradle runnable file.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 6 months
[JBoss JIRA] (TEIID-4094) Move the packaging of teiid-jdbc.jar into is own project
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4094?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4094.
-----------------------------------
Resolution: Done
>From a project perspective I'm fine with closing it. From what I saw before it looked like it may need to be backed out of 8.12.5, but if their builds are working fine, then we can leave it alone.
> Move the packaging of teiid-jdbc.jar into is own project
> --------------------------------------------------------
>
> Key: TEIID-4094
> URL: https://issues.jboss.org/browse/TEIID-4094
> Project: Teiid
> Issue Type: Enhancement
> Components: Build/Kits
> Affects Versions: 8.12.x
> Reporter: Van Halbert
> Assignee: Van Halbert
> Fix For: 8.12.5
>
>
> The issue with the way the teiid-jdbc.jar is packaged now, is that the teiid-web-console.zip gets included as a dependency.
> {code}
> [INFO] +- org.jboss.teiid:teiid:jar:jdbc:8.12.5.redhat-2:compile
> [INFO] | \- org.jboss.teiid.web-console:teiid-console-dist:zip:jboss-as7:2.5.6.Final-redhat-63-4:compile
> {code}
> And that becomes an issue when other external projects to Teiid include the jdbc driver as a dependency, in that they also end up requiring the web-console.zip.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 6 months
[JBoss JIRA] (TEIID-4094) Move the packaging of teiid-jdbc.jar into is own project
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-4094?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-4094:
-------------------------------------
[~shawkins] Can this be closed? Looks like there is no product based issues this is still representing?
> Move the packaging of teiid-jdbc.jar into is own project
> --------------------------------------------------------
>
> Key: TEIID-4094
> URL: https://issues.jboss.org/browse/TEIID-4094
> Project: Teiid
> Issue Type: Enhancement
> Components: Build/Kits
> Affects Versions: 8.12.x
> Reporter: Van Halbert
> Assignee: Van Halbert
> Fix For: 8.12.5
>
>
> The issue with the way the teiid-jdbc.jar is packaged now, is that the teiid-web-console.zip gets included as a dependency.
> {code}
> [INFO] +- org.jboss.teiid:teiid:jar:jdbc:8.12.5.redhat-2:compile
> [INFO] | \- org.jboss.teiid.web-console:teiid-console-dist:zip:jboss-as7:2.5.6.Final-redhat-63-4:compile
> {code}
> And that becomes an issue when other external projects to Teiid include the jdbc driver as a dependency, in that they also end up requiring the web-console.zip.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 6 months
[JBoss JIRA] (TEIID-4234) Gradle blueprint
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-4234?page=com.atlassian.jira.plugin... ]
Ramesh Reddy edited comment on TEIID-4234 at 9/21/16 3:26 PM:
--------------------------------------------------------------
[~jayunit100] Per TEIID-4094 the JDBC driver can be accessed using maven config as
{code}
<dependency>
<groupId>org.jboss.teiid</groupId>
<artifactId>teiid</artifactId>
<version>9.0</version>
<classifier>jdbc</classifier>
</dependency>
{code}
would that suffice this requirement? I will see if I can update the Teiid documents.
was (Author: rareddy):
[~jayunit100] Per TEIID-4094 the JDBC driver can be accessed using maven config as
{code}
<dependency>
<groupId>org.jboss.teiid</groupId>
<artifactId>teiid</artifactId>
<version>9.0</version>
<classifier>jdbc</classifier>
</dependency>
{code}
would that suffice this requirement?
> Gradle blueprint
> ----------------
>
> Key: TEIID-4234
> URL: https://issues.jboss.org/browse/TEIID-4234
> Project: Teiid
> Issue Type: Feature Request
> Components: Tools
> Reporter: jay vyas
> Fix For: 9.1
>
> Attachments: build.gradle
>
>
> As a app developer, I'd like to spin up a teiid/JDV application with all client-side dependencies
> without needing to use an IDE.
> Currently, most of the TEiid resources and videos are based on IDE features, bootstrapping teiid on the local machine.
> Ideally, we might host a simple Teiid server that can run in a dockerfile with sample data, along side a gradle runnable file.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 6 months
[JBoss JIRA] (TEIID-4234) Gradle blueprint
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-4234?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-4234:
-------------------------------------
[~jayunit100] Per TEIID-4094 the JDBC driver can be accessed using maven config as
{code}
<dependency>
<groupId>org.jboss.teiid</groupId>
<artifactId>teiid</artifactId>
<version>9.0</version>
<classifier>jdbc</classifier>
</dependency>
{code}
would that suffice this requirement?
> Gradle blueprint
> ----------------
>
> Key: TEIID-4234
> URL: https://issues.jboss.org/browse/TEIID-4234
> Project: Teiid
> Issue Type: Feature Request
> Components: Tools
> Reporter: jay vyas
> Fix For: 9.1
>
> Attachments: build.gradle
>
>
> As a app developer, I'd like to spin up a teiid/JDV application with all client-side dependencies
> without needing to use an IDE.
> Currently, most of the TEiid resources and videos are based on IDE features, bootstrapping teiid on the local machine.
> Ideally, we might host a simple Teiid server that can run in a dockerfile with sample data, along side a gradle runnable file.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 6 months