October 2013 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2188) When using CONCAT2(x, y), can the source query be changed to not include the CASE statements and let Oracle do the NULL compare

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2188?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2188: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 855016|https://bugzilla.redhat.com/show_bug.cgi?id=855016] from MODIFIED to ON_QA > When using CONCAT2(x, y), can the source query be changed to not include the CASE statements and let Oracle do the NULL compare > ------------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-2188 > URL: https://issues.jboss.org/browse/TEIID-2188 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 7.4.4 > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.2 > > > When CONCAT2(x, y) is used, the rewritten query is very verbose in adding a CASE statement to check for nulls. Can the rewritten query not include the CASE statements and just let Oracle do the compare, because it can do it more efficiently within the CONCAT call? > Example: > select concat2(f1,f2) from table1 > results in > SELECT c_0 FROM (SELECT CASE WHEN to_char(g_0.f1) IS NULL AND g_0.f2 IS NULL THEN NULL ELSE concat(nvl(to_char(g_0.f1), ''), nvl(g_0.f2, '')) END AS c_0 FROM table1 g_0) -- 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, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1854) OData server

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-1854?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-1854: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 892717|https://bugzilla.redhat.com/show_bug.cgi?id=892717] from MODIFIED to ON_QA > OData server > ------------ > > Key: TEIID-1854 > URL: https://issues.jboss.org/browse/TEIID-1854 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Mark Addleman > Assignee: Ramesh Reddy > Fix For: 8.3 > > > Teiid should act as an OData server as well as a JDBC server. This is not TEIID-1757 as that is about Teiid being an OData client. -- 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, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2248) Implement Salesforce Bulk API for inserts/updates to Salesforce Connector

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2248?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2248: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 796965|https://bugzilla.redhat.com/show_bug.cgi?id=796965] from MODIFIED to ON_QA > Implement Salesforce Bulk API for inserts/updates to Salesforce Connector > ------------------------------------------------------------------------- > > Key: TEIID-2248 > URL: https://issues.jboss.org/browse/TEIID-2248 > Project: Teiid > Issue Type: Feature Request > Components: Salesforce Connector > Reporter: Marc Shirley > Assignee: Ramesh Reddy > Fix For: 8.3 > > > Wish to utilize the Salesforce Bulk API for large inserts/updates. The specific use case was for writing/updating a million record table back up to their Salesforce instance. This will improve performance for large writes to the Salesforce instance. -- 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, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2649) NoClassDefFoundError when trying to run adminshell

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2649?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2649: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1004770|https://bugzilla.redhat.com/show_bug.cgi?id=1004770] from MODIFIED to ON_QA > NoClassDefFoundError when trying to run adminshell > -------------------------------------------------- > > Key: TEIID-2649 > URL: https://issues.jboss.org/browse/TEIID-2649 > Project: Teiid > Issue Type: Bug > Components: Tools > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > Priority: Blocker > > adminshell is throwing the following exception when trying to be run: > Exception in thread "main" java.lang.NoClassDefFoundError: jline/History > at java.lang.Class.getDeclaredMethods0(Native Method) > at java.lang.Class.privateGetDeclaredMethods(Class.java:2521) > at java.lang.Class.getDeclaredMethods(Class.java:1845) > at org.codehaus.groovy.reflection.CachedClass$3$1.run(CachedClass.java:83) > at java.security.AccessController.doPrivileged(Native Method) > at org.codehaus.groovy.reflection.CachedClass$3.initValue(CachedClass.java:80) > at org.codehaus.groovy.reflection.CachedClass$3.initValue(CachedClass.java:78) > at org.codehaus.groovy.util.LazyReference.getLocked(LazyReference.java:46) > at org.codehaus.groovy.util.LazyReference.get(LazyReference.java:33) > at org.codehaus.groovy.reflection.CachedClass.getMethods(CachedClass.java:249) > at groovy.lang.MetaClassImpl.populateMethods(MetaClassImpl.java:341) > at groovy.lang.MetaClassImpl.fillMethodIndeMetaClassImpl.java:291) > at groovy.lang.MetaClassImpl.initialize(MetaClassImpl.java:2912) > at org.codehaus.groovy.reflection.ClassInfo.getMetaClassUnderLock(ClassInfo.java:166) > at org.codehaus.groovy.reflection.ClassInfo.getMetaClass(ClassInfo.java:182) > at org.codehaus.groovy.runtime.metaclass.MetaClassRegistryImpl.getMetaClass(MetaClassRegistryImpl.java:210) > at org.codehaus.groovy.runtime.InvokerHelper.getMetaClass(InvokerHelper.java:701) > at org.codehaus.groovy.runtime.callsite.CallSiteArray.createCallConstructorSite(CallSiteArray.java:69) > at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstructor(CallSiteArray.java:52) > at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:192) > at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:200) > at org.codehaus.groovy.tools.shell.Main.main(Main.groovy:124) > at org.teiid.adminshell.GroovyAdminShell.main(GroovyAdminShell.java:30) > Caused by: java.lang.ClassNotFoundException: jline.History > at java.net.URLClassLoader$1.run(URLClassLoader.java:366) > at java.net.URLClassLoader$1.run(URLClassLoader.java:355) > at java.security.AccessController.doPrivileged(Native Method) > at java.net.URLClassLoader.findClass(URLClassLoader.java:354) > at java.lang.ClassLoader.loadClass(ClassLoader.java:424) > at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) > at java.lang.ClassLoader.loadClass(ClassLoader.java:357) > ... 23 more -- 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, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2691) Grouping expression with view fails when grouping columns have the same name

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2691?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2691. ----------------------------------- Resolution: Done Updated the logic to use the raw expression from the compensating view projection. > Grouping expression with view fails when grouping columns have the same name > ---------------------------------------------------------------------------- > > Key: TEIID-2691 > URL: https://issues.jboss.org/browse/TEIID-2691 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.5 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.6 > > > If a source supports views, but not grouping expression, and grouping/select columns have the same short name, then the view creation logic will fail with: > ERROR [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue6859) caU8stCGl+8r TEIID30019 Unexpected exception for request caU8stCGl+8r.0: java.lang.AssertionError: Cannot create AliasSymbol wrapping AliasSymbol > at org.teiid.core.util.Assertion.failed(Assertion.java:73) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.sql.symbol.AliasSymbol.setSymbol(AliasSymbol.java:76) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.sql.visitor.ExpressionMappingVisitor.visit(ExpressionMappingVisitor.java:159) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.sql.symbol.AliasSymbol.acceptVisitor(AliasSymbol.java:90) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:54) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.preVisitVisitor(PreOrPostOrderNavigator.java:54) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:77) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.sql.symbol.AliasSymbol.acceptVisitor(AliasSymbol.java:90) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:63) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:297) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.sql.lang.OrderByItem.acceptVisitor(OrderByItem.java:87) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:63) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:76) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:291) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.sql.lang.OrderBy.acceptVisitor(OrderBy.java:136) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.doVisit(PreOrPostOrderNavigator.java:669) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.sql.visitor.ExpressionMappingVisitor.mapExpressions(ExpressionMappingVisitor.java:394) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.optimizer.relational.rules.RuleCollapseSource.rewriteGroupByAsView(RuleCollapseSource.java:741) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] -- 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, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2691) Grouping expression with view fails when grouping columns have the same name

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2691: ------------------------------------- Summary: Grouping expression with view fails when grouping columns have the same name Key: TEIID-2691 URL: https://issues.jboss.org/browse/TEIID-2691 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.5 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.6 If a source supports views, but not grouping expression, and grouping/select columns have the same short name, then the view creation logic will fail with: ERROR [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue6859) caU8stCGl+8r TEIID30019 Unexpected exception for request caU8stCGl+8r.0: java.lang.AssertionError: Cannot create AliasSymbol wrapping AliasSymbol at org.teiid.core.util.Assertion.failed(Assertion.java:73) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final] at org.teiid.query.sql.symbol.AliasSymbol.setSymbol(AliasSymbol.java:76) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] at org.teiid.query.sql.visitor.ExpressionMappingVisitor.visit(ExpressionMappingVisitor.java:159) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] at org.teiid.query.sql.symbol.AliasSymbol.acceptVisitor(AliasSymbol.java:90) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:54) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.preVisitVisitor(PreOrPostOrderNavigator.java:54) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:77) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] at org.teiid.query.sql.symbol.AliasSymbol.acceptVisitor(AliasSymbol.java:90) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:63) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:297) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] at org.teiid.query.sql.lang.OrderByItem.acceptVisitor(OrderByItem.java:87) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:63) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:76) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:291) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] at org.teiid.query.sql.lang.OrderBy.acceptVisitor(OrderBy.java:136) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.doVisit(PreOrPostOrderNavigator.java:669) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] at org.teiid.query.sql.visitor.ExpressionMappingVisitor.mapExpressions(ExpressionMappingVisitor.java:394) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] at org.teiid.query.optimizer.relational.rules.RuleCollapseSource.rewriteGroupByAsView(RuleCollapseSource.java:741) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] -- 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, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2665) Hive translator pushdown improvements

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2665?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2665: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1016111|https://bugzilla.redhat.com/show_bug.cgi?id=1016111] from NEW to ASSIGNED > Hive translator pushdown improvements > ------------------------------------- > > Key: TEIID-2665 > URL: https://issues.jboss.org/browse/TEIID-2665 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Labels: Alpha2 > Fix For: 8.6 > > > - Hive 0.11 windowing functions: push down > - Native Queries support > - Test multi-source bindings with Hive Partition Tables - each binding to a discrete partition table > - validate that off-heap buffer management can be used with very large data sets from Hadoop/Hive -- 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, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2424) Create OSGi bundles for Embedded

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2424?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2424: ------------------------------------- Added the parent pom for the resource adapters and moved all the RAR and Bundle generation into it. The child pom will generate a JAR which gets included with RAR, and bundle is generated with "lib" classifier. > Create OSGi bundles for Embedded > -------------------------------- > > Key: TEIID-2424 > URL: https://issues.jboss.org/browse/TEIID-2424 > Project: Teiid > Issue Type: Feature Request > Components: AdminApi, Embedded > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Labels: Alpha1 > Fix For: 8.6 > > > Embedded should be available as an OSGi bundle(s). It may also be useful for Designer to consume us through bundles as well. -- 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, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2424) Create OSGi bundles for Embedded

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2424?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-2424. --------------------------------- Resolution: Done > Create OSGi bundles for Embedded > -------------------------------- > > Key: TEIID-2424 > URL: https://issues.jboss.org/browse/TEIID-2424 > Project: Teiid > Issue Type: Feature Request > Components: AdminApi, Embedded > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Labels: Alpha1 > Fix For: 8.6 > > > Embedded should be available as an OSGi bundle(s). It may also be useful for Designer to consume us through bundles as well. -- 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, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2690) Tuples lost in a with clause item.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2690?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2690: ---------------------------------- Fix Version/s: 8.4.1 > Tuples lost in a with clause item. > ---------------------------------- > > Key: TEIID-2690 > URL: https://issues.jboss.org/browse/TEIID-2690 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.1, 7.7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 8.4.1, 8.6 > > > Related to TEIID-2442 - the BatchIterator created for the creation of the temp table backing a with clause item cannot be created after blocking without loosing tuples. > On 8.3.x+ a single block is not sufficient to induce this behavior if there are any tuples that have been retrieved since the last block as the access node logic will return the partial batch. Thus may occur as a somewhat rare timing issue in 8.3.x+. However in 7.7.7/7.7.8 a single block cause the recreation of the BatchIterator making the affect almost certain once the row count exceeds the computed working batch size (nominally 256 rows, but allowed to vary based upon the row width). -- 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, 10 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2013