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