Member since
03-01-2021
4
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
8395 | 03-01-2021 07:57 PM |
04-22-2021
11:57 PM
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
03-23-2021
07:09 AM
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
03-02-2021
09:21 AM
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