I don't understand what you mean by Hive installing your schema at startup.
If you have created an empty database/schema in postgres (I am not familiar with it), you can run the relevant script in directory $HIVE_HOME/scripts/metastore/upgrade/postgres That will create all the associated tables and views in your schema and you only need it once and the schema will be populated by hive user that you have specified the details in hive-site.xml HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com *Disclaimer:* Use it at your own risk. Any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on this email's technical content is explicitly disclaimed. The author will in no case be liable for any monetary damages arising from such loss, damage or destruction. On 25 October 2016 at 08:50, Per Ullberg <per.ullb...@klarna.com> wrote: > Sorry, no help from me I'm afraid, but I have a similar question: > > Could someone provide me with a code snippet (preferably Java) that > installs the schema (through datanucleus) on my empty metastore (postgres). > I don't want Hive to install the schema at startup, but rather do it > explicitly myself. > > regards > /Pelle > > On Tue, Oct 25, 2016 at 9:09 AM, Rajendra Bhat <rajhalk...@gmail.com> > wrote: > >> Hi Team, >> >> I have configured only meta store and started the meta store service, >> hwich i ma used on presto. >> >> I need create table on metastore.. how can i able create that.. as i am >> not started hive server service, bcoz hadoop not installed on my syatem. >> >> -- >> Thanks and >> Regards >> >> Rajendra Bhat >> > > > > -- > > *Per Ullberg* > Data Vault Tech Lead > Odin Uppsala > +46 701612693 <+46+701612693> > > Klarna AB (publ) > Sveavägen 46, 111 34 Stockholm > Tel: +46 8 120 120 00 <+46812012000> > Reg no: 556737-0431 > klarna.com > >
