Hive Common Configuration

1. Configure hive's root directory location on HDFs

  
 

   
  

  
<property>
   
  

  
 <name>hive.metastore.warehouse.dir</name>
   
  

  
 <value>/hive</value>
   
  

  
</property>
  
 

2. Configure the location of the Derby database files (where the Derby data is fixed)

  
 

   
  

  
<property>
   
  

  
 /span><  name  >  javax   jdo   option   connectionurl  </ name  >   
   
  

  
 /span><  value  >  jdbc  :  derby  :  databasename  =/ usr  / local  / bigdata  / hive  - 0.14   0  / metastore_db   create  =  true  </ value  >   
   
  

  
 </property>
  
 

3. Configure the metadata database MySQL

  
 

   
  

  
<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>
  
 

. Hiverc configuration, refer to ". Hiverc"


From for notes (Wiz)

Hive Common Configuration