An error occurred while executing the SQL client in hive. The hivesql Client

An error occurred while executing the SQL client in hive. The hivesql Client

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exe c. DDLTask. java. lang. RuntimeException: Unable to instantiate org. apache. hadoop. hive. metastore. HiveMetaStoreClient

Hive metadata repository not started: hive -- service metastore

An exception occurred while executing the SQL statement in java. After capturing and processing the SQL statement, how can the program continue to execute it below?

Result. next () will only cause exceptions in two situations: first, the database itself is faulty, and second, it has been disabled.
In your program, the preceding access is correct to prevent exceptions from affecting others. Therefore, the first cause of the exception is impossible. But you won't take the initiative to shut down the database in another thread, right? Therefore, the second cause of the exception cannot occur.
Therefore, this exception is captured, so you don't have to perform any processing. You just need to proceed to the next step.
While (rs. next ()){
Try {
//..........
}
Catch (SQLException ex ){}
}

Hive SQL connects two tables to the third table

SELECT a. * FROM a JOIN B ON (a. id = B. id );
We recommend that you check the official wiki:
Cwiki.apache.org/..w.joins