February 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4005) optimization to split row value predicate into two predicates

by Johnathon Lee (JIRA)

Johnathon Lee created TEIID-4005: ------------------------------------ Summary: optimization to split row value predicate into two predicates Key: TEIID-4005 URL: https://issues.jboss.org/browse/TEIID-4005 Project: Teiid Issue Type: Enhancement Components: Query Engine Affects Versions: 8.7.4.6_2 Reporter: Johnathon Lee Assignee: Steven Hawkins Potentially an oracle query optimization issue. Row value predicate for particular tables are more performant when splitting into two in predicates. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3995) SAP HANA materialization:function loadMatView with argument invalidate set to true problem

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3995?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3995: --------------------------------------- I'm still not reproducing this. Can you provide the client code and the server log? > SAP HANA materialization:function loadMatView with argument invalidate set to true problem > ------------------------------------------------------------------------------------------ > > Key: TEIID-3995 > URL: https://issues.jboss.org/browse/TEIID-3995 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12.x > Reporter: Jan Stastny > Assignee: Steven Hawkins > > There appears to be an issue with loadMatView function. > Specifically when the function is invoked with invalidate=>'true' argument, when it is expected, that invocation of this function invalidates the current contents of the materialized view until the initiated load is completed and new data are populated. > But when calling this function as described, an error occurs: > {code:plain} > TEIID20001 The modeled datatype integer for column 0 doesn't match the runtime type "org.teiid.core.types.ArrayImpl". Please ensure that the column's modeled datatype matches the expected data. > {code} > Please note, that there is no column of type array in my schema. > There is declaration of the view: > {code:sql} > CREATE VIEW external_long_ttl ( > customer_id integer NOT NULL, > total_amount integer > ) > {code} > and the query used to load the view: > {code:sql} > "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO dv_matviews_mat_view_stage(customer_id,total_amount) SELECT CONVERT(c.id,integer) AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM dv_matviews_customers c INNER JOIN dv_matviews_orders o ON c.id = o.customer_id GROUP BY c.id;', > {code} > Complete definition of the view is: > {code:sql} > CREATE VIEW external_long_ttl ( > customer_id integer NOT NULL, > total_amount integer > ) OPTIONS ( > MATERIALIZED 'TRUE', > UPDATABLE 'FALSE', > MATERIALIZED_TABLE 'Source.JSTASTNY.dv_matviews_mat_view', > "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', > "teiid_rel:MATVIEW_STATUS_TABLE" 'Source.JSTASTNY.dv_matviews_statustable', > "teiid_rel:ON_VDB_START_SCRIPT" 'MERGE INTO dv_matviews_check_table(id,vdb_create) SELECT id, vdb_create+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';', > "teiid_rel:ON_VDB_DROP_SCRIPT" 'MERGE INTO dv_matviews_check_table(id,vdb_drop) SELECT id, vdb_drop+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';', > "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO dv_matviews_mat_view_stage(customer_id,total_amount) SELECT CONVERT(c.id,integer) AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM dv_matviews_customers c INNER JOIN dv_matviews_orders o ON c.id = o.customer_id GROUP BY c.id;', > "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'exec Source.native(''truncate table dv_matviews_mat_view_stage'');MERGE INTO dv_matviews_check_table(id,before_load) SELECT id, before_load+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';', > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'exec Source.native(''RENAME TABLE dv_matviews_mat_view_stage TO dv_matviews_mat_view_temp'');exec Source.native(''RENAME TABLE dv_matviews_mat_view TO dv_matviews_mat_view_stage'');exec Source.native(''RENAME TABLE dv_matviews_mat_view_temp TO dv_matviews_mat_view'');MERGE INTO dv_matviews_check_table(id,after_load) SELECT id, after_load+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';', > "teiid_rel:MATVIEW_ONERROR_ACTION" 'WAIT', > "teiid_rel:MATVIEW_TTL" 20000 > ) AS SELECT CONVERT(c.id,integer) AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM dv_matviews_customers c INNER JOIN dv_matviews_orders o ON c.id = o.customer_id GROUP BY c.id; > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4004) Teiid teiid-web-security project can't be built

by Jan Stastny (JIRA)

Jan Stastny created TEIID-4004: ---------------------------------- Summary: Teiid teiid-web-security project can't be built Key: TEIID-4004 URL: https://issues.jboss.org/browse/TEIID-4004 Project: Teiid Issue Type: Bug Components: Tools Reporter: Jan Stastny Assignee: Jan Stastny The project used to build custom OData WAR with different security profiles can't be compiled in maven. The problem is caused by its module database-service, which is located in ./examples/database-service/pom.xml. Maven complains, that it can't find artifact odata-web-parent, which is the parent project here. It can be resolved by specifying <relativePath>../../pom.xml</relativePath> in the database-service jar's pom.xml {code:plain} [ERROR] The build could not read 1 project -> [Help 1] [ERROR] [ERROR] The project org.jboss.teiid:database-service:[unknown-version] (/home/jstastny/gitrepo/teiid-web-security/examples/database-service/pom.xml) has 1 error [ERROR] Non-resolvable parent POM for org.jboss.teiid:database-service:[unknown-version]: Failure to find org.jboss.teiid:odata-web-parent:pom:0.0.1-SNAPSHOT in http://dvqe11.mw.lab.eng.bos.redhat.com:8081/nexus/content/repositories/r... was cached in the local repository, resolution will not be reattempted until the update interval of nexus-releases has elapsed or updates are forced and 'parent.relativePath' points at wrong local POM @ line 4, column 13 -> [Help 2] {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4003) Vertica and DB2 translators use incorrect push down of WEEK function

by Andrej Šmigala (JIRA)

[ https://issues.jboss.org/browse/TEIID-4003?page=com.atlassian.jira.plugin... ] Andrej Šmigala updated TEIID-4003: ---------------------------------- Summary: Vertica and DB2 translators use incorrect push down of WEEK function (was: Vertica translator uses incorrect push down of WEEK function) > Vertica and DB2 translators use incorrect push down of WEEK function > -------------------------------------------------------------------- > > Key: TEIID-4003 > URL: https://issues.jboss.org/browse/TEIID-4003 > Project: Teiid > Issue Type: Bug > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > Fix For: 8.12.5 > > > TEIID-3282 changed the semantics of the WEEK function to use the iso behaviour. > The Vertica database has WEEK_ISO function that returns the iso week, but the translator does not have that alias set. > This results in the query (the datevalue in question is 2000-12-31) > {code:sql} > select week(datevalue) from source.largea where intkey = 365 > {code} > to return 54, when the correct value is 52. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4003) Vertica translator uses incorrect push down of WEEK function

by Andrej Šmigala (JIRA)

[ https://issues.jboss.org/browse/TEIID-4003?page=com.atlassian.jira.plugin... ] Andrej Šmigala commented on TEIID-4003: --------------------------------------- Also noticed the same problem with the DB2 translator > Vertica translator uses incorrect push down of WEEK function > ------------------------------------------------------------ > > Key: TEIID-4003 > URL: https://issues.jboss.org/browse/TEIID-4003 > Project: Teiid > Issue Type: Bug > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > Fix For: 8.12.5 > > > TEIID-3282 changed the semantics of the WEEK function to use the iso behaviour. > The Vertica database has WEEK_ISO function that returns the iso week, but the translator does not have that alias set. > This results in the query (the datevalue in question is 2000-12-31) > {code:sql} > select week(datevalue) from source.largea where intkey = 365 > {code} > to return 54, when the correct value is 52. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4003) Vertica translator uses incorrect push down of WEEK function

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4003?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4003: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1312264 Bugzilla Update: Perform > Vertica translator uses incorrect push down of WEEK function > ------------------------------------------------------------ > > Key: TEIID-4003 > URL: https://issues.jboss.org/browse/TEIID-4003 > Project: Teiid > Issue Type: Bug > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > Fix For: 8.12.5 > > > TEIID-3282 changed the semantics of the WEEK function to use the iso behaviour. > The Vertica database has WEEK_ISO function that returns the iso week, but the translator does not have that alias set. > This results in the query (the datevalue in question is 2000-12-31) > {code:sql} > select week(datevalue) from source.largea where intkey = 365 > {code} > to return 54, when the correct value is 52. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4003) Vertica translator uses incorrect push down of WEEK function

by Andrej Šmigala (JIRA)

Andrej Šmigala created TEIID-4003: ------------------------------------- Summary: Vertica translator uses incorrect push down of WEEK function Key: TEIID-4003 URL: https://issues.jboss.org/browse/TEIID-4003 Project: Teiid Issue Type: Bug Reporter: Andrej Šmigala Assignee: Steven Hawkins Fix For: 8.12.5 TEIID-3282 changed the semantics of the WEEK function to use the iso behaviour. The Vertica database has WEEK_ISO function that returns the iso week, but the translator does not have that alias set. This results in the query (the datevalue in question is 2000-12-31) {code:sql} select week(datevalue) from source.largea where intkey = 365 {code} to return 54, when the correct value is 52. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4002) Configuring of JDG DSL resource adapter still requires marshaller and protobuf when using annotations to define schema

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4002?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4002: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1312196 Bugzilla Update: Perform > Configuring of JDG DSL resource adapter still requires marshaller and protobuf when using annotations to define schema > ---------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-4002 > URL: https://issues.jboss.org/browse/TEIID-4002 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.x > Reporter: Van Halbert > Assignee: Steven Hawkins > Priority: Blocker > > To improve the usability of JDG as a materialized data source, the resource-adapter needs to be changed to not require the marshaller/protobuf file when the the pojo class has the defined annotations for specifying the schema. > Currently, the marshaller(s) and protobuf are required. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4002) Configuring of JDG DSL resource adapter still requires marshaller and protobuf when using annotations to define schema

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4002?page=com.atlassian.jira.plugin... ] Van Halbert reassigned TEIID-4002: ---------------------------------- Assignee: Van Halbert (was: Steven Hawkins) > Configuring of JDG DSL resource adapter still requires marshaller and protobuf when using annotations to define schema > ---------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-4002 > URL: https://issues.jboss.org/browse/TEIID-4002 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.x > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Blocker > > To improve the usability of JDG as a materialized data source, the resource-adapter needs to be changed to not require the marshaller/protobuf file when the the pojo class has the defined annotations for specifying the schema. > Currently, the marshaller(s) and protobuf are required. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4002) Configuring of JDG DSL resource adapter still requires marshaller and protobuf when using annotations to define schema

by Van Halbert (JIRA)

Van Halbert created TEIID-4002: ---------------------------------- Summary: Configuring of JDG DSL resource adapter still requires marshaller and protobuf when using annotations to define schema Key: TEIID-4002 URL: https://issues.jboss.org/browse/TEIID-4002 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.x Reporter: Van Halbert Assignee: Steven Hawkins Priority: Blocker To improve the usability of JDG as a materialized data source, the resource-adapter needs to be changed to not require the marshaller/protobuf file when the the pojo class has the defined annotations for specifying the schema. Currently, the marshaller(s) and protobuf are required. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 8 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2016