November 2011 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-1827) Client Recieving java.lang.IndexOutOfBoundsException when performing query

by Van Halbert (Created) (JIRA)

Client Recieving java.lang.IndexOutOfBoundsException when performing query -------------------------------------------------------------------------- Key: TEIID-1827 URL: https://issues.jboss.org/browse/TEIID-1827 Project: Teiid Issue Type: Bug Components: ODBC Affects Versions: 7.5 Environment: java version "1.6.0_20" OpenJDK Runtime Environment (IcedTea6 1.9.8) (rhel-1.22.1.9.8.el5_6-x86_64) OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode) Running on RHEL 5, teiid inside of JBoss EAP 5.1.1 Client is postgresql command line tool version postgresql-9.1.1-1.fc16.x86_64 Using the command line command psql -h teiid-01.app.eng.bos.redhat.com -p 35432 -U teiid -d EngVDBF Reporter: Graeme Gillies Assignee: Steven Hawkins Fix For: 7.6 When attempting to perform the following query using the postgres command line client connecting to teiids postgres emulation layer, we get the following error {code} SELECT components.name, COUNT(bug_id) FROM BugzillaS.bugs bugs, BugzillaS.components components, BugzillaS.profiles profiles WHERE (bugs.component_id = components.id AND bugs.reporter = profiles.userid AND bugs.creation_ts>='2011-10-04') GROUP BY components.name ORDER BY components.name limit 1500; {code} {code} ERROR: java.lang.IndexOutOfBoundsException DETAIL: org.teiid.jdbc.TeiidSQLException: java.lang.IndexOutOfBoundsException {code} Watching the server logs we don't see any such exception reported there, so I'd need some advice on how to get you some more information. Regards, Graeme -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1826) RFE/possible optimization: push down parts of some aggregate expressions

by Van Halbert (Moved) (JIRA)

