-
1. Re: Create large virtual DB
rareddy Feb 9, 2016 4:14 PM (in response to shekhar78)Shekhar,
If I remember correctly you can have multiple lines of
<metadata type="DDL-FILE">MyDynamicModel.ddl</metadata>
inside single model, will that work? Note that the order defined is way they will be processed. So, far example, if use an "allter", the previous one must have the definition for the entity etc.
Ramesh..
-
2. Re: Create large virtual DB
shekhar78 Feb 9, 2016 4:36 PM (in response to rareddy)I tried that earlier but it didn't work.I have Teiid 8.7.1 .
-
3. Re: Create large virtual DB
shawkins Feb 9, 2016 4:42 PM (in response to shekhar78)Support for multiple metadata elements was added in 8.11: [TEIID-3372] Support multiple metadata tags - JBoss Issue Tracker
-
4. Re: Create large virtual DB
shekhar78 Feb 12, 2016 11:19 AM (in response to shawkins)Thats great feature. However it will endup having 200+ likes for DDL-FILE metadata if we want to put a file for each view.
A suggestion is to have a capability in DDL file to refer to another file.
Like One DDL file will have link to another files containing views in organized way.
-
5. Re: Create large virtual DB
rareddy Feb 12, 2016 11:26 AM (in response to shekhar78)We are not asking you to create 200+ views. We are asking you to write
<metadata type="DDL-FILE">MyDynamicModel.ddl</metadata>
for each file in the same model. They all will be in the single View. I do not see we implementing a new import mechanism to read DDL file from another DDL file, then that would become non-standard custom file, where we need to define the import semantics, merging etc. It does not seem appealing feature to me.
Ramesh..
-
6. Re: Create large virtual DB
shekhar78 Feb 12, 2016 2:53 PM (in response to rareddy)Just to clarify my understanding.
Model definition will look like below.
<model name="MyModel" type="VIRTUAL" visible="true">
<property name="modelClass" value="Relational"/>
<metadata type="DDL-FILE">ViewDef_1.ddl</metadata>
<metadata type="DDL-FILE">ViewDef_2.ddl</metadata>
<metadata type="DDL-FILE">ViewDef_3.ddl</metadata>
<metadata type="DDL-FILE">...</metadata>
<metadata type="DDL-FILE">ViewDef_200.ddl</metadata>
</model>
-