Configure hive to use MySQL storage metadata Metadatastore

    Hive uses the Derby database to save metadata by default, and the Derby database is relatively small, and only one session can be opened at a time, generally modified to the MySQL database.
1. Modify the Conf/hive-site.xml configuration:

  
 

   
  

  
<property>
   
  

  
 <name>javax.jdo.option.ConnectionURL</name>
   
  

  
 <value>jdbc:mysql://hadoop1:3306/hive?createDatabaseIfNotExist=true</value>
   
  

  
 </property>
   
  

  
 <property>
   
  

  
 <name>javax.jdo.option.ConnectionDriverName</name>
   
  

  
 <value>com.mysql.jdbc.Driver</value>
   
  

  
 </property>
   
  

  
 <property>
   
  

  
 <name>javax.jdo.option.ConnectionUserName</name>
   
  

  
 <value>root</value>
   
  

  
 </property>
   
  

  
 <property>
   
  

  
 <name>javax.jdo.option.ConnectionPassword</name>
   
  

  
 <value>root</value>
   
  

  
 </property>
  
 

2. Upload the MySQL driver package to the Lib directory

  
 

   
  
 
   
< Code class= "Language-sh" >- RW  - r  -- r  --.    1   Hadoop hadoop   855948    jul        2013   MySQL  - connector  - java  - 5.1   26  - bin   jar  
 
  
  
 

3. Restart Hive

From for notes (Wiz)

Configure hive to use MySQL storage metadata Metadatastore