Solution provided can be worked on new environment,  If its old environment, then issue can be addressed as below,    NN1 - Started - But its state always in staring - Leave as is and go to NN2 NN2 - Start NN2 - This start will fix this issue ... View more

Please find here the Apache Hive tutorial and more information on selecting distinct values under the Aggregations section.   For more on the Apache Hive content roadmap, please refer to our documentation. ... View more

Thanks @GangWar for the response. Definitely helps. While trying to initialize the metastore, I am now getting the following error after running the following command: [root@test02 bin]# ./schematool -dbType mysql -initSchema -passWord <<password>> -userName <<username>> --verbose The connection to the metastore seems successful but the schema initialization failed. Error: Duplicate key name 'PCS_STATS_IDX' (state=42000,code=1061) Closing: 0: jdbc:mysql://test.domain.com/hive?createDatabaseIfNotExist=true org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !! Underlying cause: java.io.IOException : Schema script failed, errorcode 2 org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !! at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:590) at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:563) at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1145) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:233) at org.apache.hadoop.util.RunJar.main(RunJar.java:148) Caused by: java.io.IOException: Schema script failed, errorcode 2 at org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:980) at org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:959) at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:586) ... 8 more *** schemaTool failed *** ... View more