[
https://issues.jboss.org/browse/TEIID-2578?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-2578:
---------------------------------------
With this we are some what similar to other databases.
To an extent. You loose ease of use of metadata reload in the import schema case. That
is something we could workaround by adding a high-level operation that drops all the
objects of the schema, then reruns the import as part of a "restart" operation.
However we are fundamentally breaking the expectations of the vdb reuse feature. The
reuse here is now only at the time of the import statement - any further changes to the
imported vdb require a manual process on the part of the user to incorporate into all
importing vdbs. I don't see a simple workaround here since the load operation from
the databasestore assumes everything is fully realized and in a valid state. The load
will need some work in general as any issue with any vdb load will cause the whole load to
be aborted.
They should work
Not yet, they require a RuntimeVDB acquired from the VDBService, which is not associated
with a DDL based VDB.
I see the benefits of deployment and repository based vdbs, we need
to articulate both positions in examples and documents to choose what is better for the
user.
I'm a little uncomfortable with that if it means they have different
capabilities/behavior.
add/remove schema elements
--------------------------
Key: TEIID-2578
URL:
https://issues.jboss.org/browse/TEIID-2578
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Reporter: Ramesh Reddy
Assignee: Ramesh Reddy
Fix For: 9.2
Schemas are currently static after load. Modifications can only happen with restarts or
new versions. We should allow add/drop at runtime.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)