-
1. Re: How are MEDs used by the TeiiD Server
blafond Jun 27, 2014 3:37 PM (in response to virtualdatabase)"Will be used by Teiid server" is an default option for any extension property. if TRUE, then a property value is added to the indexed metadata for that object and ends up in the VDB. My understanding of the server is that these extension properties are then served up (made available) generically to any "translator" that wishes to find their particular extension properties and use them if it chooses.
Not sure whether or not there is a way to view them (if they exist) for a deployed VDB
-
2. Re: How are MEDs used by the TeiiD Server
rareddy Jun 30, 2014 12:09 PM (in response to blafond)If you applied the extension properties on Source Model, and then supplied the values for those properties, they will be available in the translator's RuntimeMetadata class to make any further query planning decisions.
If you applied on the View model, then they are specific to Teiid Query Engine, or Custom Metadata that user likes to decorate their models with. If the property is defined by the core team then it will be used for some kind of query planning, when used as Custom Metadata, user has additional plans reading this metadata from ModeShape like repository to further drive their architecture, however they see fit, but they will not be used by core Teiid engine.
Ramesh..
-
3. Re: How are MEDs used by the TeiiD Server
virtualdatabase Jun 30, 2014 12:59 PM (in response to rareddy)So they are not available at run-time except programmaticly?
I was looking for a stored procedure or something to 'find'/discover them somehow..
I.E. GetMedProperty(<propertyName>) would return all objects having the a Med property called propertyName
or havingMedPropertyValue(<PropertyValue>) would return all objects having a propertyvalue eq to the PropertyValue given...
Just some ideas..
-
4. Re: How are MEDs used by the TeiiD Server
shawkins Jun 30, 2014 1:01 PM (in response to virtualdatabase)There is a SYS.PROPERTIES table System Tables - Teiid 8.8 (draft) - Project Documentation Editor, but it is currently for all object types - tables, columns, etc. So you have to somewhat know what you are looking for.
-
5. Re: How are MEDs used by the TeiiD Server
virtualdatabase Jun 30, 2014 2:52 PM (in response to shawkins)The Sys.Properties seems to be providing what i am looking for right now.. Thanks!
Given the trending 'dynamic' nature of vdbs... is it possible to call setProperties for a particular "name" ?
-
6. Re: How are MEDs used by the TeiiD Server
shawkins Jun 30, 2014 3:27 PM (in response to virtualdatabase)> is it possible to call setProperties for a particular "name" ?
You mean SYSADMIN.setProperty? You have to perform the set by the uid, which means you will like need to do a scalar subquery (select uid from tables where SchemaName='x' and Name='y') to get the uid.
-
7. Re: How are MEDs used by the TeiiD Server
rareddy Jun 30, 2014 5:39 PM (in response to shawkins)steven.hawkins I forgot what was the intention behind this setProperty call?
-
8. Re: How are MEDs used by the TeiiD Server
shawkins Jun 30, 2014 8:24 PM (in response to rareddy)To allow extension properties to be altered at runtime.