crr121 - 博客园

摘要：创建表（条件之间不能有逗号 fields terminated by ',' 字段之间以逗号分隔）0: jdbc:hive2://localhost:10000/cr> create table if not exists teacher(id int,name s... 阅读全文

posted @ 2018-08-19 11:26 crr121 阅读(1694) 评论(0) 推荐(0)

摘要： beeline> !connect jdbc:hive2://localhost:10000/crConnecting to jdbc:hive2://localhost:10000/crEnter username for jdbc:hive2://localhos... 阅读全文

posted @ 2018-08-19 11:26 crr121 阅读(8297) 评论(0) 推荐(0)

摘要： hive的访问：终端访问远程访问终端访问：安装hive，利用shell脚本访问不可并发访问远程访问：通过JDBC连接数据仓库支持并发访问启动hiveserver2服务：查看该命令可知hiveserver2,等价于hive --service hiveserve... 阅读全文

posted @ 2018-08-19 11:26 crr121 阅读(942) 评论(0) 推荐(0)

摘要： 0: jdbc:hive2://localhost:10000/cr> insert into student values(4,'sunny');WARNING: Hive-on-MR is deprecated in Hive 2 and may not be a... 阅读全文

posted @ 2018-08-19 11:26 crr121 阅读(2023) 评论(0) 推荐(0)

摘要： [xiaoqiu@s150 /soft/hive/conf]$ schematool -initSchema -dbType mysqlSLF4J: Class path contains multiple SLF4J bindings.SLF4J: Found bi... 阅读全文

posted @ 2018-08-19 11:25 crr121 阅读(511) 评论(0) 推荐(0)

摘要：当执行下面的命令时出现上述errorMariaDB [(none)]> grant all privileges on hive_meta.* to 'xiaoqiu'@'%';ERROR 1133 (42000): Can't find any matching r... 阅读全文

posted @ 2018-08-19 11:25 crr121 阅读(1677) 评论(0) 推荐(0)

摘要： Access denied for user xiaoqiu@localhost (using password :NO) resolution:删除匿名用户（mysql.user表中user为空的用户）delete from user where mysql.us... 阅读全文

posted @ 2018-08-19 11:25 crr121 阅读(204) 评论(0) 推荐(0)

摘要： 2018-08-06T13:40:10,699 ERROR [41e6cbb7-d859-4b90-8375-c9808c786abc main] metastore.RetryingHMSHandler: Retrying HMSHandler after 2000... 阅读全文

posted @ 2018-08-19 11:24 crr121 阅读(419) 评论(0) 推荐(0)

摘要： java.net.ConnectException: Call From s150/192.168.109.150 to s153:8020 failed on connection exception: java.net.ConnectException: Conn... 阅读全文

posted @ 2018-08-19 11:24 crr121 阅读(607) 评论(0) 推荐(0)

摘要：错误提示如下：FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTaskMapReduce Jobs Launched:Stage-Stage-1:... 阅读全文

posted @ 2018-08-19 11:24 crr121 阅读(710) 评论(0) 推荐(0)

仰望星空脚踏实地