Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Hive views


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
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB