July 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4330) Better planning with chained makedep scenarios

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4330?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4330: --------------------------------------- Added an option to make the grouping of source queries in joins less aggressive - especially in make dep scenarios. This allows more of the join planning to be performed by cost based analysis. Still need to update the docs. > Better planning with chained makedep scenarios > ---------------------------------------------- > > Key: TEIID-4330 > URL: https://issues.jboss.org/browse/TEIID-4330 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > Plans with an implied series of make dep may not have the hint honored as intended. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4332) Enhance costing to better guess at ndv

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4332: ------------------------------------- Summary: Enhance costing to better guess at ndv Key: TEIID-4332 URL: https://issues.jboss.org/browse/TEIID-4332 Project: Teiid Issue Type: Quality Risk Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.1 Our logic for determining ndv is mostly ad hoc and varies greatly depending upon the position in the plan. This needs to be more standardized and based upon consistent assumptions - also additional information such as predicates and foreign keys should influence the calculation. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4320) Costing calculation issues

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4320?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4320. ----------------------------------- Resolution: Done Corrected the issues highlighted. TEIID-4332 will address more changes. > Costing calculation issues > -------------------------- > > Key: TEIID-4320 > URL: https://issues.jboss.org/browse/TEIID-4320 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 9.1, 8.13.6, 9.0.1 > > > When determining if a dependent join should be used we'll rule out too many scenarios based upon requiring additional ndv info - when that can be determined from cardinality alone. Also we are inappropriately assuming key usage in predicate costing - as it does not consider the node which may not represent a single table. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4331) Use of st_geomfromText wrapped around a UDF fails.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4331?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4331: --------------------------------------- The ST_POINT function here is wrong. It is single quoting the string when that is not needed. What is happening though is that the WKTParser that we're using does not throw an exception when it fails to parse and instead returns a null that we then fail with an NPE (which should be in your full stacktrace). So I'll use this issue to address the failure on invalid text. > Use of st_geomfromText wrapped around a UDF fails. > -------------------------------------------------- > > Key: TEIID-4331 > URL: https://issues.jboss.org/browse/TEIID-4331 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.x > Reporter: Tom Johnston > Assignee: Steven Hawkins > Attachments: gis-1.0.0.jar > > -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4331) Use of st_geomfromText wrapped around a UDF fails.

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4331?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4331: ------------------------------------ select voseqno,Latitude, Longitude, ST_MakePoint( longitude,latitude) /* ,st_geomfromtext(ST_MakePoint( longitude,latitude)) as GeoSpatial */ from "Sybase_PostFixProfile"."VERTICAL_OBSTRUCTION" where voseqno = '2963512' works but if I un-comment the last column I get this: Error: TEIID30328 Remote org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate st_geomfromText(ST_MakePoint(Sybase_PostFixProfile.VERTICAL_OBSTRUCTION.Longitude, Sybase_PostFixProfile.VERTICAL_OBSTRUCTION.Latitude)): TEIID30384 Error while evaluating function st_geomfromtext SQLState: 50000 ErrorCode: 30328 > Use of st_geomfromText wrapped around a UDF fails. > -------------------------------------------------- > > Key: TEIID-4331 > URL: https://issues.jboss.org/browse/TEIID-4331 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.x > Reporter: Tom Johnston > Assignee: Steven Hawkins > Attachments: gis-1.0.0.jar > > -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4331) Use of st_geomfromText wrapped around a UDF fails.

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4331?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-4331: ------------------------------- Affects Version/s: 8.12.x > Use of st_geomfromText wrapped around a UDF fails. > -------------------------------------------------- > > Key: TEIID-4331 > URL: https://issues.jboss.org/browse/TEIID-4331 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.x > Reporter: Tom Johnston > Assignee: Steven Hawkins > Attachments: gis-1.0.0.jar > > -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4331) Use of st_geomfromText wrapped around a UDF fails.

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4331?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4331: ------------------------------------ {code} public class MakePoint { public static final double NULL_ORDINATE = Double.NaN; public static Clob createPoint(double x, double y) { return new ClobImpl("'POINT(" + String.valueOf(x) + " " + String.valueOf(y) + ")'"); } public static Clob createPoint(double x, double y, double z) { return new ClobImpl("'POINT(" + String.valueOf(x) + " " + String.valueOf(y) + " " + NULL_ORDINATE + ")'"); } } {code} > Use of st_geomfromText wrapped around a UDF fails. > -------------------------------------------------- > > Key: TEIID-4331 > URL: https://issues.jboss.org/browse/TEIID-4331 > Project: Teiid > Issue Type: Bug > Reporter: Tom Johnston > Assignee: Steven Hawkins > Attachments: gis-1.0.0.jar > > -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4331) Use of st_geomfromText wrapped around a UDF fails.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4331?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4331: --------------------------------------- Please provide the Teiid version, the source of the udf, and the query that you are using. > Use of st_geomfromText wrapped around a UDF fails. > -------------------------------------------------- > > Key: TEIID-4331 > URL: https://issues.jboss.org/browse/TEIID-4331 > Project: Teiid > Issue Type: Bug > Reporter: Tom Johnston > Assignee: Steven Hawkins > Attachments: gis-1.0.0.jar > > -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4331) Use of st_geomfromText wrapped around a UDF fails.

