March 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4829) odata4 fails to return data on top of mongoDB view model

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4829?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4829: --------------------------------------- The error indicates issues with both the name and geoType columns. What I need to see is what the view is reporting as the length for those columns - what is shown in the properties panel when you click on those columns? > odata4 fails to return data on top of mongoDB view model > --------------------------------------------------------- > > Key: TEIID-4829 > URL: https://issues.jboss.org/browse/TEIID-4829 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.9.6_3 > Environment: Noticed in JDV 6.3.4 > Reporter: Michael Echevarria > Assignee: Steven Hawkins > Priority: Critical > Attachments: mongo-view-error.png, odata2-works.png, odata4-error.png > > > Description of problem: > Accessing either an exclusive view model or combined view model for a mongoDB datasource via odata4 results in an error. > The data returns via odata2, jdbc and preview in the designer > Version-Release number of selected component (if applicable): > JDV 6.3.4 > Actual results: > Property mapping error > Expected results: > Model data -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4829) odata4 fails to return data on top of mongoDB view model

by Michael Echevarria (JIRA)

[ https://issues.jboss.org/browse/TEIID-4829?page=com.atlassian.jira.plugin... ] Michael Echevarria commented on TEIID-4829: ------------------------------------------- The only long column is the geoCoordinates column, which is base64. The geoType column is a simple string that comes through as 'Polygon' or 'Multi-Polygon'. If you want to work with the _exact_ test data, I have a repo with the data and scripts to load it up into an out-of-the-box mongo install https://github.com/mechevarria/mongo-client > odata4 fails to return data on top of mongoDB view model > --------------------------------------------------------- > > Key: TEIID-4829 > URL: https://issues.jboss.org/browse/TEIID-4829 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.9.6_3 > Environment: Noticed in JDV 6.3.4 > Reporter: Michael Echevarria > Assignee: Steven Hawkins > Priority: Critical > Attachments: mongo-view-error.png, odata2-works.png, odata4-error.png > > > Description of problem: > Accessing either an exclusive view model or combined view model for a mongoDB datasource via odata4 results in an error. > The data returns via odata2, jdbc and preview in the designer > Version-Release number of selected component (if applicable): > JDV 6.3.4 > Actual results: > Property mapping error > Expected results: > Model data -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4830) Parsing Error when deploying VDB with "geometry" as column name

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4830?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4830: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1436306 Bugzilla Update: Perform > Parsing Error when deploying VDB with "geometry" as column name > --------------------------------------------------------------- > > Key: TEIID-4830 > URL: https://issues.jboss.org/browse/TEIID-4830 > Project: Teiid > Issue Type: Bug > Components: Grammar, Query Engine > Affects Versions: 9.3, 8.12.9.6_3 > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > Fix For: 9.3, 9.2.2 > > > The following query works correctly if run against a deployed VDB: > {code:sql} > SELECT 'a' as "geometry"; > {code} > However, the following VDB fails to deploy: > {code:xml} > <?xml version="1.0" encoding="UTF-8"?> > <vdb name="test-vdb" version="1"> > <model name="Test" type="VIRTUAL"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW test(c1 string) AS > SELECT 'a' as "geometry"; > > ]]></metadata> > </model> > </vdb> > {code} > with the error > {noformat} > TEIID31080 Test.test validation error: TEIID31100 Parsing error: Encountered "SELECT 'a' AS [*]geometry[*]" at line 1, column 15. > Was expecting: id > {noformat} > This seems to only happen when the name is "geometry", I could not find any other reserved word that would cause the same error. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4820) Move the infinispan connector project to the JDG repo

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4820?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-4820: ------------------------------- Git Pull Request: https://github.com/teiid/jdg/pull/1, https://github.com/teiid/teiid/pull/930 (was: https://github.com/teiid/jdg/pull/1) Created PR to remove from Teiid repo > Move the infinispan connector project to the JDG repo > ----------------------------------------------------- > > Key: TEIID-4820 > URL: https://issues.jboss.org/browse/TEIID-4820 > Project: Teiid > Issue Type: Task > Components: JDG Connector > Affects Versions: 9.3 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Critical > Fix For: 9.3 > > > Move the infinispan (JDG) project to the jdg repo. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4825) Google translator throws Column doesn't exist in the worksheet

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4825?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4825. ----------------------------------- Resolution: Deferred Marking with the same resolution as TEIID-4672 - for now we should assume that the translator follows the same rules as google. We'll treat the first row as a header if google does. Any other scenario will run into issues. > Google translator throws Column doesn't exist in the worksheet > -------------------------------------------------------------- > > Key: TEIID-4825 > URL: https://issues.jboss.org/browse/TEIID-4825 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.10.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Fix For: 9.3 > > Attachments: gs-export-vdb.xml, server.log-dv635cr1 > > > If sheet (WikiData9) contains only string type columns, queries to that sheet fail with 'org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Column link doesn't exist in the worksheet WikiData9' > If I added e.g. numeric or boolean column, it worked ok... -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4828) ST_GeomFromGeoJson fails for certain geometry types

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4828?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4828. ----------------------------------- Fix Version/s: 9.2.2 Resolution: Done This was caused by an issue in the geojson library. That version was updated and the databinding dependency version was corrected. There is a follow-on task to update to jts 1.14, but that can be addressed separately. > ST_GeomFromGeoJson fails for certain geometry types > --------------------------------------------------- > > Key: TEIID-4828 > URL: https://issues.jboss.org/browse/TEIID-4828 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 9.3, 8.12.10.6_3 > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > Fix For: 9.3, 9.2.2 > > > ST_GeomFromGeoJson fails to decode GeoJSON with certain geometry types. The following queries work: > {code:sql|title=Working Queries} > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('POINT (30 10)'))) > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))'))); > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('POLYGON ((35 10, 45 45, 15 40, 10 20, 35 10),(20 30, 35 35, 30 20, 20 30))'))); > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('MULTIPOLYGON (((30 20, 45 40, 10 40, 30 20)),((15 5, 40 10, 10 20, 5 10, 15 5)))'))); > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('MULTIPOLYGON (((40 40, 20 45, 45 30, 40 40)),((20 35, 10 30, 10 10, 30 5, 45 20, 20 35),(30 20, 20 15, 20 25, 30 20)))'))); > {code} > but these fail: > {code:sql|title=Failing Queries} > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('MULTIPOINT ((10 40), (40 30), (20 20), (30 10))'))); > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('MULTIPOINT (10 40, 40 30, 20 20, 30 10)'))); > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('MULTILINESTRING ((10 10, 20 20, 10 40),(40 40, 30 30, 40 20, 30 10))'))); > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('LINESTRING (30 10, 10 30, 40 40)'))); > {code} > The server log when running with master says > {noformat} > TEIID30328 Unable to evaluate ST_GeomFromGeoJson(?): TEIID30384 Error while evaluating function st_geomfromgeojson'. Originally ExpressionEvaluationException 'Conflicting property-based creators: already had explicitly marked [constructor for org.wololo.geojson.MultiPoint, annotations: {interface com.fasterxml.jackson.annotation.JsonCreator=(a)com.fasterxml.jackson.annotation.JsonCreator(mode=DEFAULT)}], encountered [constructor for org.wololo.geojson.MultiPoint, annotations: {interface com.fasterxml.jackson.annotation.JsonCreator=(a)com.fasterxml.jackson.annotation.JsonCreator(mode=DEFAULT)}]' CreatorCollector.java:304. > {noformat} > When running with latest 6.3 patch, the server log says > {noformat} > TEIID30328 Unable to evaluate ST_GeomFromGeoJson(?): TEIID30384 Error while evaluating function st_geomfromgeojson'. Originally ExpressionEvaluationException '1' BasicDeserializerFactory.java:394. > {noformat} > The difference seems to be due to different versions of jackson-databind (which also seems to be the source of the problem). -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4820) Move the infinispan connector project to the JDG repo

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4820?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-4820: ------------------------------- Git Pull Request: https://github.com/teiid/jdg/pull/1 Committed the changes that update the code to support JDG 7.1 (which is what's in the current teiid repo). > Move the infinispan connector project to the JDG repo > ----------------------------------------------------- > > Key: TEIID-4820 > URL: https://issues.jboss.org/browse/TEIID-4820 > Project: Teiid > Issue Type: Task > Components: JDG Connector > Affects Versions: 9.3 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Critical > Fix For: 9.3 > > > Move the infinispan (JDG) project to the jdg repo. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4820) Move the infinispan connector project to the JDG repo

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4820?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-4820: ------------------------------- Fix Version/s: 9.3 > Move the infinispan connector project to the JDG repo > ----------------------------------------------------- > > Key: TEIID-4820 > URL: https://issues.jboss.org/browse/TEIID-4820 > Project: Teiid > Issue Type: Task > Components: JDG Connector > Affects Versions: 9.3 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Critical > Fix For: 9.3 > > > Move the infinispan (JDG) project to the jdg repo. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4832) NullPointException in GroupingNode.initialize

by Bram Gadeyne (JIRA)

Bram Gadeyne created TEIID-4832: ----------------------------------- Summary: NullPointException in GroupingNode.initialize Key: TEIID-4832 URL: https://issues.jboss.org/browse/TEIID-4832 Project: Teiid Issue Type: Bug Affects Versions: 9.1.4 Reporter: Bram Gadeyne Assignee: Steven Hawkins When executing this query: select year(nv.variabletime) as y, case when dv.varvalue is null then 'missing' else 'wrong' end as t, count(*) as aantal_missing_or_different from wodan_derived_variables nv left join tv_retrieve_dervals dv on dv.admissionid = nv.admissionid and dv.Datetime = nv.variabletime and dv.VariableID = 30003400 where nv.variableid = 'PF' and (dv.varvalue is null or round(nv.numericvalue,0) <> round(dv.varvalue,0)) group by year(nv.variabletime), dv.varvalue is null order by y, t I get an exception: 2017-03-28 11:34:19,461 ERROR [org.teiid.PROCESSOR] (Worker440_QueryProcessorQueue34086834) vF6xRF3a6hIs TEIID30019 Unexpected exception for request vF6xRF3a6hIs.52: java.lang.NullPointerException at org.teiid.query.processor.relational.GroupingNode.initialize(GroupingNode.java:219) at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:96) at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102) at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102) at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102) at org.teiid.query.processor.relational.RelationalPlan.initialize(RelationalPlan.java:91) at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:226) at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:289) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:154) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:477) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:349) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:275) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4828) ST_GeomFromGeoJson fails for certain geometry types

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4828?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4828: --------------------------------------- I see that we have the wrong databind version in the master pom. It should be 2.5.4, not 2.4.5. With that version or even the 2.6.3 required by geojson results in the same exception, so I'll have to look at this more to see if it goes beyond just a simple dependency issue. > ST_GeomFromGeoJson fails for certain geometry types > --------------------------------------------------- > > Key: TEIID-4828 > URL: https://issues.jboss.org/browse/TEIID-4828 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 9.3, 8.12.10.6_3 > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > Fix For: 9.3 > > > ST_GeomFromGeoJson fails to decode GeoJSON with certain geometry types. The following queries work: > {code:sql|title=Working Queries} > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('POINT (30 10)'))) > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))'))); > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('POLYGON ((35 10, 45 45, 15 40, 10 20, 35 10),(20 30, 35 35, 30 20, 20 30))'))); > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('MULTIPOLYGON (((30 20, 45 40, 10 40, 30 20)),((15 5, 40 10, 10 20, 5 10, 15 5)))'))); > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('MULTIPOLYGON (((40 40, 20 45, 45 30, 40 40)),((20 35, 10 30, 10 10, 30 5, 45 20, 20 35),(30 20, 20 15, 20 25, 30 20)))'))); > {code} > but these fail: > {code:sql|title=Failing Queries} > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('MULTIPOINT ((10 40), (40 30), (20 20), (30 10))'))); > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('MULTIPOINT (10 40, 40 30, 20 20, 30 10)'))); > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('MULTILINESTRING ((10 10, 20 20, 10 40),(40 40, 30 30, 40 20, 30 10))'))); > select ST_GeomFromGeoJson(ST_AsGeoJSON(ST_GeomFromText('LINESTRING (30 10, 10 30, 40 40)'))); > {code} > The server log when running with master says > {noformat} > TEIID30328 Unable to evaluate ST_GeomFromGeoJson(?): TEIID30384 Error while evaluating function st_geomfromgeojson'. Originally ExpressionEvaluationException 'Conflicting property-based creators: already had explicitly marked [constructor for org.wololo.geojson.MultiPoint, annotations: {interface com.fasterxml.jackson.annotation.JsonCreator=(a)com.fasterxml.jackson.annotation.JsonCreator(mode=DEFAULT)}], encountered [constructor for org.wololo.geojson.MultiPoint, annotations: {interface com.fasterxml.jackson.annotation.JsonCreator=(a)com.fasterxml.jackson.annotation.JsonCreator(mode=DEFAULT)}]' CreatorCollector.java:304. > {noformat} > When running with latest 6.3 patch, the server log says > {noformat} > TEIID30328 Unable to evaluate ST_GeomFromGeoJson(?): TEIID30384 Error while evaluating function st_geomfromgeojson'. Originally ExpressionEvaluationException '1' BasicDeserializerFactory.java:394. > {noformat} > The difference seems to be due to different versions of jackson-databind (which also seems to be the source of the problem). -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2017