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.
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.
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??
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.