Hi, We are facing Hive Metastore issue.The metastore stops after few seconds and it throws a null pointer exception.Hive metastore service is running on Namenode machine and postgres DB is set on remote machine.The initialization script ran successfully and created all the required tables on the hive schema. Below are the logs for the reference. 2017-05-19 14:58:47,735 INFO [main]: metastore.HiveMetaStore (HiveMetaStore.java:main(6279)) - Starting hive metastore on port 9083 2017-05-19 14:58:47,983 INFO [main]: impl.MetricsConfig (MetricsConfig.java:loadFirst(112)) - loaded properties from hadoop-metrics2-hivemetastore.properties 2017-05-19 14:58:48,305 INFO [main]: timeline.HadoopTimelineMetricsSink (HadoopTimelineMetricsSink.java:init(80)) - Initializing Timeline metrics sink. 2017-05-19 14:58:48,306 INFO [main]: timeline.HadoopTimelineMetricsSink (HadoopTimelineMetricsSink.java:init(98)) - Identified hostname = <hostname>, serviceName = hivemetastore 2017-05-19 14:58:48,401 INFO [main]: availability.MetricSinkWriteShardHostnameHashingStrategy (MetricSinkWriteShardHostnameHashingStrategy.java:findCollectorShard(42)) - Calculated collector shard <hostname> based on hostname: <hostname> 2017-05-19 14:58:48,401 INFO [main]: timeline.HadoopTimelineMetricsSink (HadoopTimelineMetricsSink.java:init(121)) - Collector Uri: http://<hostname>:6188/ws/v1/timeline/metrics 2017-05-19 14:58:48,401 INFO [main]: timeline.HadoopTimelineMetricsSink (HadoopTimelineMetricsSink.java:init(122)) - Container Metrics Uri: http://<hostname>:6188/ws/v1/timeline/containermetrics 2017-05-19 14:58:48,426 INFO [main]: impl.MetricsSinkAdapter (MetricsSinkAdapter.java:start(206)) - Sink timeline started 2017-05-19 14:58:48,506 INFO [main]: impl.MetricsSystemImpl (MetricsSystemImpl.java:startTimer(376)) - Scheduled snapshot period at 10 second(s). 2017-05-19 14:58:48,506 INFO [main]: impl.MetricsSystemImpl (MetricsSystemImpl.java:start(192)) - hivemetastore metrics system started 2017-05-19 14:58:48,607 INFO [main]: metastore.HiveMetaStore (HiveMetaStore.java:newRawStore(685)) - 0: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore 2017-05-19 14:58:49,285 INFO [main]: metastore.ObjectStore (ObjectStore.java:initializeHelper(377)) - ObjectStore, initialize called 2017-05-19 14:58:50,443 INFO [main]: metastore.ObjectStore (ObjectStore.java:getPMF(481)) - Setting MetaStore object pin classes with hive.metastore.cache.pinobjtypes="Table,Database,Type,FieldSchema,Order" 2017-05-19 14:58:50,494 ERROR [main]: metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(203)) - java.lang.NullPointerException: tuples must be non-null at org.postgresql.jdbc.PgResultSet.<init>(PgResultSet.java:144) at org.postgresql.jdbc.PgStatement.createResultSet(PgStatement.java:160) at org.postgresql.jdbc.PgStatement$StatementResultHandler.handleResultRows(PgStatement.java:210) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2034) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:303) at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:289) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:266) at org.postgresql.jdbc.PgConnection.execSQLUpdate(PgConnection.java:477) at org.postgresql.jdbc.PgConnection.getTransactionIsolation(PgConnection.java:847) at com.jolbox.bonecp.ConnectionHandle.getTransactionIsolation(ConnectionHandle.java:825) at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:427) at org.datanucleus.store.rdbms.RDBMSStoreManager.getNucleusConnection(RDBMSStoreManager.java:1357) at org.datanucleus.api.jdo.JDOPersistenceManager.getDataStoreConnection(JDOPersistenceManager.java:2263) at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.getProductName(MetaStoreDirectSql.java:168) at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.determineDbType(MetaStoreDirectSql.java:151) at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.<init>(MetaStoreDirectSql.java:121) at org.apache.hadoop.hive.metastore.ObjectStore.initializeHelper(ObjectStore.java:383) at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:316) at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:277) at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:60) at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:69) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:689) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:667) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:716) ... View more