July 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2472) Create quickstart(s) demonstrating security

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2472?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2472. --------------------------------- > Create quickstart(s) demonstrating security > ------------------------------------------- > > Key: TEIID-2472 > URL: https://issues.jboss.org/browse/TEIID-2472 > Project: Teiid > Issue Type: Sub-task > Components: Quick Starts > Reporter: Steven Hawkins > Assignee: Van Halbert > Fix For: 8.4.1 > > > There should be quickstarts (or an expanded dataroles quickstart) covering row based security, column masking, and possibly the use of a udf that uses the subject, a credential mapping security domain, or credential pass-through to highlight other common scenarios. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 6 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)

9 years, 6 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)

9 years, 6 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)

9 years, 6 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)

9 years, 6 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)

9 years, 6 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)

9 years, 6 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)

9 years, 6 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)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3220) Datafederation quick start needs materialization teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT changed to match docs

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3220?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3220. --------------------------------- > Datafederation quick start needs materialization teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT changed to match docs > ----------------------------------------------------------------------------------------------------------- > > Key: TEIID-3220 > URL: https://issues.jboss.org/browse/TEIID-3220 > Project: Teiid > Issue Type: Enhancement > Components: Quick Starts > Affects Versions: 8.7.1, 8.10 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > Fix For: 8.10 > > > The data federation quick start does not demonstrate the same way of loading in the materialized table by executing multiple statements when "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" is performed, as the doc's do (based on the latest changes). > It should now use the following to work like the doc's prescribe: > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute accounts.native(''ALTER TABLE h2_stock_mat RENAME TO h2_stock_mat_temp'');execute accounts.native(''ALTER TABLE mat_stock_staging RENAME TO h2_stock_mat'');execute accounts.native(''ALTER TABLE h2_stock_mat_temp RENAME TO mat_stock_staging'');', > -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 6 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2015