The views should not be lost every time, you might want to try a permanent metastore backed by mysql so you do not lose your table definitions.
On Tue, May 21, 2013 at 8:14 AM, Clay McDonald < stuart.mcdon...@bateswhite.com> wrote: > Maybe you could modify the Hive startup script to recreate your views. I > would try creating a script that has the create views the call that from > the startup script. > > Clay > > > -----Original Message----- > From: abhishek [mailto:abhishek.dod...@gmail.com] > Sent: Thursday, May 16, 2013 6:45 PM > To: cdh-u...@cloudera.org; Hive > Subject: Hive views > > Hi all, > > We had created views in hive, but when we restart the cluster then the > views created in the hive are deleted automatically. > I know hive view doesn't persist after cluster restart, but I want figure > it out a way to persist it. Can someone help me how to do that? > > Regards > Abhishek >
