July 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4960) Problems when using External Materialized Views

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4960?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4960: --------------------------------- Fix Version/s: 8.12.12.6_3 > Problems when using External Materialized Views > ----------------------------------------------- > > Key: TEIID-4960 > URL: https://issues.jboss.org/browse/TEIID-4960 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 9.3 > Environment: * Teiid Server 9.3.0 > * Wildfly 10 > * Mysql 5.7.18 > Reporter: Pedro Inácio > Assignee: Steven Hawkins > Fix For: 10.0, 9.3.1, 9.2.5, 8.12.12.6_3 > > Attachments: server.log > > > The following problem occurs when, apparently, we have two views where one depend on another, and also we use External Materialization. > The dependent view is never updated due to a "Transaction already associated with request." exception. > Logs attached. > The error: > {panel:title=The exception in logs} > 2017-06-14 13:51:51,753 WARN [org.teiid.MATVIEWS] (Worker14_QueryProcessorQueue365) Hlbq3jmDWXNl org.teiid.jdbc.TeiidSQLException: TEIID30328 Unable to evaluate mvstatus('NumberingPlan', 'numbering_plan'): TEIID30384 Error while evaluating function mvstatus > 2017-06-14 13:52:51,803 INFO [org.teiid.MATVIEWS] (Worker14_QueryProcessorQueue368) XAtcLA8RBrLm Materialization of view NumberingPlanRaw.numbering_plan_raw started. > 2017-06-14 13:52:51,867 ERROR [org.teiid.PROCESSOR] (Worker14_QueryProcessorQueue372) XAtcLA8RBrLm TEIID30019 Unexpected exception for request XAtcLA8RBrLm.-2514910280603581440: java.lang.AssertionError: Transaction already associated with request. > {panel} > The VDB: > {code:xml} > <model name="MnomMaterialized" type="PHYSICAL"> > <property name="importer.useFullSchemaName" value="false"/> > <property name="query-timeout" value="600000"/> > <source name="MnomMaterializedView" translator-name="mysql-override" connection-jndi-name="java:/mnomDs"/> > </model> > > <model name="NumberingPlanCsvData"> > <source name="numberingPlanCsv-connector" translator-name="file" connection-jndi-name="java:/numberingPlanCsvDs"/> > </model> > <model name="NumberingPlan" type="VIRTUAL"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW numbering_plan ( > id integer PRIMARY KEY, > global_title varchar(20) > ) > OPTIONS( > MATERIALIZED 'TRUE', > UPDATABLE 'TRUE', > MATERIALIZED_TABLE 'MnomMaterialized.numbering_plan_cache', > "teiid_rel:MATVIEW_TTL" 86400000, > "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', > "teiid_rel:MATVIEW_LOADNUMBER_COLUMN" 'LoadNumber', > "teiid_rel:MATVIEW_STATUS_TABLE" 'MnomMaterialized.status' > ) > AS > SELECT ROW_NUMBER() OVER (ORDER BY cns) as id, > cns > FROM (EXEC NumberingPlanCsvData.getTextFiles('NumberingPlan.csv')) AS f, > TEXTTABLE(f.file COLUMNS cns string DELIMITER ';' SKIP 1) AS A; > > ]]> > </metadata> > </model> > > <model name="NumberingPlanRaw" type="VIRTUAL"> > <metadata type="DDL"> > <![CDATA[ > CREATE VIEW numbering_plan_raw ( > id integer PRIMARY KEY, > global_title varchar(20) > ) > OPTIONS( > MATERIALIZED 'TRUE', > UPDATABLE 'FALSE', > MATERIALIZED_TABLE 'MnomMaterialized.numbering_plan_raw_cache', > "teiid_rel:MATVIEW_TTL" 86400000, > "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', > "teiid_rel:MATVIEW_LOADNUMBER_COLUMN" 'LoadNumber', > "teiid_rel:MATVIEW_STATUS_TABLE" 'MnomMaterialized.status' > ) > AS > SELECT ROW_NUMBER() OVER (ORDER BY network) as id, > global_title > FROM numbering_plan np; > > ]]> > </metadata> > </model> > </model> > {code} > The Materialized table: > {code:sql} > CREATE TABLE status ( > VDBName VARCHAR(50) NOT NULL, > VDBVersion VARCHAR(50) NOT NULL, > SchemaName VARCHAR(50) NOT NULL, > Name VARCHAR(256) NOT NULL, > TargetSchemaName VARCHAR(50), > TargetName VARCHAR(256) NOT NULL, > Valid BOOLEAN NOT NULL, > LoadState VARCHAR(25) NOT NULL, > Cardinality BIGINT, > Updated TIMESTAMP NOT NULL, > LoadNumber BIGINT NOT NULL, > NodeName varchar(25) not null, > StaleCount BIGINT, > PRIMARY KEY (VDBName , VDBVersion , SchemaName , Name) > ); > CREATE TABLE numbering_plan_cache ( > id integer, > global_title varchar(20), > LoadNumber BIGINT, > PRIMARY KEY(id) > ); > {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4866) Enhance SQL Alchemy integration to work with Superset

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4866?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4866: ---------------------------------- Fix Version/s: 8.12.x-6.4 > Enhance SQL Alchemy integration to work with Superset > ----------------------------------------------------- > > Key: TEIID-4866 > URL: https://issues.jboss.org/browse/TEIID-4866 > Project: Teiid > Issue Type: Sub-task > Components: ODBC > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.3, 8.12.x-6.4 > > > Superset (previously Caravel) integration allows for an expanded set of sources, which was requested https://github.com/airbnb/superset/issues/241 > After some initial testing it looks like we still have some type and other issues to address. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3792) Add support for searching in array types

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3792?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3792. --------------------------------- Resolution: Done > Add support for searching in array types > ---------------------------------------- > > Key: TEIID-3792 > URL: https://issues.jboss.org/browse/TEIID-3792 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12.x-6.4, 9.0 > > > We should support a simple syntax for searching within an array, such as the quantified comparison and/or a function to get the index of a value in an array. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4710) Request id conflict with CommandContext connection

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4710?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4710: ---------------------------------- Fix Version/s: 8.12.x-6.4 > Request id conflict with CommandContext connection > -------------------------------------------------- > > Key: TEIID-4710 > URL: https://issues.jboss.org/browse/TEIID-4710 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0.6, 9.2, 9.1.3, 8.12.x-6.4 > > > When using the connection from the command context it executes within the context of the current session - but is not ensuring non-conflicting request ids are being used. This means that the current execution can be replaced or seemingly closed. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4578) Create SqlAlchemy Dialect for Teiid

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4578?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4578: ---------------------------------- Fix Version/s: 8.12.x-6.4 > Create SqlAlchemy Dialect for Teiid > ----------------------------------- > > Key: TEIID-4578 > URL: https://issues.jboss.org/browse/TEIID-4578 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors, Tooling > Affects Versions: 9.1.1 > Reporter: Salvatore Incandela > Assignee: Steven Hawkins > Fix For: 9.3, 8.12.x-6.4 > > > Create SqlAlchemy Dialect for Teiid > http://www.sqlalchemy.org/ > http://docs.sqlalchemy.org/en/latest/dialects/ -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3792) Add support for searching in array types

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3792?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-3792: ----------------------------------- > Add support for searching in array types > ---------------------------------------- > > Key: TEIID-3792 > URL: https://issues.jboss.org/browse/TEIID-3792 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.x-6.4 > > > We should support a simple syntax for searching within an array, such as the quantified comparison and/or a function to get the index of a value in an array. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3792) Add support for searching in array types

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3792?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3792: ---------------------------------- Fix Version/s: 8.12.x-6.4 > Add support for searching in array types > ---------------------------------------- > > Key: TEIID-3792 > URL: https://issues.jboss.org/browse/TEIID-3792 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.x-6.4 > > > We should support a simple syntax for searching within an array, such as the quantified comparison and/or a function to get the index of a value in an array. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4838) View with a union that projects nulls fails to resolve properly

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4838?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4838: ---------------------------------- Fix Version/s: 8.12.x-6.4 > View with a union that projects nulls fails to resolve properly > --------------------------------------------------------------- > > Key: TEIID-4838 > URL: https://issues.jboss.org/browse/TEIID-4838 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.3, 8.12.x-6.4, 9.2.4 > > > Accessing a view defined as: > create view v (col string[]) as select null union all select null > Results in an exception: > org.teiid.core.TeiidRuntimeException: TEIID30447 org.teiid.api.exception.query.QueryResolverException: TEIID30082 Expected value of type 'null' but 'null' is of type 'string[]' and no implicit conversion is available. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4493) Add support for integration with qgis

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4493?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4493: ---------------------------------- Fix Version/s: 8.12.x-6.4 > Add support for integration with qgis > -------------------------------------- > > Key: TEIID-4493 > URL: https://issues.jboss.org/browse/TEIID-4493 > Project: Teiid > Issue Type: Enhancement > Components: Documentation, Grammar, Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.2, 8.12.x-6.4 > > > Similar to our support for GeoServer, we should support qgis integration if possible. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4147) matpg_datatype should include more type mappings

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4147?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4147: ---------------------------------- Fix Version/s: 8.12.x-6.4 > matpg_datatype should include more type mappings > ------------------------------------------------ > > Key: TEIID-4147 > URL: https://issues.jboss.org/browse/TEIID-4147 > Project: Teiid > Issue Type: Bug > Components: ODBC > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.x-6.4 > > > matpg_datatype is missing mappings for varbinary and the single dimension array types in pg_type. We may need to consider using the original pg type names rather than the Teiid types names - at least for array handling and so clients there may be built-in expectations around basic types. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 11 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2017