【大数据基础】hive的配置文件

一、vim hive-site.xml

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>

        
                javax.jdo.option.ConnectionDriverName
                com.mysql.jdbc.Driver
                Driver class name for a JDBC metastore
        
        
        
                javax.jdo.option.ConnectionURL
                jdbc:mysql://hadoop02:3306/hive_metastore?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=UTF8&useSSL=false
                JDBC connect string for a JDBC metastore
        
        
                javax.jdo.option.ConnectionUserName
                zhyx
                username to use against metastore database
        
        
                javax.jdo.option.ConnectionPassword
                zhyxmysql22
                password to use against metastore database
        

                 
          
          hive.metastore.schema.verification
         false
         
        
         
         hive.metastore.event.db.notification.api.auth
        false
        

        
        
                hive.metastore.warehouse.dir
                /user/hive3/warehouse
                location of default database for the warehouse
        

       
                hive.cli.print.header
                true
        

                
          hive.metastore.uris
          thrift://hadoop02:9083
         
  
        
                hive.server2.thrift.bind.host
                hadoop02
        

                
         hive.server2.thrift.port
          10000
        
      


    spark.yarn.jars
    hdfs://hadoop01:8020/spark-jars/*

  


    hive.execution.engine
    spark