connect jdbc:hive2://localhost:10000/default Connecting to jdbc:hive2://localhost:10000/default Enter...username for jdbc:hive2://localhost:10000/default: root Enter password for jdbc:hive2://localhost:10000...1.2.1000.2.4.3.0-227) Transaction isolation: TRANSACTION_REPEATABLE_READ 0: jdbc:hive2://localhost:10000...:hive2://localhost:10000/default> 默认用户名、密码不验证,可以随便输入。...connect jdbc:hive2://192.168.1.158:10000/default Connecting to jdbc:hive2://192.168.1.158:10000/default
: bin/beeline -u jdbc:hive2://master:10000 -n hadoop 接下来就可以做正常sql查询了 1:将Hive作为一个服务器,其他机器可以作为客户端进行访问...connect jdbc:hive2//master:10000写成!connect jdbc:hive2//localhost:10000即可。...connect jdbc:hive2://localhost:10000 2 Connecting to jdbc:hive2://localhost:10000 3 Enter username...for jdbc:hive2://localhost:10000: hadoop 4 Enter password for jdbc:hive2://localhost:10000: 5 Error...: TRANSACTION_REPEATABLE_READ 30 1: jdbc:hive2://localhost:10000> 登陆以后即可以进行操作,演示如下所示: ?
] [zk: localhost:2181(CONNECTED) 1] ls /hiveserver2_zk [serverUri=ip-172-31-6-148.fayson.com:10000;version...3.Beeline测试 ---- HiveServer2注册Zookeeper后,JDBC连接的URL格式为: jdbc:hive2:///;ServiceDiscoveryMode...: Connected to ip-172-31-6-148.fayson.com:10000 ... 0: jdbc:hive2://ip-172-31-10-118.fayson.com:2> select...:hive2://ip-172-31-10-118.fayson.com:2> [n0jgcd3d81.jpeg] 通过上图标注可以看到通过Beeline连接到的是ip-172-31-6-148.fayson.com...: Connected to ip-172-31-5-190.fayson.com:10000 0: jdbc:hive2://ip-172-31-10-118.fayson.com:2> select
Beeline 是一个 Hive 客户端,使用 JDBC 连接到 HiveServer2,是集群上的服务。可以在集群上执行 Beeline 命令获取查询结果,而无需进入 hive 数据库。...Connect using simple authentication to HiveServer2 on localhost:10000 $ beeline -u jdbc:hive2://localhost...Connect using SSL connection to HiveServer2 on localhost at 10000 $ beeline "jdbc:hive2://localhost...:hive2://hadoop102:10000> 0: jdbc:hive2://hadoop102:10000> Closing: 0: jdbc:hive2://hadoop102:10000 [...除了可以读取文件,还可以将查询结果写入到一个文件中,请看如下示例: [omc@hadoop102 bin]$ beeline -u jdbc:hive2://hadoop102:10000 -n omc
使用beeline和HiveCLI都可以登录Hive2.2.0并正常使用。 2.CDH集群已部署Spark1.6且服务正常 ? 提交一个Spark作业测试Spark服务是否正常。...3.Hive2集成Spark1.6 ---- 1.创建软连将${SPARK}_HOME}/lib目录下的spark-assembly.jar包软连至${HIVE2_HOME}/lib目录下 [root@..." alias beeline2="/opt/cloudera/HIVE2/bin/beeline" (可左右滑动) ?...connect jdbc:hive2://localhost:10000 hive hive 0: jdbc:hive2://localhost:10000> use test; 0: jdbc:hive2...://localhost:10000> set hive.execution.engine=spark; 0: jdbc:hive2://localhost:10000> select id,count
beeline 是 hive 提供的一个新的命令行工具,基于SQLLine CLI的JDBC客户端,beeline 与HiveServer2配合使用,支持嵌入模式和远程模式两种,可以像hive client...bin/beeline -u jdbc:hive2://hadoop@localhost:10000 SLF4J: Class path contains multiple SLF4J bindings...:10000> use default; No rows affected (0.038 seconds) 0: jdbc:hive2://hadoop@localhost:10000> show tables...:hive2://hadoop@localhost:10000> select * from member; +--------------+-------------+-------------+--...:hive2://hadoop@localhost:10000> 如果 beeline 正常登陆,现在就可以访问 Hive 了 使用 hiveJdbcTempldate 方式跟传统 JDBC 一样。
2.创建测试库及外部表 ---- 使用hive用户登录Kerberos,并通过beeline登录HiveServer2 创建fayson数据库 0: jdbc:hive2://localhost:10000...0: jdbc:hive2://localhost:10000/> select * from student_hive; ......数据库对student_hive表操作 可以向表中插入数据 0: jdbc:hive2://localhost:10000/> insert into student_hive values('lisi...INFO : OK No rows affected (22.501 seconds) 0: jdbc:hive2://localhost:10000/> [g1kdj62g7g.jpeg] 可以查询表数据...:hive2://localhost:10000/> [wsrrior2f4.jpeg] 3.HDFS验证 fayson用户可以浏览student_hive的数据目录,查看数据目录下文件内容,但没有delete
connect jdbc:hive2://localhost:10000/;principal=hive/ip-172-31-8-141.ap-southeast-1.compute.internal@...CLOUDERA.COM ... 0: jdbc:hive2://localhost:10000/> create external table if not exists student( . . ....:hive2://localhost:10000/> [ho8pqzn0f0.jpeg] 执行完load命令后,查看表数据 0: jdbc:hive2://localhost:10000/> select...:hive2://localhost:10000/> [mihqflhcmn.jpeg] 4.使用fayson用户在beeline和impala-shell查看 使用fayson用户的principal...角色授权给fayson用户组 0: jdbc:hive2://localhost:10000/> grant role student_read to group fayson; ...
CLI的JDBC客户端。...在嵌入式模式下,运行嵌入式的Hive(类似Hive CLI),而远程模式可以通过Thrift连接到独立的HiveServer2进程上。...启动hiveserver2与beeline 服务 bin/hiveserver2 在启动hiveserver2服务以后,会发现光标静止不动,这不是执行完了的标志,是等待在等待 beeline -u jdbc...:hive2://localhost:10000/default -n root 启动beeline服务 通过jdbc 连接到beeline 就可以对 hive 进行操作了 2、beeline 的常用参数...---加载一个密码:beeline -p valid_password -u ---加载一个JDBC连接字符串:beeline -u db_URL
:hive2://localhost:10000> 但是如果执行其他操作则会报错提示不支持该操作: 0: jdbc:hive2://localhost:10000> delete from test...(state=42000,code=10294) 0: jdbc:hive2://localhost:10000> 如此一来,我们就可以限制Hive中用户对于某些表的操作权限。...-u jdbc:hive2://localhost:10000 -n root ... 0: jdbc:hive2://localhost:10000> set role admin; # 将当前用户角色设置为...:hive2://localhost:10000> 测试授权操作: 0: jdbc:hive2://localhost:10000> use hive_test; No rows affected (...进入交互命令终端,此时执行grant语句就会报错,从报错提示可以看到该错误是从我们实现的Hook类里抛出来的: [hive@hadoop01 ~]$ beeline -u jdbc:hive2://localhost
connect jdbc:hive2://localhost:10000 Connecting to jdbc:hive2://localhost:10000 Enter username for jdbc...:hive2://localhost:10000: hadoopadmin Enter password for jdbc:hive2://localhost:10000: ********** 21/...open client transport with JDBC Uri: jdbc:hive2://localhost:10000: Failed to open new session: java.lang.RuntimeException...connect jdbc:hive2://192.168.31.10:10000/default;auth=noSasl Connecting to jdbc:hive2://192.168.31.10...connect jdbc:hive2://192.168.31.10:10000/default;auth=noSasl Connecting to jdbc:hive2://192.168.31.10
connect jdbc:hive2://localhost:10000/;principal=hive/ip-172-31-22-86.ap-southeast-1.compute.internal@...CLOUDERA.COM scan complete in 2ms ... 0: jdbc:hive2://localhost:10000/> SELECT parse_date('2017-9-12...:hive2://localhost:10000/> 0: jdbc:hive2://localhost:10000/> 0: jdbc:hive2://localhost:10000/> 0:...jdbc:hive2://localhost:10000/> create temporary function parse_date as 'com.peach.date.DateUtils'; .....:hive2://localhost:10000/> [rlebomay0n.jpeg] 2.退出再次使用beeline登录 [root@ip-172-31-22-86 ec2-user]# beeline
0: jdbc:hive2://localhost:10000/> [c5gjo335ar.jpeg] 2.创建admin角色 0: jdbc:hive2://localhost:10000/> create...角色授权给hive用户组 0: jdbc:hive2://localhost:10000> grant role admin to group hive; ......connect jdbc:hive2://localhost:10000/;principal=hive/ip-172-31-6-148.fayson.com@FAYSON.COM ... 0: jdbc...Hive的MapReduce任务 0: jdbc:hive2://localhost:10000/> select count(*) from test; ......connect jdbc:hive2://localhost:10000/;principal=hive/ip-172-31-6-148.fayson.com@FAYSON.COM ... 0: jdbc
主要是因为 HiveServer1 有如下的局限性: 1.支持远程客户端连接,但一次只能连接一个客户端,无法处理来自多个客户端的并发请求。...下面是几种常用的客户端使用方式: beeline 客户端 beeline -u jdbc:hive2://IP地址:端口 -n 用户 -p '密码' 可以进入交互环境,写SQL 进行查询。...Connect using simple authentication to HiveServer2 on localhost:10000 $ beeline -u jdbc:hive2://localhost...beeline -u "jdbc:hive2://hs2.local:10013/default;principal=hive/localhost@mydomain.com 4....Connect using SSL connection to HiveServer2 on localhost at 10000 $ beeline jdbc:hive2://localhost
connect jdbc:hive2://node1:10000 root Enter password for jdbc:hive2://node1:10000: **** #可以输入任意密码,没有验证...connect jdbc:hive2://node1:10000 #这里用户名目前可以随意输入,在Hive中没有校验,这里可以通过Hive配置有哪些用 #户可以连接Hive,然后通过Ranger再管理这些用户的细粒度访问权限...从上图中可以 #看到目前只有root用户可以访问表数据,可以使用非root用户测试,这里使用 #“diaochan”用户: Enter username for jdbc:hive2://node1:10000...age”列无法查询,select * 查询不允许 0: jdbc:hive2://node1:10000> select id ,name from student; [e1787d711a96891b6b9208aa72affe61...connect jdbc:hive2://node1:10000 Enter username for jdbc:hive2://node1:10000: user1 0: jdbc:hive2://node1
在命令行中,键入 hive -h 输出是: Connect using simple authentication to HiveServer2 on localhost:10000 beeline...-u jdbc:hive2://localhost:10000 username password Connect using simple authentication to HiveServer2...principal beeline -u "jdbc:hive2://hs2.local:10013/default;principal=hive/localhost@mydomain.com"...Connect using SSL connection to HiveServer2 on localhost at 10000 beeline "jdbc:hive2://localhost:10000...简单的认证: beeline -u jdbc:hive2://10.65.13.98:10000 -n -p Kerberos: beeline -u "jdbc:hive2
1 Org.apache.hadoop.hive.service.ThriftHive hive1.jpg 1 找不到org.apache.hive.jdbc.HiveDriver (升级到hive-jdbc...0.14.0.jar) 3 org.apache.thrift.TServiceClient(升级到hive-exec-0.14.0.jar) 以上问题基本由于版本导致(升级后如图): hive2.jpg 2 beeline...-u jdbc:hive://localhost:10000 -n hive 报错:no known driver to handle “jdbc:hive://localhost:10000” hive3....jpg 解决办法1: beeline -u jdbc:hive2://localhost:10000 -n hive 解决办法2: beeline -u jdbc:hive2://localhost:...10000 -d org.apache.hive.jdbc.HiveDriver -n hive
connect jdbc:hive2://hadoop002:10000(回车) Connecting to jdbc:hive2://hadoop002:10000 Enter username for...jdbc:hive2://hadoop002:10000: bigdata(回车) Enter password for jdbc:hive2://hadoop002:10000: (直接回车) Connected...0: jdbc:hive2://hadoop002:10000> create database guli; 0: jdbc:hive2://hadoop002:10000> use guli; 0...类型我们大致可以看到就行。 2.2 把数据导入到hive中进行处理(创建两张orc表) 1....测试是否成功 0: jdbc:hive2://hadoop002:10000> select * from user_orc limit 5; 0: jdbc:hive2://hadoop002:10000
connect jdbc:hive2://localhost:10000/;principal=hive/ip-172-31-6-148.fayson.com@FAYSON.COM ... 0: jdbc...INFO : OK No rows affected (0.183 seconds) 0: jdbc:hive2://localhost:10000/> grant select(s1) on table...INFO : OK No rows affected (0.105 seconds) 0: jdbc:hive2://localhost:10000/> grant role columnread to...isolation: TRANSACTION_REPEATABLE_READ 0: jdbc:hive2://localhost:10000/> show databases; ......:hive2://localhost:10000/> show tables; ...
-u jdbc:hive2://localhost:10000 或者 /opt/hive/bin/hive (6)开启你的Hive on spark之旅 0: jdbc:hive2://localhost...jdbc:hive2://localhost:10000> insert into test values(1,2); Spark sql on Hive (1)获取包 Hive版本:apache-hive...hive或impala,可以启用sparkthriftserver服务,然后利用beeline远程连接spark,利用spark sql。...sparkthriftserver:spark的服务,远程通过jdbc或者beeline连接spark,使用spark sql操作hive。.../beeline -u jdbc:hive2://172.168.108.6:10001 -n root (4)这里的sql可以在8088页面看到执行过程。