hive 远端配置及 Oracle sql developer 连接hive

     1	<?xml version="1.0"?>
     2	<configuration>
       
       
     3	<property> 
     4	   <name>hive.metastore.uris</name> 
     5	   <value>thrift://master1:9083</value> 
     6	</property> 
     7	</configuration>

以上为hive客户端机器hive-site.xml 配置

     1	<?xml version="1.0"?>
     2	<configuration>
       
     3	<property> 
       
     4	   <name>javax.jdo.option.ConnectionURL</name> 
       
     5	   <value>jdbc:mysql://master1:3306/hive</value> 
       
     6	</property> 
       
     7	<property> 
       
     8	   <name>javax.jdo.option.ConnectionDriverName</name> 
       
     9	   <value>com.mysql.jdbc.Driver</value> 
       
    10	</property>
       
    11	<property> 
       
    12	   <name>javax.jdo.option.ConnectionUserName</name> 
       
    13	   <value>hive</value> 
       
    14	</property> 
       
    15	<property> 
       
    16	   <name>javax.jdo.option.ConnectionPassword</name> 
       
    17	   <value>-----</value> 
       
    18	</property> 
       
    19	</configuration>

以上为hive server端配置

server端开启metastore 

开启hiveserver2

hive --service metastore

hive --service hiveserver2

其各自对应端口为 9083 10000

--------------------------------------------------

下载

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

https://www.cloudera.com/downloads/connectors/hive/jdbc/2-5-15.html