Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Hive views


Copy link to this message
-
Re: Hive views
Edward Capriolo 2013-05-21, 15:07
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 <
[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]]
> Sent: Thursday, May 16, 2013 6:45 PM
> To: [EMAIL PROTECTED]; 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
>