March 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4594) Add ability to read Parquet Files

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4594?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4594: ---------------------------------- Fix Version/s: Open To Community 10.x (was: 9.3) > Add ability to read Parquet Files > --------------------------------- > > Key: TEIID-4594 > URL: https://issues.jboss.org/browse/TEIID-4594 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 9.2 > Reporter: Van Halbert > Fix For: Open To Community, 10.x > > > Integration with Parquet files on Gluster is an important requirement. RADAnalytics will be accessing data from Parquet which is a common file format for Spark. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

9 years

1
0
0 / 0

[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)

9 years

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)

9 years

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)

9 years

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)

9 years

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)

9 years

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)

9 years

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)

9 years

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)

9 years

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)

9 years

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2017