[JBoss JIRA] (TEIIDDES-2798) Dynamic VDB can not be generated - view model with procedure
by Matus Makovy (JIRA)
Matus Makovy created TEIIDDES-2798:
--------------------------------------
Summary: Dynamic VDB can not be generated - view model with procedure
Key: TEIIDDES-2798
URL: https://issues.jboss.org/browse/TEIIDDES-2798
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 10.0
Reporter: Matus Makovy
Attachments: DynamicProcedureProject.zip, Screen Shot 2016-03-01 at 15.33.04.png, Screen Shot 2016-03-01 at 15.34.09.png
VDB from project that is attached can not be exported to dynamic VDB.
This *doesn't work* with TD 10.0.0.*Beta3*, but it +worked+ with +Beta2+.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 2 months
[JBoss JIRA] (TEIIDDES-2745) Extension properties not imported from dynamic VDB
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2745?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2745.
----------------------------------
> Extension properties not imported from dynamic VDB
> --------------------------------------------------
>
> Key: TEIIDDES-2745
> URL: https://issues.jboss.org/browse/TEIIDDES-2745
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs, Patch Release
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Labels: release_notes, verified_jbdsis-9.0.0.Beta
> Fix For: 10.0.1, 9.2.1
>
>
> When importing a dynamic VDB containing models with extension properties, the properties are not imported.
> {code:xml}
> <?xml version="1.0" encoding="UTF-8"?>
> <vdb name="MatViewsVdb" version="1">
> <description>For testing of materialized views</description>
>
> <model name="Source">
> <source name="Source" translator-name="h2-override"
> connection-jndi-name="java:/mat-views-ds" />
> <metadata type="DDL"><![CDATA[
>
> CREATE FOREIGN TABLE customers (
> id integer,
> name string(4000),
> address string(4000),
> CONSTRAINT PK_ID PRIMARY KEY(id)
> ) OPTIONS(NAMEINSOURCE 'customer')
>
> CREATE FOREIGN TABLE orders (
> id integer,
> customer_id integer,
> amount integer,
> CONSTRAINT PK_ID PRIMARY KEY(id),
> CONSTRAINT FK_CUST FOREIGN KEY(customer_id) REFERENCES customers(id)
> ) OPTIONS(NAMEINSOURCE 'order')
> ]]>
> </metadata>
> </model>
>
> <!-- TODO: change the CONVERTs to integer once TEIIDDES-2737 is resolved -->
> <model name="ViewModel" type="VIRTUAL">
> <metadata type="DDL"><![CDATA[
> CREATE VIEW internal_short_ttl (
> customer_id integer NOT NULL,
> total_amount integer
> ) OPTIONS (MATERIALIZED 'TRUE',
> "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute Source.native(''INSERT INTO check_table(id,before_load) VALUES (''internal_short_ttl'',1) ON DUPLICATE KEY UPDATE before_load=before_load+1;'');',
> "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute Source.native(''INSERT INTO check_table(id,after_load) VALUES (''internal_short_ttl'',1) ON DUPLICATE KEY UPDATE after_load=after_load+1;'')'
> )
> AS /*+ cache(ttl:100)*/SELECT c.id AS customer_id, CONVERT(SUM(o.amount),biginteger) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id;
>
> CREATE VIEW internal_long_ttl (
> customer_id integer PRIMARY KEY,
> total_amount integer
> ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'FALSE')
> AS /*+ cache(ttl:1000 updatable)*/ SELECT c.id AS customer_id, CONVERT(SUM(o.amount),biginteger) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id;
>
> CREATE VIEW external_long_ttl (
> customer_id integer NOT NULL,
> total_amount integer
> ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'FALSE',
> MATERIALIZED_TABLE 'Source.DB.PUBLIC.MAT_VIEW',
> "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true',
> "teiid_rel:MATVIEW_STATUS_TABLE" 'Source.DB.PUBLIC.STATUS',
> "teiid_rel:ON_VDB_START_SCRIPT" 'exec Source.native(''MERGE INTO check_table(id,vdb_create) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT vdb_create from check_table WHERE id=''''external_long_ttl''''),0)+1)'');',
> "teiid_rel:ON_VDB_DROP_SCRIPT" 'exec Source.native(''MERGE INTO check_table(id,vdb_drop) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT vdb_drop from check_table WHERE id=''''external_long_ttl''''),0)+1)'');',
> "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO mat_view_stage(customer_id,total_amount) SELECT c.id AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id;',
> "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute Source.native(''truncate table mat_view_stage'');exec Source.native(''MERGE INTO check_table(id,before_load) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT before_load from check_table WHERE id=''''external_long_ttl''''),0)+1)'');',
> "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'exec Source.native(''ALTER TABLE mat_view_stage RENAME TO mat_view_temp'');exec Source.native(''ALTER TABLE mat_view RENAME TO mat_view_stage'');exec Source.native(''ALTER TABLE mat_view_temp RENAME TO mat_view'');exec Source.native(''MERGE INTO check_table(id,after_load) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT after_load from check_table WHERE id=''''external_long_ttl''''),0)+1)'');',
> "teiid_rel:MATVIEW_ONERROR_ACTION" 'THROW_EXCEPTION',
> "teiid_rel:MATVIEW_TTL" 2000)
> AS SELECT c.id AS customer_id, CONVERT(SUM(o.amount),biginteger) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id;
> ]]>
> </metadata>
> </model>
> <translator name="h2-override" type="h2">
> <property name="SupportsDirectQueryProcedure" value="true" />
> </translator>
> </vdb>
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 2 months
[JBoss JIRA] (TEIIDDES-2745) Extension properties not imported from dynamic VDB
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2745?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2745:
-----------------------------------
Labels: release_notes verified_jbdsis-9.0.0.Beta (was: )
> Extension properties not imported from dynamic VDB
> --------------------------------------------------
>
> Key: TEIIDDES-2745
> URL: https://issues.jboss.org/browse/TEIIDDES-2745
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs, Patch Release
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Labels: release_notes, verified_jbdsis-9.0.0.Beta
> Fix For: 10.0.1, 9.2.1
>
>
> When importing a dynamic VDB containing models with extension properties, the properties are not imported.
> {code:xml}
> <?xml version="1.0" encoding="UTF-8"?>
> <vdb name="MatViewsVdb" version="1">
> <description>For testing of materialized views</description>
>
> <model name="Source">
> <source name="Source" translator-name="h2-override"
> connection-jndi-name="java:/mat-views-ds" />
> <metadata type="DDL"><![CDATA[
>
> CREATE FOREIGN TABLE customers (
> id integer,
> name string(4000),
> address string(4000),
> CONSTRAINT PK_ID PRIMARY KEY(id)
> ) OPTIONS(NAMEINSOURCE 'customer')
>
> CREATE FOREIGN TABLE orders (
> id integer,
> customer_id integer,
> amount integer,
> CONSTRAINT PK_ID PRIMARY KEY(id),
> CONSTRAINT FK_CUST FOREIGN KEY(customer_id) REFERENCES customers(id)
> ) OPTIONS(NAMEINSOURCE 'order')
> ]]>
> </metadata>
> </model>
>
> <!-- TODO: change the CONVERTs to integer once TEIIDDES-2737 is resolved -->
> <model name="ViewModel" type="VIRTUAL">
> <metadata type="DDL"><![CDATA[
> CREATE VIEW internal_short_ttl (
> customer_id integer NOT NULL,
> total_amount integer
> ) OPTIONS (MATERIALIZED 'TRUE',
> "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute Source.native(''INSERT INTO check_table(id,before_load) VALUES (''internal_short_ttl'',1) ON DUPLICATE KEY UPDATE before_load=before_load+1;'');',
> "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute Source.native(''INSERT INTO check_table(id,after_load) VALUES (''internal_short_ttl'',1) ON DUPLICATE KEY UPDATE after_load=after_load+1;'')'
> )
> AS /*+ cache(ttl:100)*/SELECT c.id AS customer_id, CONVERT(SUM(o.amount),biginteger) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id;
>
> CREATE VIEW internal_long_ttl (
> customer_id integer PRIMARY KEY,
> total_amount integer
> ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'FALSE')
> AS /*+ cache(ttl:1000 updatable)*/ SELECT c.id AS customer_id, CONVERT(SUM(o.amount),biginteger) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id;
>
> CREATE VIEW external_long_ttl (
> customer_id integer NOT NULL,
> total_amount integer
> ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'FALSE',
> MATERIALIZED_TABLE 'Source.DB.PUBLIC.MAT_VIEW',
> "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true',
> "teiid_rel:MATVIEW_STATUS_TABLE" 'Source.DB.PUBLIC.STATUS',
> "teiid_rel:ON_VDB_START_SCRIPT" 'exec Source.native(''MERGE INTO check_table(id,vdb_create) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT vdb_create from check_table WHERE id=''''external_long_ttl''''),0)+1)'');',
> "teiid_rel:ON_VDB_DROP_SCRIPT" 'exec Source.native(''MERGE INTO check_table(id,vdb_drop) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT vdb_drop from check_table WHERE id=''''external_long_ttl''''),0)+1)'');',
> "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO mat_view_stage(customer_id,total_amount) SELECT c.id AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id;',
> "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute Source.native(''truncate table mat_view_stage'');exec Source.native(''MERGE INTO check_table(id,before_load) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT before_load from check_table WHERE id=''''external_long_ttl''''),0)+1)'');',
> "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'exec Source.native(''ALTER TABLE mat_view_stage RENAME TO mat_view_temp'');exec Source.native(''ALTER TABLE mat_view RENAME TO mat_view_stage'');exec Source.native(''ALTER TABLE mat_view_temp RENAME TO mat_view'');exec Source.native(''MERGE INTO check_table(id,after_load) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT after_load from check_table WHERE id=''''external_long_ttl''''),0)+1)'');',
> "teiid_rel:MATVIEW_ONERROR_ACTION" 'THROW_EXCEPTION',
> "teiid_rel:MATVIEW_TTL" 2000)
> AS SELECT c.id AS customer_id, CONVERT(SUM(o.amount),biginteger) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id;
> ]]>
> </metadata>
> </model>
> <translator name="h2-override" type="h2">
> <property name="SupportsDirectQueryProcedure" value="true" />
> </translator>
> </vdb>
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 2 months
[JBoss JIRA] (TEIIDDES-2797) relational:MATVIEW_TTL has wrong type
by Matus Makovy (JIRA)
Matus Makovy created TEIIDDES-2797:
--------------------------------------
Summary: relational:MATVIEW_TTL has wrong type
Key: TEIIDDES-2797
URL: https://issues.jboss.org/browse/TEIIDDES-2797
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 10.0
Reporter: Matus Makovy
TD shows an error after using: "relational:MATVIEW_TTL" 2000
{code}
Value "2000" is not an allowed value for property "relational:MATVIEW_TTL." Value was reset to be an empty value.
{code}
After investigation I discovered that TD allows only boolean values for this property. I don't think this is correct. According to Teiid documentation:
_teiid_rel:MATVIEW_TTL - time to live in milliseconds. Provide property or cache hint on view transformation - property takes precedence. _
In https://github.com/Teiid-Designer/teiid-designer/blob/master/plugins/org.... there is:
{code:xml}
...
<p:property advanced="false" index="true" masked="false" name="MATVIEW_TTL" required="false" type="boolean">
<p:description locale="en_US">Time to live in milliseconds. Provide property or cache hint on view transformation - property takes precedence. </p:description>
<p:display locale="en_US">Time To Live (ms)</p:display>
</p:property>
...
{code}
Type is set to boolean.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 2 months
[JBoss JIRA] (TEIIDDES-2764) Change DDL importer framework to use refactored Teiid DDL parser source
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2764?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2764:
-----------------------------------
Labels: release_notes verified_jbdsis-9.0.0.Beta (was: )
> Change DDL importer framework to use refactored Teiid DDL parser source
> -----------------------------------------------------------------------
>
> Key: TEIIDDES-2764
> URL: https://issues.jboss.org/browse/TEIIDDES-2764
> Project: Teiid Designer
> Issue Type: Task
> Components: Import/Export, ModeShape Integration, Patch Release
> Reporter: Barry LaFond
> Assignee: Dan Florian
> Priority: Blocker
> Labels: release_notes, verified_jbdsis-9.0.0.Beta
> Fix For: 10.0.1, 9.2.1
>
>
> DDL Importer currently displays selection of DDL dialects. Since the Teiid DDL Parser is being refactored/removed from the general DDL dialects we'll need to integrate this separate parser in a different way to allow selection and auto-select in the combo box.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 2 months