Hive database cannot be created after configuration access, hadoop can build sheet-CodePudding

According to the tutorial configuration hive permissions, unable to create the database problems after hive configuration below
 
<? The XML version="1.0" encoding="utf-8"?> 

 
 
 Javax.mail. Jdo. Option. ConnectionURL 
 JDBC: mysql://hadoop103:3306/hive? CreateDatabaseIfNotExist=true 
 

 
 Javax.mail. Jdo. Option. ConnectionDriverName 
 Com. Mysql. JDBC. Driver 
 

 
 Javax.mail. Jdo. Option. ConnectionUserName 
 Root 
 

 
 Javax.mail. Jdo. Option. ConnectionPassword 
 123456 & lt;/value> 
 

 
 Hive. The exec. Scratchdir 
/my/opt/;/metadata/hive/hivescratchdir/hive - ${user. The name} & lt;/value> 
 

 
 Hive. The exec. Parallel 
 True 
 

 
 Hive. The exec. Parallel. Thread. Number 
 16 & lt;/value> 
 
 
 Hive. Cli. Print. Header 
 True 
 
- & gt; 
 
 Hive. Cli. Print. Row. To.. vertical 
 True 
 

 
 Hive. Cli. Print. Current. Db 
 True 
 
 
 Hive, exec mode. Local. Auto 
 True 
 The enable local mode 
 
- & gt; 
 
 Hive. Auto. Convert. Join 
 True 
 Automatically enable mapside join 
 

 
 Hive. Mapjoin. Smalltable. Filesize 
 250000000 & lt;/value> 
 Small table size (bytes) & lt;/description> 
 

 
 Hive. The exec. Dynamic. Partition 
 True 
 Enable dynamic partition 
 

 
 Hive. The exec. Dynamic. Partition. Mode 
 Strict 
 Been or not allow all the partitions are dynamic 
 

 
 Hive. The exec. Max. Dynamic. Partitions. Pernode 
 1000 & lt;/value> 
 Number of partitions that one dynamic clause can create 
 

 
 Hive. Mapred. Mode 
 Strict 
 

 
 Hive. Hwi. Listen. Host 
 Hadoop101 & lt;/value> 
 This is the host address the Hive Web Interface will listen on 
 

 
 Hive. Hwi. Listen. Port 
 19999 & lt;/value> 
 This is the port the Hive Web Interface will listen on 
 

 
 Hive. Hwi. War. File 
 Lib/hive - hwi - 0.12.0. War 
 This is the WAR file with the JSP content for Hive Web Interface 
 

 
 Hive. Server2. Thrift. Port 
 10000 & lt;/value> 
 
 
 Hive. Server2. Thrift. Bind. Host 
 Hadoop101 & lt;/value> 
 
 
 Hive. Metastore. Warehouse. Dir 
/my/user/hive/warehouse 
 The location of the default database for warehouse 
 

 
 Hive. Default. Fileformat 
 RCFile 
 
 
 Hive.exec.com press. Output 
 True 
 This controls, been the final outputs of a query (to a local/HDFS 
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull