November 2010 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-784) Enhance distinct set op processing

by Steven Hawkins (JIRA)

Enhance distinct set op processing ---------------------------------- Key: TEIID-784 URL: https://jira.jboss.org/jira/browse/TEIID-784 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.3.0 The sort operation should be able to pushed for each set op child (distinct is already eligible for pushing, but typically won't be because there's no order by). Also for union the sorted children should be fed directly into the second phase of sorting. All of this relies on the connector guaranteeing null ordering (TEIID-715 should be repurposed to cover the language enhancement of nulls first|last) -- 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

15 years, 2 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1035) Replace Existing XML Document Functionality with other JBoss Technologies

by Ted Jones (JIRA)

Replace Existing XML Document Functionality with other JBoss Technologies ------------------------------------------------------------------------- Key: TEIID-1035 URL: https://jira.jboss.org/jira/browse/TEIID-1035 Project: Teiid Issue Type: Task Affects Versions: 7.0 Reporter: Ted Jones Assignee: Steven Hawkins Fix For: 8.0 The current XML Document homegrown technologies in the Teiid Designer with existing JBoss technologies. The following use cases should be satisfied: 1. Start with an XML Schema to build a Document that can be filled with relational, heterogeneous data and "shipped around" 2. Given an XML document/message definition, submit a query on the document with criteria defined within the document structure 3. Send an input document, produce and output document -- 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

15 years, 2 months

2
1
0 / 0

[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

15 years, 2 months

1
4
0 / 0

[JBoss JIRA] Created: (TEIID-1350) Teiid 7.2 in JBoss EAP cluster (with clustered cache on) will not deploy VDBs

by Graeme Gillies (JIRA)

Teiid 7.2 in JBoss EAP cluster (with clustered cache on) will not deploy VDBs ----------------------------------------------------------------------------- Key: TEIID-1350 URL: https://jira.jboss.org/browse/TEIID-1350 Project: Teiid Issue Type: Bug Affects Versions: 7.2 Environment: RHEL 5.5 running Sun JVM 1.6 using JBoss EAP 5.1 from RHN (rpm install) Reporter: Graeme Gillies Assignee: Steven Hawkins Fix For: 7.2 Hi, We have an JBoss EAP 5.1 environment running in clustered mode, using the "production" jboss configuration. We have upgraded the environment to Teiid 7.2 (from teiid 7.1) and now when we attempt to start jboss/deploy vdbs we see the following error {code} 2010-11-08 14:30:16,807 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Real: name=vfszip:/var/lib/jbossas/server/production/deploy/DataStoreBNE.vdb/ state=PreReal mode=Manual requiredState=Real org.jboss.deployers.spi.DeploymentException: Error during deploy: vfszip:/var/lib/jbossas/server/production/deploy/Test.vdb/ at org.jboss.deployers.spi.DeploymentException.rethrowAsDeploymentException(DeploymentException.java:49) at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:185) at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1454) at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1172) at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1113) at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348) at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652) at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938) at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082) at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988) at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:826) at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:556) at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:789) at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:699) at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117) at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70) at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53) at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:403) at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348) at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652) at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938) at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082) at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988) at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:778) at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:543) at org.jboss.system.server.profileservice.repository.AbstractProfileService.registerProfile(AbstractProfileService.java:308) at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:256) at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461) at org.jboss.Main.boot(Main.java:221) at org.jboss.Main$1.run(Main.java:556) at java.lang.Thread.run(Thread.java:619) Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to org.teiid.dqp.internal.process.SessionAwareCache$CacheID at org.teiid.dqp.internal.process.SessionAwareCache.clearCache(SessionAwareCache.java:195) at org.teiid.dqp.internal.process.SessionAwareCache.clearForVDB(SessionAwareCache.java:189) at org.teiid.dqp.internal.process.DQPCore.clearResultSetCache(DQPCore.java:568) at org.teiid.dqp.internal.process.DQPCore.clearCache(DQPCore.java:617) at org.teiid.jboss.deployers.RuntimeEngineDeployer$1.added(RuntimeEngineDeployer.java:231) at org.teiid.deployers.VDBRepository.notifyAdd(VDBRepository.java:227) at org.teiid.deployers.VDBRepository.addVDB(VDBRepository.java:86) at org.teiid.deployers.VDBDeployer.deploy(VDBDeployer.java:145) at org.teiid.deployers.VDBDeployer.deploy(VDBDeployer.java:60) at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62) at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:55) at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:179) ... 29 more {code} It happens with all our VDBs, none of them deploy. We tried recreating/deploying the VDBs using a nightly version of the teiid designer and the problem persists. I have enabled clustering in Teiid by simply renaming the file teiid-cache-manager-jboss-beans-rename-me.xml to teiid-cache-manager-jboss-beans.xml in the teiid deploy directory -- 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

15 years, 2 months

4
5
0 / 0

[JBoss JIRA] Created: (TEIID-1209) Add cache usage statistics

by Steve Hawkins (JIRA)

Add cache usage statistics -------------------------- Key: TEIID-1209 URL: https://jira.jboss.org/browse/TEIID-1209 Project: Teiid Issue Type: Feature Request Components: Jopr Plugin, Query Engine Affects Versions: 7.1 Reporter: Steve Hawkins Assignee: Steve Hawkins Fix For: 7.1.1 There are no cache statistics provided for the preparedplan or resultset caches. It would be good to show information on #of entries, hit ratio, etc. -- 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

15 years, 2 months

3
3
0 / 0

[JBoss JIRA] Created: (TEIID-1243) teiid admin console plugin cannot show dynamic VDB content

by Aleksandar Kostadinov (JIRA)

teiid admin console plugin cannot show dynamic VDB content ---------------------------------------------------------- Key: TEIID-1243 URL: https://jira.jboss.org/browse/TEIID-1243 Project: Teiid Issue Type: Bug Affects Versions: 7.1 Environment: RHEL5, openjdk, SOA-P 5.1dev3 Reporter: Aleksandar Kostadinov Assignee: Steven Hawkins Attachments: exception.txt Trying to look at admin-console -> Data Services -> Virtual Database (VDB)s -> somevdb.1 -> contents throws an exception as seen in the attached file. I have found the issue using the example VBD attached to TEIID-1242 -- 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

15 years, 2 months

4
7
0 / 0

[JBoss JIRA] Created: (TEIID-1263) Reference Guide Section 10.3.1.2 - No sample code for "periodically checking the result object for new warnings"

by Darrin Mison (JIRA)

Reference Guide Section 10.3.1.2 - No sample code for "periodically checking the result object for new warnings" ---------------------------------------------------------------------------------------------------------------- Key: TEIID-1263 URL: https://jira.jboss.org/browse/TEIID-1263 Project: Teiid Issue Type: Feature Request Components: Documentation Affects Versions: 7.1 Reporter: Darrin Mison Assignee: Steven Hawkins Section 10.3.1.2. Source Unavailability - mentions that client applications need to be responsible for periodically checking the result object for new warnings but the code sample doesn't show how this should/could be implemented. There should either be an additional sample that shows this or it should be integrated into the "Printing List of Failed Sources" sample. -- 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

15 years, 2 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1066) Try to remove the Metadata Wrapper objects in the Client

by Ramesh Reddy (JIRA)

Try to remove the Metadata Wrapper objects in the Client -------------------------------------------------------- Key: TEIID-1066 URL: https://jira.jboss.org/jira/browse/TEIID-1066 Project: Teiid Issue Type: Task Components: AdminApi Reporter: Ramesh Reddy Assignee: Ramesh Reddy Priority: Minor Fix For: 7.0 There are few @MetadataMapper objects that convert from Managed object to the concrete object in the client code. These fail on regular basis when there is change to the class they are representing. Try to remove them and use built in reflection based methods. -- 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

15 years, 2 months

3
7
0 / 0

[JBoss JIRA] Created: (TEIID-1006) Dynamic vdb metadata load enhancements

by Steven Hawkins (JIRA)

Dynamic vdb metadata load enhancements -------------------------------------- Key: TEIID-1006 URL: https://jira.jboss.org/jira/browse/TEIID-1006 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.0 Reporter: Steven Hawkins Fix For: 7.1 Dynamic vdb metadata loading should have an admin or system function / call to reimport a particular source's metadata. The initial metadata loads should also be done in separate threads to prevent the caller from blocking (which is especially important if it's the deployer). -- 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

15 years, 2 months

2
4
0 / 0

[JBoss JIRA] Created: (TEIID-536) Evaluate uncorrleated subqueries prior to pushdown for all command types.

by Steven Hawkins (JIRA)

Evaluate uncorrleated subqueries prior to pushdown for all command types. -------------------------------------------------------------------------- Key: TEIID-536 URL: https://jira.jboss.org/jira/browse/TEIID-536 Project: Teiid Issue Type: Feature Request Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.x Criteria and expressions containing uncorrelated subqueries that cannot be pushed down should be evaluated at the access node. Currently they require the introduction of a separate select node or will simply fail for insert/update/delete. See also JBEDSP-928 -- 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

15 years, 2 months

2
4
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues November 2010