July 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3121) Teiid Standalone Server

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3121?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3121. --------------------------------- > Teiid Standalone Server > ----------------------- > > Key: TEIID-3121 > URL: https://issues.jboss.org/browse/TEIID-3121 > Project: Teiid > Issue Type: Feature Request > Components: Build/Kits > Reporter: Tom Arnold > Fix For: 8.10 > > > Perform the server installation steps as part of the build and add the result to the downloads page. It seems like this is something that everyone who isn't using the embedded kit has to do anyways, and would hopefully eliminate confusion caused by people trying to deploy the runtime in unsupported versions of JBoss. > * Teiid Runtime > * Teiid Web Console > * JBoss EAP 6.1 Alpha > * Resteasy JAX-RS Patch > End result would simplify the installation process to: > 1. Unzip Teiid server. > 2. Run `bin/add-user.sh` script. > 3. Deploy custom translators, VDB, etc. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3227) Add support for sub-expression pushing of must pushdown functions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3227?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3227. --------------------------------- > Add support for sub-expression pushing of must pushdown functions > ----------------------------------------------------------------- > > Key: TEIID-3227 > URL: https://issues.jboss.org/browse/TEIID-3227 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 8.9 > Reporter: Michał Warecki > Assignee: Steven Hawkins > Priority: Minor > Fix For: 8.10 > > > As a user I'd like to have a possibility to push down sub-expressions of must pushdown functions. > Example: > Input query with not supported group by: > SELECT AAA, SUM(custom_function(BBB)) AS BBB_ALIAS FROM some_table WHERE some_table.CCC = 'VAL' GROUP BY AAA ORDER BY AAA > > Output query (processed by teiid): > SELECT AAA, BBB AS BBB_ALIAS FROM some_table.CCC = 'VAL' > > What I think it should looks like: > SELECT AAA, custom_function(BBB) AS BBB_ALIAS FROM some_table.CCC = 'VAL' > https://developer.jboss.org/message/910926#910926 -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3350) Add system functions for EWKT & KML

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3350?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3350. --------------------------------- > Add system functions for EWKT & KML > ----------------------------------- > > Key: TEIID-3350 > URL: https://issues.jboss.org/browse/TEIID-3350 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Tom Arnold > Assignee: Steven Hawkins > Fix For: 8.11 > > -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3229) Inappropriate pushdown of a must pushdown function

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3229?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3229. --------------------------------- > Inappropriate pushdown of a must pushdown function > -------------------------------------------------- > > Key: TEIID-3229 > URL: https://issues.jboss.org/browse/TEIID-3229 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.6 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.10 > > > If a must push down function is used over a grouping that is not pushed, then an invalid symbol will be created and cause an invalid source query and or a class cast exception. > For example: > select some_funct(c1) from tbl group by c1 > where the translator does not support grouping. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3377) NPE on initializing a GroupingNode when HAVING clause is used in an INSERT INTO query

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3377?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3377. --------------------------------- > NPE on initializing a GroupingNode when HAVING clause is used in an INSERT INTO query > ------------------------------------------------------------------------------------- > > Key: TEIID-3377 > URL: https://issues.jboss.org/browse/TEIID-3377 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Salvatore R > Assignee: Steven Hawkins > Fix For: 8.11 > > > Running the following INSERT INTO query: > {code:sql} > INSERT INTO my.testInsert > SELECT key_name, key_type FROM (select 'a' as key_name, 'b' as key_type) k HAVING count(*)>1 > {code} > this exception is thrown: > {code:sql} > 16:50:55,081 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) Yh/8IUqIBLy9 TEIID30019 Unexpected exception for request Yh/8IUqIBLy9.0: java.lang.NullPointerException > at org.teiid.query.processor.relational.GroupingNode.initialize(GroupingNode.java:218) [teiid-engine-8.10.0.Final.jar:8.10.0.Final] > at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:96) [teiid-engine-8.10.0.Final.jar:8.10.0.Final] > at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102) [teiid-engine-8.10.0.Final.jar:8.10.0.Final] > at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102) [teiid-engine-8.10.0.Final.jar:8.10.0.Final] > at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102) [teiid-engine-8.10.0.Final.jar:8.10.0.Final] > at org.teiid.query.processor.relational.RelationalPlan.initialize(RelationalPlan.java:91) [teiid-engine-8.10.0.Final.jar:8.10.0.Final] > at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:226) [teiid-engine-8.10.0.Final.jar:8.10.0.Final] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:138) [teiid-engine-8.10.0.Final.jar:8.10.0.Final] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.10.0.Final.jar:8.10.0.Final] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.10.0.Final.jar:8.10.0.Final] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.10.0.Final.jar:8.10.0.Final] > at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:455) [teiid-engine-8.10.0.Final.jar:8.10.0.Final] > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:337) [teiid-engine-8.10.0.Final.jar:8.10.0.Final] > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.10.0.Final.jar:8.10.0.Final] > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:265) [teiid-engine-8.10.0.Final.jar:8.10.0.Final] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.10.0.Final.jar:8.10.0.Final] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.10.0.Final.jar:8.10.0.Final] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.10.0.Final.jar:8.10.0.Final] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51] > at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51] > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3169) Update infinispan-cache translator to use DSLQuery in library mode

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3169?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3169. --------------------------------- > Update infinispan-cache translator to use DSLQuery in library mode > ------------------------------------------------------------------ > > Key: TEIID-3169 > URL: https://issues.jboss.org/browse/TEIID-3169 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.7.1, 8.10 > > > The curent lucene query logic needs to be upgraded to use the DSL query logic to perform searches on the cache when in library mode. This logic is currently being used in the infinispan-cache-dsl translator. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2194) Allow the mat view cache hint to be specified via a property

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2194?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2194. --------------------------------- > Allow the mat view cache hint to be specified via a property > ------------------------------------------------------------ > > Key: TEIID-2194 > URL: https://issues.jboss.org/browse/TEIID-2194 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.2 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > Setting the mat cache hint via a property is useful so that it can be changed independently of the view definition. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3189) Defined materialization in the dynamic VDB fails to deploy

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3189?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3189. --------------------------------- > Defined materialization in the dynamic VDB fails to deploy > ---------------------------------------------------------- > > Key: TEIID-3189 > URL: https://issues.jboss.org/browse/TEIID-3189 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Van Halbert > Attachments: customer-schema.sql, portfolio-vdb.xml > > > The attached dynamic VDB that's in the dynamicvdb-data-federation quick start, fails to deploy based on the defined materialization (remove it and the VDB deploys fine): > 15:33:39,870 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue12) TEIID30020 Processing exception for request Za7hE/1FAkqH.0 'TEIID30168 Couldn't execute the dynamic SQL command "EXECUTE IMMEDIATE (updateStmt || ' AND loadNumber = DVARS.loadNumber') USING loadNumber = VARIABLES.loadNumber, vdbName = VARIABLES.vdbName, vdbVersion = VARIABLES.vdbVersion, schemaName = schemaName, viewName = viewName, updated = now(), LoadState = 'FAILED_LOAD', valid = (VARIABLES.valid) AND (NOT (invalidate)), cardinality = -1" with the SQL statement "(updateStmt || ' AND loadNumber = DVARS.loadNumber')" due to: TEIID30082 Cannot set symbol 'LoadNumber' with expected type integer to expression 'DVARS.LoadNumber''. Originally QueryProcessingException 'TEIID30082 Expected value of type 'integer' but 'DVARS.LoadNumber' is of type 'long' and no implicit conversion is available.' ResolverUtil.java:217. Enable more detailed logging to see the entire stacktrace. > 15:33:39,872 WARN [org.teiid.PROCESSOR.MATVIEWS] (teiid-async-threads - 3) TEIID50100 Trigger execution result: org.jboss.as.controller.OperationFailedException [ "TEIID30168 org.teiid.api.exception.query.QueryProcessingException: TEIID30168 Couldn't execute the dynamic SQL command \"EXECUTE IMMEDIATE (updateStmt || ' AND loadNumber = DVARS.loadNumber') USING loadNumber = VARIABLES.loadNumber, vdbName = VARIABLES.vdbName, vdbVersion = VARIABLES.vdbVersion, schemaName = schemaName, viewName = viewName, updated = now(), LoadState = 'FAILED_LOAD', valid = (VARIABLES.valid) AND (NOT (invalidate)), cardinality = -1\" with the SQL statement \"(updateStmt || ' AND loadNumber = DVARS.loadNumber')\" due to: TEIID30082 Cannot set symbol 'LoadNumber' with expected type integer to expression 'DVARS.LoadNumber'" ]: org.teiid.jdbc.TeiidSQLException: TEIID50100 Trigger execution result: org.jboss.as.controller.OperationFailedException [ "TEIID30168 org.teiid.api.exception.query.QueryProcessingException: TEIID30168 Couldn't execute the dynamic SQL command \"EXECUTE IMMEDIATE (updateStmt || ' AND loadNumber = DVARS.loadNumber') USING loadNumber = VARIABLES.loadNumber, vdbName = VARIABLES.vdbName, vdbVersion = VARIABLES.vdbVersion, schemaName = schemaName, viewName = viewName, updated = now(), LoadState = 'FAILED_LOAD', valid = (VARIABLES.valid) AND (NOT (invalidate)), cardinality = -1\" with the SQL statement \"(updateStmt || ' AND loadNumber = DVARS.loadNumber')\" due to: TEIID30082 Cannot set symbol 'LoadNumber' with expected type integer to expression 'DVARS.LoadNumber'" ] > at org.teiid.jboss.MaterializationManagementService$1.executeQuery(MaterializationManagementService.java:104) [teiid-jboss-integration-8.7.1.redhat-4.jar:8.7.1.redhat-4] > at org.teiid.runtime.MaterializationManager$QueryJob$1.run(MaterializationManager.java:267) [teiid-runtime-8.7.1.redhat-4.jar:8.7.1.redhat-4] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_55] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_55] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_55] > at org.jboss.threads.JBossThread.run(JBossThread.java:122) -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3225) TRACE level logging to request conflicting NAMESPACE and PATH references in WS request/response sets

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3225?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3225. --------------------------------- > TRACE level logging to request conflicting NAMESPACE and PATH references in WS request/response sets > ---------------------------------------------------------------------------------------------------- > > Key: TEIID-3225 > URL: https://issues.jboss.org/browse/TEIID-3225 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Johnathon Lee > Assignee: Steven Hawkins > Fix For: 8.10 > > > Requesting detailed logging the can highlight when there are conflicting namespace and path references which would prevent response data from being displayed. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3284) Remove the prestodb jar

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3284?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3284. --------------------------------- > Remove the prestodb jar > ----------------------- > > Key: TEIID-3284 > URL: https://issues.jboss.org/browse/TEIID-3284 > Project: Teiid > Issue Type: Sub-task > Components: Misc. Connectors > Affects Versions: 8.10 > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Labels: Beta2 > Fix For: 8.10 > > > Starting with version .87 the presto driver has the fix submitted by Ramesh. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 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 July 2015