按照教程执行到HIVE登陆时报错：role "tdwmeta" is not permitted to log in

[Richard Chen]

hive -u root -p tdwroot

session : richard_201412091708_0.09944764885260848 start!

org.postgresql.util.PSQLException: FATAL: role "tdwmeta" is not permitted to log in

at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:471)

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:112)

at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)

at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)

at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)

at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)

at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:32)

at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)

at org.postgresql.Driver.makeConnection(Driver.java:393)

at org.postgresql.Driver.connect(Driver.java:267)

at java.sql.DriverManager.getConnection(DriverManager.java:582)

at java.sql.DriverManager.getConnection(DriverManager.java:185)

at org.apache.hadoop.hive.metastore.SyncDBRouterThread.init(SyncDBRouterThread.java:117)

at org.apache.hadoop.hive.metastore.JDBCStore.initMetaSyncThread(JDBCStore.java:263)

at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.initSyncThread(HiveMetaStore.java:187)

at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:214)

at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:153)

at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:71)

at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:1615)

at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:1621)

at org.apache.hadoop.hive.ql.metadata.Hive.isAUser(Hive.java:3209)

at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:311)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.hadoop.util.RunJar.main(RunJar.java:156)

Exception in thread "main" org.apache.hadoop.hive.ql.metadata.HiveException: eeeeee  null  java.lang.NullPointerException  Failed to judge the user: root ! Please check the log.

at org.apache.hadoop.hive.ql.metadata.Hive.isAUser(Hive.java:3211)

at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:311)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.hadoop.util.RunJar.main(RunJar.java:156)