[ https://issues.jboss.org/browse/TEIID-1826?page=com.atlassian.jira.plugin... ] Van Halbert moved SOA-3583 to TEIID-1826: ----------------------------------------- Project: Teiid (was: JBoss Enterprise SOA Platform) Key: TEIID-1826 (was: SOA-3583) Component/s: Query Engine (was: EDS) Security: (was: Public) > RFE/possible optimization: push down parts of some aggregate expressions > ------------------------------------------------------------------------ > > Key: TEIID-1826 > URL: https://issues.jboss.org/browse/TEIID-1826 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Debbie Steigner > Assignee: Van Halbert > > suggestion for a potential optimization: It concerns federated queries which do expressions. This is an extremely common requirement in the banking business, the main example being when monetary amounts need to be converted into a reporting currency using a rate in another database. > With the query below, it makes sense that despite the group by, EDS will pull back all the rows so it can multiply one by the other. Unfortunately this is often many millions of records. > Would it be feasible to have an optimization which push-down most of the aggregation to the source, then do a further aggregation in EDS? > * sum the tsl.func_amount, grouped by tsl.currency > * next: get the conversion rates for all the currency codes which have been returned, then sum(total * rate) > Of course, this can only be done for certain kinds of expressions. > select sum(tsl.func_amount * ccy.EuroConversionLegacyRate) > from TSL_FINANCIAL_ACCOUNT_ITEMS_T2 tsl > join t_sdm_currency ccy on tsl.currency = ccy.currencycode > where tsl.business_date = '2011-06-29' > group by ccy.EuroConversionLegacyRate -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1813) EDS performance tests shows a performance degradation against SOA-P 5.1.0.GA in case of selecting from XML datasource

by Steven Hawkins (Resolved) (JIRA)

[ https://issues.jboss.org/browse/TEIID-1813?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-1813. ----------------------------------- Assignee: Steven Hawkins (was: Van Halbert) Resolution: Done Added multi-threaded processing to reduce latency. Note that this change does not have any impact on the complexity of logic, it will just make batches available sooner. > EDS performance tests shows a performance degradation against SOA-P 5.1.0.GA in case of selecting from XML datasource > ---------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-1813 > URL: https://issues.jboss.org/browse/TEIID-1813 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Affects Versions: 7.4.1 > Reporter: Pavel Macik > Assignee: Steven Hawkins > Fix For: 7.6 > > Attachments: perf.vdb > > > The eds_xmlfile_select scenario shows ~30% performance degradation in select queries from XML datasource. > See the "(EDS) Files select - Charts" sheet of the document at [1] for details. > [1] https://docspace.corp.redhat.com/docs/DOC-56368 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1813) EDS performance tests shows a performance degradation against SOA-P 5.1.0.GA in case of selecting from XML datasource

by Steven Hawkins (Updated) (JIRA)

[ https://issues.jboss.org/browse/TEIID-1813?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-1813: ---------------------------------- Issue Type: Quality Risk (was: Bug) Fix Version/s: 7.6 Workaround Description: The workaround is to use an xquery expression that disables streaming: e.g. instead of '/a/b/c' something like '/*[local-name()='a']/b/c'. That should only be done of course if the parsed foot print of the document is relatively small. Priority: Major (was: Blocker) Component/s: Query Engine (was: Server) > EDS performance tests shows a performance degradation against SOA-P 5.1.0.GA in case of selecting from XML datasource > ---------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-1813 > URL: https://issues.jboss.org/browse/TEIID-1813 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Affects Versions: 7.4.1 > Reporter: Pavel Macik > Assignee: Van Halbert > Fix For: 7.6 > > Attachments: perf.vdb > > > The eds_xmlfile_select scenario shows ~30% performance degradation in select queries from XML datasource. > See the "(EDS) Files select - Charts" sheet of the document at [1] for details. > [1] https://docspace.corp.redhat.com/docs/DOC-56368 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1752) JavaDocs for Teiid needs to contain only what's exposed.

by Steven Hawkins (Commented) (JIRA)

[ https://issues.jboss.org/browse/TEIID-1752?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1752: --------------------------------------- The aggregate-jar goal is causing issues with initial builds in the release profile using maven 3. The build will complain about missing dependencies and error out. There are a host of maven related issues related to this and it's not clear if we are doing something wrong of if it's maven. The workaround is to run mvn install not in the release profile first to bootstrap the local repository or to run with -Dmaven.javadoc.skip=true. Is the product build running maven 2 and/or has it always run a non-release profile install prior to running in the release profile? Could we look at setting the skip property to true by default and having the product build explicitly set it to false? > JavaDocs for Teiid needs to contain only what's exposed. > -------------------------------------------------------- > > Key: TEIID-1752 > URL: https://issues.jboss.org/browse/TEIID-1752 > Project: Teiid > Issue Type: Enhancement > Components: Documentation > Affects Versions: 7.4.1 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 7.4.1 > > > Make adjustments to the pom.xml to exclude packages that don't need to be javadoc'd. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1726) Requesting ability to add/use Oracle hints in EDS

by Steven Hawkins (Resolved) (JIRA)

[ https://issues.jboss.org/browse/TEIID-1726?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-1726. ----------------------------------- Resolution: Done Updated the docs and release notes. > Requesting ability to add/use Oracle hints in EDS > ------------------------------------------------- > > Key: TEIID-1726 > URL: https://issues.jboss.org/browse/TEIID-1726 > Project: Teiid > Issue Type: Feature Request > Components: Server > Affects Versions: 7.4.1 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 7.6 > > > Requesting the ability to use Oracle hints inside virtual transformations and enduser queries in EDS and Teiid Designer -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1726) Requesting ability to add/use Oracle hints in EDS

by Steven Hawkins (Commented) (JIRA)

[ https://issues.jboss.org/browse/TEIID-1726?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1726: --------------------------------------- Implemented as described previously. Also addressed the string form of a union first branch when using a limit, ensured that source hints are only applied once, allowed nested comments, and ensured that sql injection is not possible from hints (whether from a source hint or from an execution payload). Will update the release notes and docs as well. > Requesting ability to add/use Oracle hints in EDS > ------------------------------------------------- > > Key: TEIID-1726 > URL: https://issues.jboss.org/browse/TEIID-1726 > Project: Teiid > Issue Type: Feature Request > Components: Server > Affects Versions: 7.4.1 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 7.6 > > > Requesting the ability to use Oracle hints inside virtual transformations and enduser queries in EDS and Teiid Designer -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1813) EDS performance tests shows a performance degradation against SOA-P 5.1.0.GA in case of selecting from XML datasource

by Steven Hawkins (Commented) (JIRA)

[ https://issues.jboss.org/browse/TEIID-1813?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1813: --------------------------------------- >From an initial investigation I would estimate that that there is about a 10% overhead (depending upon the document and types used) when running a streaming query vs. non-streaming. This is due to using an intermediate tuplebuffer and xom/nux. However there are no obvious hotspots. The rest of the overhead in a client/server scenario is likely from the increased latency of streaming processing - results are not returned until the document has been fully processed. Changing results processing to be multi-threaded would be the next step. > EDS performance tests shows a performance degradation against SOA-P 5.1.0.GA in case of selecting from XML datasource > ---------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-1813 > URL: https://issues.jboss.org/browse/TEIID-1813 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 7.4.1 > Reporter: Pavel Macik > Assignee: Van Halbert > Priority: Blocker > Attachments: perf.vdb > > > The eds_xmlfile_select scenario shows ~30% performance degradation in select queries from XML datasource. > See the "(EDS) Files select - Charts" sheet of the document at [1] for details. > [1] https://docspace.corp.redhat.com/docs/DOC-56368 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1817) Documentation changes for SSL configuration

by Van Halbert (Created) (JIRA)

Documentation changes for SSL configuration ------------------------------------------- Key: TEIID-1817 URL: https://issues.jboss.org/browse/TEIID-1817 Project: Teiid Issue Type: Bug Components: Documentation Affects Versions: 7.4.1 Reporter: Paul Nittel Assignee: Steven Hawkins While testing SSL configuration I noticed a few items in the documentation which were confusing and in need of clarification. keymanagementAlgorithm - Type of key algorithm used. Default is based upon the VM, e.g. "SunX509" The out-of-the-box value of keymanagementAlgorithm is "false". If SunX509 is likely to be used, let's have it in teiid-jboss-beans.xml by default. The doc mentions the keystore "must be available in the classpath of Teiid Server." Apparently that's not just anywhere. I tried the lib directory and it failed. Ramesh suggested the conf directory and it worked. If it must be in conf, let's say so. Lastly, a minor nit. The second paragraph under section "3.5 Configuring SSL" is: There are three socket transports, each with it's own SSL configuration. Of course the word "it's" (a contraction of "it" and "is") should be replaced by the possessive form, "its". -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 10 months

1
0
0 / 0

[JBoss JIRA] Created: (TEIID-1589) metadata per translator per request

by Mark Addleman (JIRA)

metadata per translator per request ----------------------------------- Key: TEIID-1589 URL: https://issues.jboss.org/browse/TEIID-1589 Project: Teiid Issue Type: Feature Request Reporter: Mark Addleman Assignee: Steven Hawkins Priority: Minor I'd like to the translator to attach metadata to the results it passes back to the Teiid JDBC client. For example, I'd like the translator to examine the connection object and decorate the returned data with which datasource provided the data. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 10 months

6
9
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues November 2011