> Could someone provide me with a code snippet (preferably Java) that installs > the schema (through datanucleus) on my empty metastore (postgres)
I wish it was that simple, but do not leave it to the Hive startup to create it - create it explicitly with schematool https://cwiki.apache.org/confluence/display/Hive/Hive+Schema+Tool#HiveSchemaTool-TheHiveSchemaTool or alternatively https://github.com/apache/hive/blob/master/metastore/scripts/upgrade/postgres/hive-schema-2.2.0.postgres.sql Cheers, Gopal