by Tom Johnston (JIRA)

[ https://issues.jboss.org/browse/TEIID-4331?page=com.atlassian.jira.plugin... ] Tom Johnston updated TEIID-4331: -------------------------------- Steps to Reproduce: I have a UDF that returns a POINT if I call st_geomfromText like such st_geomfromText(ST_MakePoint( longitude,latitude)) It fails with : 10:47:31,011 WARN [org.teiid.PROCESSOR] (Worker31_QueryProcessorQueue813) TEIID30020 Processing exception for request 8nEl2/1mNvmP.18 'TEIID30328 Unable to evaluate st_geomfromText(ST_MakePoint(Longitude, Latitude)): TEIID30384 Error while evaluating function st_geomfromtext'. Originally ExpressionEvaluationException GeometryUtils.java:139. Enable more detailed logging to see the entire stacktrace. ErrorCode: 0.. SQLState: 50000 ErrorCode: 0 however, if I try st_geomfromText( concatenated with the return of St_MakePoint) it works when hard-coded. It seems that the wrapping functions with st_geomfromText is a problem? I've attached the jar gis-1.00 which is referenced by the St_MakePoint UDF was: I have a UDF that returns a POINT if I call st_geomfromText like such st_geomfromText(ST_MakePoint( longitude,latitude)) It fails with : 10:47:31,011 WARN [org.teiid.PROCESSOR] (Worker31_QueryProcessorQueue813) TEIID30020 Processing exception for request 8nEl2/1mNvmP.18 'TEIID30328 Unable to evaluate st_geomfromText(ST_MakePoint(Sybase_PostFixProfile.VERTICAL_OBSTRUCTION.Longitude, Latitude)): TEIID30384 Error while evaluating function st_geomfromtext'. Originally ExpressionEvaluationException GeometryUtils.java:139. Enable more detailed logging to see the entire stacktrace. ErrorCode: 0.. SQLState: 50000 ErrorCode: 0 however, if I try st_geomfromText( concatenated with the return of St_MakePoint) it works when hard-coded. It seems that the wrapping functions with st_geomfromText is a problem? I've attached the jar gis-1.00 which is referenced by the St_MakePoint UDF > Use of st_geomfromText wrapped around a UDF fails. > -------------------------------------------------- > > Key: TEIID-4331 > URL: https://issues.jboss.org/browse/TEIID-4331 > Project: Teiid > Issue Type: Bug > Reporter: Tom Johnston > Assignee: Steven Hawkins > Attachments: gis-1.0.0.jar > > -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4331) Use of st_geomfromText wrapped around a UDF fails.

by Tom Johnston (JIRA)

Tom Johnston created TEIID-4331: ----------------------------------- Summary: Use of st_geomfromText wrapped around a UDF fails. Key: TEIID-4331 URL: https://issues.jboss.org/browse/TEIID-4331 Project: Teiid Issue Type: Bug Reporter: Tom Johnston Assignee: Steven Hawkins Attachments: gis-1.0.0.jar -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2016