You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by abhishek <ab...@gmail.com> on 2013/05/17 00:45:12 UTC

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

Re: Hive views

Posted by Edward Capriolo <ed...@gmail.com>.
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.mcdonald@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.dodda1@gmail.com]
> Sent: Thursday, May 16, 2013 6:45 PM
> To: cdh-user@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
>

RE: Hive views

Posted by Clay McDonald <st...@bateswhite.com>.
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.dodda1@gmail.com] 
Sent: Thursday, May 16, 2013 6:45 PM
To: cdh-user@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