October 2012 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2069) Optimze add LIMIT clause to SELECT within a Virtual Procedure using Oracle

by Johnathon Lee (JIRA)

Johnathon Lee created TEIID-2069: ------------------------------------ Summary: Optimze add LIMIT clause to SELECT within a Virtual Procedure using Oracle Key: TEIID-2069 URL: https://issues.jboss.org/browse/TEIID-2069 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.7, 7.4.1 Reporter: Johnathon Lee Assignee: Steven Hawkins LIMIT clause is added to Statement being optimized which fails the operation on Oracle OPTIMIZE: CREATE VIRTUAL PROCEDURE BEGIN DECLARE biginteger VARIABLES.t_pk; VARIABLES.t_pk = (SELECT <table>.seq_gen.cpe_seq FROM <table>.seq_gen); SELECT VARIABLES.t_pk AS result; END #################################################### PROCEDURE COMMAND: CREATE VIRTUAL PROCEDURE BEGIN DECLARE biginteger VARIABLES.t_pk; VARIABLES.t_pk = (SELECT <table>.seq_gen.cpe_seq FROM <table>.seq_gen LIMIT 2); SELECT VARIABLES.t_pk AS result; END -- 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

12 years

3
25
0 / 0

[JBoss JIRA] (TEIID-2183) Duplicate column exception mentions table instead

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2183: ------------------------------------- Summary: Duplicate column exception mentions table instead Key: TEIID-2183 URL: https://issues.jboss.org/browse/TEIID-2183 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.2 The duplicate column exception from the MetadataFactory mentions table instead. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

1
2
0 / 0

[JBoss JIRA] (TEIID-2185) Cost estimation for temp table index selection is incorrect

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2185: ------------------------------------- Summary: Cost estimation for temp table index selection is incorrect Key: TEIID-2185 URL: https://issues.jboss.org/browse/TEIID-2185 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.2 The index selection for temporary tables incorrectly computes an additional cost factor that biases the selection against secondary indexies. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

3
6
0 / 0

[JBoss JIRA] (TEIID-2272) Add Teiid quickstarts

by Van Halbert (JIRA)

Van Halbert created TEIID-2272: ---------------------------------- Summary: Add Teiid quickstarts Key: TEIID-2272 URL: https://issues.jboss.org/browse/TEIID-2272 Project: Teiid Issue Type: Task Components: Build/Kits Affects Versions: 8.2 Reporter: Van Halbert Assignee: Van Halbert This the parent task for tracking the different quick starts. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

2
3
0 / 0

[JBoss JIRA] (TEIID-2234) Function pushdown issues

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2234: ------------------------------------- Summary: Function pushdown issues Key: TEIID-2234 URL: https://issues.jboss.org/browse/TEIID-2234 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.2 Function validation should not prevent a function name from containing a '.' and nameinsource should be respected for ddl foreign functions. We also have an issue with function names conflicting with system function names any time there is a check of just the descriptor name without checking the schema. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

1
3
0 / 0

[JBoss JIRA] (TEIID-2242) Create quick start

by Van Halbert (JIRA)

Van Halbert created TEIID-2242: ---------------------------------- Summary: Create quick start Key: TEIID-2242 URL: https://issues.jboss.org/browse/TEIID-2242 Project: Teiid Issue Type: Sub-task Components: Documentation Affects Versions: 8.2 Reporter: Van Halbert Assignee: Van Halbert Create a quickstart demonstrating the ability to query infinispan using a local cache. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

2
7
0 / 0

[JBoss JIRA] (TEIID-2190) Key usage can remove predicates

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2190: ------------------------------------- Summary: Key usage can remove predicates Key: TEIID-2190 URL: https://issues.jboss.org/browse/TEIID-2190 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Blocker Fix For: 8.2 The implementation strategy for predicate realignment can drop non-column equi join predicates and predicates involving the same column reused multiple times. i.e. create local temporary table x (e1 string, e2 integer, primary key (e1)); create local temporary table x1 (e1 string, e2 integer) ... select x.e1 from x inner join x1 on x.e1 = x1.e1 and upper(x.e1) = x1.e2 May end up not applying the upper predicate. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

2
5
0 / 0

[JBoss JIRA] (TEIID-2271) Timing issue when processing data from an XML stream

by Paul Richardson (JIRA)

Paul Richardson created TEIID-2271: -------------------------------------- Summary: Timing issue when processing data from an XML stream Key: TEIID-2271 URL: https://issues.jboss.org/browse/TEIID-2271 Project: Teiid Issue Type: Bug Components: XML Connector Affects Versions: 8.2 Reporter: Paul Richardson Assignee: Steven Hawkins Running a preview on an XML datasource causes a freezing of the gui. The main thread is stuck trying {{SocketInputStream.socketRead0}}, which never returns. The jboss log indicates a BlockedException has occurred and only when designer is forcibly terminated does the input stream read get cancelled. Discussions over the log indicate ... '... a timing issue where the asynch processing thread notifies after the processing thread has been detached and there's no other action that restarts the plan' Server log snippet attached. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

2
3
0 / 0

