February 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3302) Implement ST_Transform

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3302?page=com.atlassian.jira.plugin... ] Tom Arnold commented on TEIID-3302: ----------------------------------- After emailing with the maintainer I think proj4j is the way to go. Hopefully I'll have some time later this week to take a shot at this. Proj4j is not in Maven central. It seems like there's a couple of options: * Upload it to central. Is this something the "official" upstream has to do, or can anyone do it? * Submit JIRA to proxy into JBoss repos. Any advice? > Implement ST_Transform > ---------------------- > > Key: TEIID-3302 > URL: https://issues.jboss.org/browse/TEIID-3302 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: spatial > > Implement [ST_Transform|http://postgis.org/docs/ST_Transform.html] system function. This would be used to transform geometry between different coordinate systems. This needs SPATIAL_REF_SYS table and a supporting library. > There are a couple of options for implementing this: > * http://trac.osgeo.org/proj4j/ - Port of the C library used by PostGIS. Fewest dependencies and should keep us close to PostGIS in capabilities. There will be a little boilerplate to interface with JTS. > * http://docs.geotools.org/latest/userguide/library/referencing/index.html - GeoTools referencing module. I think we would need to develop a simple plugin to interface with our SPATIAL_REF_SYS table. GeoTools is active and has good docs, but brings in a lot of dependencies. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3307) PostgreSQL: Implement Teiid spatial

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3307?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3307. ----------------------------------- Resolution: Done Added the supports and a property to set the postgis version. The supports are based upon postgis 1.3 and later. There is also a postgis-jdbc library that makes the PGGeometry type available, but for now it seems best to stick to the default wkb read logic. They also assume a default srid of -1, rather than following the spec. I'm not sure if we'll need to address that. > PostgreSQL: Implement Teiid spatial > ----------------------------------- > > Key: TEIID-3307 > URL: https://issues.jboss.org/browse/TEIID-3307 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: spatial > Fix For: 8.10 > > > Add support for GEOMETRY and the ST_* functions to the PostgreSQL translator. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3318) Support dynamically configuring the JDG protobuf schema

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3318?page=com.atlassian.jira.plugin... ] Work on TEIID-3318 started by Van Halbert. ------------------------------------------ > Support dynamically configuring the JDG protobuf schema > ------------------------------------------------------- > > Key: TEIID-3318 > URL: https://issues.jboss.org/browse/TEIID-3318 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.7.1, 8.10 > Reporter: Van Halbert > Assignee: Van Halbert > > Need to add the ability to dynamically configure the protobuf schema. A > snip-it from an example: > // generate and register a Protobuf schema and marshallers based on Note class and the referenced classes (User class) > ProtoSchemaBuilder protoSchemaBuilder = new ProtoSchemaBuilder(); > String generatedSchema = protoSchemaBuilder > .fileName("sample_schema.proto") > .packageName("sample_package") > .addClass(Note.class) > .build(serCtx); > This would change the need for the user to implement marshallers. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3220) Datafederation quick start needs materialization teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT changed to match docs

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3220?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-3220: ------------------------------- Git Pull Request: https://github.com/teiid/teiid-quickstarts/pull/89 (was: https://github.com/teiid/teiid-quickstarts/commit/6b2cb7a62a0b3f170d2b624...) > Datafederation quick start needs materialization teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT changed to match docs > ----------------------------------------------------------------------------------------------------------- > > Key: TEIID-3220 > URL: https://issues.jboss.org/browse/TEIID-3220 > Project: Teiid > Issue Type: Enhancement > Components: Quick Starts > Affects Versions: 8.7.1, 8.10 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > Fix For: 8.10 > > > The data federation quick start does not demonstrate the same way of loading in the materialized table by executing multiple statements when "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" is performed, as the doc's do (based on the latest changes). > It should now use the following to work like the doc's prescribe: > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute accounts.native(''ALTER TABLE h2_stock_mat RENAME TO h2_stock_mat_temp'');execute accounts.native(''ALTER TABLE mat_stock_staging RENAME TO h2_stock_mat'');execute accounts.native(''ALTER TABLE h2_stock_mat_temp RENAME TO mat_stock_staging'');', > -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3220) Datafederation quick start needs materialization teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT changed to match docs

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3220?page=com.atlassian.jira.plugin... ] Work on TEIID-3220 stopped by Van Halbert. ------------------------------------------ > Datafederation quick start needs materialization teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT changed to match docs > ----------------------------------------------------------------------------------------------------------- > > Key: TEIID-3220 > URL: https://issues.jboss.org/browse/TEIID-3220 > Project: Teiid > Issue Type: Enhancement > Components: Quick Starts > Affects Versions: 8.7.1, 8.10 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > Fix For: 8.10 > > > The data federation quick start does not demonstrate the same way of loading in the materialized table by executing multiple statements when "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" is performed, as the doc's do (based on the latest changes). > It should now use the following to work like the doc's prescribe: > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute accounts.native(''ALTER TABLE h2_stock_mat RENAME TO h2_stock_mat_temp'');execute accounts.native(''ALTER TABLE mat_stock_staging RENAME TO h2_stock_mat'');execute accounts.native(''ALTER TABLE h2_stock_mat_temp RENAME TO mat_stock_staging'');', > -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3220) Datafederation quick start needs materialization teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT changed to match docs

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3220?page=com.atlassian.jira.plugin... ] Van Halbert resolved TEIID-3220. -------------------------------- Fix Version/s: 8.10 Resolution: Done > Datafederation quick start needs materialization teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT changed to match docs > ----------------------------------------------------------------------------------------------------------- > > Key: TEIID-3220 > URL: https://issues.jboss.org/browse/TEIID-3220 > Project: Teiid > Issue Type: Enhancement > Components: Quick Starts > Affects Versions: 8.7.1, 8.10 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > Fix For: 8.10 > > > The data federation quick start does not demonstrate the same way of loading in the materialized table by executing multiple statements when "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" is performed, as the doc's do (based on the latest changes). > It should now use the following to work like the doc's prescribe: > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute accounts.native(''ALTER TABLE h2_stock_mat RENAME TO h2_stock_mat_temp'');execute accounts.native(''ALTER TABLE mat_stock_staging RENAME TO h2_stock_mat'');execute accounts.native(''ALTER TABLE h2_stock_mat_temp RENAME TO mat_stock_staging'');', > -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3220) Datafederation quick start needs materialization teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT changed to match docs

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3220?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-3220: ------------------------------- Git Pull Request: https://github.com/teiid/teiid-quickstarts/commit/6b2cb7a62a0b3f170d2b624... > Datafederation quick start needs materialization teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT changed to match docs > ----------------------------------------------------------------------------------------------------------- > > Key: TEIID-3220 > URL: https://issues.jboss.org/browse/TEIID-3220 > Project: Teiid > Issue Type: Enhancement > Components: Quick Starts > Affects Versions: 8.7.1, 8.10 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > > The data federation quick start does not demonstrate the same way of loading in the materialized table by executing multiple statements when "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" is performed, as the doc's do (based on the latest changes). > It should now use the following to work like the doc's prescribe: > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute accounts.native(''ALTER TABLE h2_stock_mat RENAME TO h2_stock_mat_temp'');execute accounts.native(''ALTER TABLE mat_stock_staging RENAME TO h2_stock_mat'');execute accounts.native(''ALTER TABLE h2_stock_mat_temp RENAME TO mat_stock_staging'');', > -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3169) Update infinispan-cache translator to use DSLQuery in library mode

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3169?page=com.atlassian.jira.plugin... ] Van Halbert resolved TEIID-3169. -------------------------------- Fix Version/s: 8.7.1 8.10 Resolution: Done This was fixed when TEIID-3137 was completed. > Update infinispan-cache translator to use DSLQuery in library mode > ------------------------------------------------------------------ > > Key: TEIID-3169 > URL: https://issues.jboss.org/browse/TEIID-3169 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.7.1, 8.10 > > > The curent lucene query logic needs to be upgraded to use the DSL query logic to perform searches on the cache when in library mode. This logic is currently being used in the infinispan-cache-dsl translator. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3288) Upgrade JDG DSL querying using hotrod client over protobuffers to JDG 6.4

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3288?page=com.atlassian.jira.plugin... ] Van Halbert resolved TEIID-3288. -------------------------------- Resolution: Done Commits have pushed to both 8.7.x and 8.10 > Upgrade JDG DSL querying using hotrod client over protobuffers to JDG 6.4 > ------------------------------------------------------------------------- > > Key: TEIID-3288 > URL: https://issues.jboss.org/browse/TEIID-3288 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors, Quick Starts > Affects Versions: 8.7.1, 8.10 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.7.1, 8.10 > > > Upgrade the JDG DSL remote hotrod client over protobuffers from the JDG 6.3 tech preview to JDG 6.4. > This upgrade will allow user to specify what's query able using annotations and will eliminate the dependency protobuf jar. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3288) Upgrade JDG DSL querying using hotrod client over protobuffers to JDG 6.4

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3288?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-3288: ------------------------------- Fix Version/s: 8.10 > Upgrade JDG DSL querying using hotrod client over protobuffers to JDG 6.4 > ------------------------------------------------------------------------- > > Key: TEIID-3288 > URL: https://issues.jboss.org/browse/TEIID-3288 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors, Quick Starts > Affects Versions: 8.7.1, 8.10 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.7.1, 8.10 > > > Upgrade the JDG DSL remote hotrod client over protobuffers from the JDG 6.3 tech preview to JDG 6.4. > This upgrade will allow user to specify what's query able using annotations and will eliminate the dependency protobuf jar. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 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 February 2015