August 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4396) Missing images in the Admin section of the documentation

by Patrick McElreavy (JIRA)

Patrick McElreavy created TEIID-4396: ---------------------------------------- Summary: Missing images in the Admin section of the documentation Key: TEIID-4396 URL: https://issues.jboss.org/browse/TEIID-4396 Project: Teiid Issue Type: Bug Components: Documentation Affects Versions: 9.0.2 Reporter: Patrick McElreavy Assignee: Steven Hawkins Priority: Minor Section "Profile View" links to image "images/author/download/attachments/18646076/webconsole2.png" Section "Runtime View" links to image "images/author/download/attachments/18646076/webconsole1.png" Both these images are missing. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4353) Create a teiid feature pack

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-4353?page=com.atlassian.jira.plugin... ] Kylin Soong resolved TEIID-4353. -------------------------------- Resolution: Done https://github.com/kylinsoong/wildfly-swarm-teiid/tree/master/feature-pack > Create a teiid feature pack > --------------------------- > > Key: TEIID-4353 > URL: https://issues.jboss.org/browse/TEIID-4353 > Project: Teiid > Issue Type: Sub-task > Components: Embedded > Affects Versions: 9.x > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 9.2 > > > Seems feature pack are necessary to build swarm jar, as below > * wildfly-feature-pack - https://github.com/wildfly/wildfly/tree/master/feature-pack > * wildfly-servlet-feature-pack - https://github.com/wildfly/wildfly/tree/master/servlet-feature-pack > * wildfly-core-feature-pack - https://github.com/wildfly/wildfly-core/tree/master/core-feature-pack > * wildfly-camel-feature-pack - https://mvnrepository.com/artifact/org.wildfly.camel/wildfly-camel-featur... > The feature pack contain the module structures, be used in swarm to build modules in swarm jar, above feature packs are frequently used in wildfly swarm, so far, base on my investigate, it seems a teiid feature pack are necessary to develop wildfly-swarm-teiid. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4395) Oracle translator should pushdown clob conversion

by Tom Arnold (JIRA)

Tom Arnold created TEIID-4395: --------------------------------- Summary: Oracle translator should pushdown clob conversion Key: TEIID-4395 URL: https://issues.jboss.org/browse/TEIID-4395 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 9.0.2 Reporter: Tom Arnold Assignee: Steven Hawkins We have an "attributes" table defined like this {code:sql} CREATE TABLE "ATTRS" ( NAME varchar2(50) NOT NULL, ATTR_NAME varchar2(50) NOT NULL, ATTR_VALUE clob, CONSTRAINT ATTRS_PK PRIMARY KEY (NAME,ATTR_NAME) ); {code} The value column is unfortunately defined as a clob, but most of the data is small enough to fit in varchar (4000 chars). We have a somewhat complex query that ends up grouping by the clob value and with Teiid it is causing N-many queries. Simplified to this {code:sql} select cast(attr_value as varchar) from attrs {code} {code} ProjectNode + Relational Node ID:0 + Output Columns:expr1 (string) + Statistics: 0: Node Output Rows: 293 1: Node Next Batch Process Time: 5 2: Node Cumulative Next Batch Process Time: 5 3: Node Cumulative Process Time: 11 4: Node Next Batch Calls: 2 5: Node Blocks: 1 + Cost Estimates:Estimated Node Cardinality: 293.0 + Child 0: AccessNode + Relational Node ID:1 + Output Columns:ATTR_VALUE (clob) + Statistics: 0: Node Output Rows: 293 1: Node Next Batch Process Time: 0 2: Node Cumulative Next Batch Process Time: 0 3: Node Cumulative Process Time: 6 4: Node Next Batch Calls: 2 5: Node Blocks: 1 + Cost Estimates:Estimated Node Cardinality: 293.0 + Query:SELECT g_0.ATTR_VALUE FROM foo.ATTRS AS g_0 + Model Name:foo + Select Columns:convert(foo.ATTRS.ATTR_VALUE, varchar) + Data Bytes Sent:6783 + Planning Time:2 {code} Ideally on Oracle it would just get pushed down like this {code:sql} SELECT TO_CHAR(g_0.ATTR_VALUE) FROM foo.ATTRS AS g_0 {code} >From looking in the Oracle translator it looks like it should do this already... I added a test case which passes, but the plan seems to disagree. {code:java} @Test public void testClobToString() throws Exception { Column column = new Column(); column.setNativeType("CLOB"); column.setNameInSource("dt"); helpTest(LANG_FACTORY.createColumnReference("dt", LANG_FACTORY.createNamedTable("x", null, null), column, Clob.class), "varchar", "to_char(x.dt)"); //$NON-NLS-1$ //$NON-NLS-2$ } {code} As a workaround I added a CLOB_TO_CHAR foreign function in the model DDL (using teiid_rel:native-query 'TO_CHAR($1)') and changed my query to use that instead of cast, but I'd prefer to not have to do that in the long term. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4278) MySQL 5 should support distinct aggregates

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4278?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4278: ------------------------------------------------ jolee(a)redhat.com changed the Status of [bug 1349562|https://bugzilla.redhat.com/show_bug.cgi?id=1349562] from ASSIGNED to MODIFIED > MySQL 5 should support distinct aggregates > ------------------------------------------ > > Key: TEIID-4278 > URL: https://issues.jboss.org/browse/TEIID-4278 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.8.6_2 > > > Older versions of mysql only supported distinct count, but later versions supported distinct with all relevant aggregates. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4394) Impala Translator - add pushdown support for window functions

by Don Krapohl (JIRA)

[ https://issues.jboss.org/browse/TEIID-4394?page=com.atlassian.jira.plugin... ] Don Krapohl updated TEIID-4394: ------------------------------- Git Pull Request: https://github.com/teiid/teiid/pull/790 > Impala Translator - add pushdown support for window functions > ------------------------------------------------------------- > > Key: TEIID-4394 > URL: https://issues.jboss.org/browse/TEIID-4394 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 9.0.2 > Reporter: Don Krapohl > Assignee: Steven Hawkins > Labels: Impala_Translator > > Cloudera Impala supports window functions per http://www.cloudera.com/documentation/archive/impala/2-x/2-1-x/topics/imp... > As a query executor I need to be able to push down window functions into Impala. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4394) Impala Translator - add pushdown support for window functions

by Don Krapohl (JIRA)

Don Krapohl created TEIID-4394: ---------------------------------- Summary: Impala Translator - add pushdown support for window functions Key: TEIID-4394 URL: https://issues.jboss.org/browse/TEIID-4394 Project: Teiid Issue Type: Feature Request Components: Misc. Connectors Affects Versions: 9.0.2 Reporter: Don Krapohl Assignee: Steven Hawkins Cloudera Impala supports window functions per http://www.cloudera.com/documentation/archive/impala/2-x/2-1-x/topics/imp... As a query executor I need to be able to push down window functions into Impala. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4393) Add new Geospatial functions

by Van Halbert (JIRA)

Van Halbert created TEIID-4393: ---------------------------------- Summary: Add new Geospatial functions Key: TEIID-4393 URL: https://issues.jboss.org/browse/TEIID-4393 Project: Teiid Issue Type: Feature Request Components: Server Affects Versions: 8.12.x, 9.x Reporter: Van Halbert Assignee: Steven Hawkins Adding a list of geospatial features to be added. Used the following specification: https://portal.opengeospatial.org/files/?artifact_id=829 st_Dimension st_GeometryType st_IsEmpty st_IsSimple st_Boundary st_Envelope st_X st_Y st_StartPoint st_EndPoint st_Boundary st_Boundary st_Length st_NumPoints st_PointN st_Centroid st_PointOnSurface st_Area st_ExteriorRing st_NumInteriorRings st_InteriorRingN st_NumGeometries st_GeometryN st_IsClosed st_Length st_Centroid st_PointOnSurface st_Area st_Within st_Relate st_Intersection st_Difference st_Union st_SymmetricDifference st_Buffer st_ConvexHull -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4392) Expand star support

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4392?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4392. ----------------------------------- Resolution: Done Added the * construct along with some additional correctness checks and minor refactorings around the projected column class. > Expand star support > ------------------- > > Key: TEIID-4392 > URL: https://issues.jboss.org/browse/TEIID-4392 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > The * construct will currently produce a null pointer exception. It should be supported if possible. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4323) Add support for first/last/absolute/relative "FETCH " syntax

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4323?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4323: ------------------------------------------------ jolee(a)redhat.com changed the Status of [bug 1353933|https://bugzilla.redhat.com/show_bug.cgi?id=1353933] from ASSIGNED to MODIFIED > Add support for first/last/absolute/relative "FETCH " syntax > ------------------------------------------------------------ > > Key: TEIID-4323 > URL: https://issues.jboss.org/browse/TEIID-4323 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.8.6_2 > > > Add Support for the below FETCH syntax: > FETCH LAST FROM cursor_name > FETCH ABSOLUTE fetch_when FROM cursor_name > FETCH RELATIVE fetch_when FROM cursor_name > FETCH FIRST FROM cursor_name -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4238) Remove need for quotes around cursor name declarations/fetches

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4238?page=com.atlassian.jira.plugin... ] Johnathon Lee closed TEIID-4238. -------------------------------- Resolution: Done > Remove need for quotes around cursor name declarations/fetches > -------------------------------------------------------------- > > Key: TEIID-4238 > URL: https://issues.jboss.org/browse/TEIID-4238 > Project: Teiid > Issue Type: Enhancement > Components: ODBC > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.8.6_2 > > > Attempting to declare a cursor without quotes results in an error similar to[1]. The quotes should be optional except in special cases, as this seems to match later standards (SQL2003). Performing fetch operations against the cursor have the same issue, where if the cursorname is not quoted, parsing errors occur. > [1] Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]DECLARE[*] cursorname CURSOR" at line 1, column 1. > Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 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 August 2016