[JBoss JIRA] (TEIID-2158) Generate a Rest based service automatically based on deployed VDB

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-2158: ----------------------------------- Summary: Generate a Rest based service automatically based on deployed VDB Key: TEIID-2158 URL: https://issues.jboss.org/browse/TEIID-2158 Project: Teiid Issue Type: Feature Request Components: Server Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 8.2 Currently to enable REST based services on top of the VDB, Designer provides a mechanism for user to define metadata on the procedure and gives hooks to generate Rest service based WAR file to deploy into a application server. To support OpenShift efforts it would be good to provide this functionality out of box, when Teiid is deployed into the JBoss AS (never in embedded). To define a scenario, - user creates a VDB and defines one or more models - then user creates a virtual procedure with following metadata in the options clause REST:METHOD = GET|PUT|POST|DELETE (mandatory) REST:URI = uri (mandatory) REST:PRODUCES = xml|json|text (optional, if omitted will be calculated from procedures return parameter) REST:CHARSET = character set (optional) (ex:US-ASCII, UTF-8 etc. In cases where the binary data is returned this character set will be used to convert) where REST namesspace is defined as SET NAMESPACE 'http://teiid.org/rest' AS REST; - user deploys a VDB - a jax-rs based war is created and deployed automatically at the end of vdb deployment - if vdb is un-deployed, this jax-rs war will also be undeployed Questions? 1) Should this enforce HTTPBasic Auth by default? since Teiid does not have a way define the DDL based metadata this is difficult. 2) Apart from above procedures, does a generic procedure that executes a add-hoc query helpful? The restriction here is the results will be in a pre-defined format not user defined. -- 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

12 years, 1 month

2
6
0 / 0

[JBoss JIRA] (TEIID-2244) dynamic VDB, UDF class not found

by David Eichmann (JIRA)

David Eichmann created TEIID-2244: ------------------------------------- Summary: dynamic VDB, UDF class not found Key: TEIID-2244 URL: https://issues.jboss.org/browse/TEIID-2244 Project: Teiid Issue Type: Bug Affects Versions: 8.1 Environment: OS X 10.7.5 Reporter: David Eichmann Assignee: Steven Hawkins I'm attempting to deploy a UDF in a dynamic VDB and getting a ClassNotFound: 14:45:41,654 ERROR org.jboss.threads.executor (teiid-async-threads - 4) Task execution failed for task org.teiid.jboss.VDBService$6@3327d4d9: org.teiid.core.TeiidRuntimeException: TEIID30387 Could not load UDF "institute", since its invocation class "edu.uiowa.tagUtil.grantParser.nih" could not be found. at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:321) teiid-engine-8.1.0.Final.jar:8.1.0.Final at org.teiid.query.function.FunctionTree.addFunction(FunctionTree.java:232) teiid-engine-8.1.0.Final.jar:8.1.0.Final at org.teiid.query.function.FunctionTree.(FunctionTree.java:106) teiid-engine-8.1.0.Final.jar:8.1.0.Final at org.teiid.deployers.CompositeVDB.buildTransformationMetaData(CompositeVDB.java:84) teiid-runtime-8.1.0.Final.jar:8.1.0.Final at org.teiid.deployers.CompositeVDB.metadataLoadFinished(CompositeVDB.java:333) teiid-runtime-8.1.0.Final.jar:8.1.0.Final at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:287) teiid-runtime-8.1.0.Final.jar:8.1.0.Final at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:166) teiid-runtime-8.1.0.Final.jar:8.1.0.Final at org.teiid.jboss.VDBService.access$800(VDBService.java:89) teiid-jboss-integration-8.1.0.Final.jar:8.1.0.Final at org.teiid.jboss.VDBService$6.run(VDBService.java:385) teiid-jboss-integration-8.1.0.Final.jar:8.1.0.Final at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33) at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:801) at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45) at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:842) at java.lang.Thread.run(Thread.java:680) Teiid 8.1 - dynamic VDB, UDF class not found at org.jboss.threads.JBossThread.run(JBossThread.java:122) Caused by: java.lang.ClassNotFoundException: edu.uiowa.tagUtil.grantParser.nih from [Module "org.jboss.teiid:main" from local module loader @671ff436 (roots: /Users/eichmann/downloads/jboss/jboss-as-7.1.1.Final/modules)] at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:190) jboss-modules.jar:1.1.1.GA at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:468) jboss-modules.jar:1.1.1.GA at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:456) jboss-modules.jar:1.1.1.GA at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:423) jboss-modules.jar:1.1.1.GA at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:398) jboss-modules.jar:1.1.1.GA at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:120) jboss-modules.jar:1.1.1.GA at java.lang.Class.forName0(Native Method) Teiid 8.1 - dynamic VDB, UDF class not found at java.lang.Class.forName(Class.java:247) Teiid 8.1 - dynamic VDB, UDF class not found at org.teiid.query.function.UDFSource.getInvocationClass(UDFSource.java:44) teiid-engine-8.1.0.Final.jar:8.1.0.Final at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:311) teiid-engine-8.1.0.Final.jar:8.1.0.Final ... 14 more re Ramesh, the class loader for DDL is not getting properly set. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

3
6
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2012