-
1. Re: Re-Fetching teiid metadata
rareddy Dec 7, 2012 9:42 AM (in response to rakeshsagar)with 8.2, the VDB deployment gets delayed until the data source is available. If available but fails to fetch metadata then it would be in not valid state, that requires a re-deployment.
-
2. Re: Re-Fetching teiid metadata
shawkins Dec 7, 2012 9:45 AM (in response to rareddy)You can modify view/procedure definitions via alters, but unfortunately you cannot modify the structual metadata of a running vdb. A full redeploy is not necessary as you could use the vdb restart operation, but that, like a redeployment, will stop any active sessions against the vdb.
Steve
-
3. Re: Re-Fetching teiid metadata
rakeshsagar Dec 7, 2012 11:34 AM (in response to shawkins)Thanks for the responses Ramesh/Steve.
The only option rught now is to redeploy the vdb.
Can I open a JIRA issue for a feature request for this functionality??
Thanks
Rakesh
-
4. Re: Re-Fetching teiid metadata
rareddy Dec 7, 2012 11:48 AM (in response to rakeshsagar)It is a limitation of VDB deployment model that Teiid has, there is not much more we can do on that part until Teiid supports full range of DDL, like create/alter views ad-hoc during the runtime like traditional RDBMS.
Restart is your best choice for now, as it can reload that particular model, where as re-deploy would load the all the models in the VDB.
So no for the JIRA.
Ramesh..
-
5. Re: Re-Fetching teiid metadata
rakeshsagar Dec 9, 2012 4:20 AM (in response to rareddy)Thanks Ramesh.