摘要:
创建表(条件之间不能有逗号 fields terminated by ',' 字段之间以逗号分隔)0: jdbc:hive2://localhost:10000/cr> create table if not exists teacher(id int,name s... 阅读全文
beeline连接数据库报错Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10000/cr: java.n
摘要:
beeline> !connect jdbc:hive2://localhost:10000/crConnecting to jdbc:hive2://localhost:10000/crEnter username for jdbc:hive2://localhos... 阅读全文
摘要:
hive的访问:终端访问 远程访问终端访问:安装hive,利用shell脚本访问 不可并发访问远程访问:通过JDBC连接数据仓库 支持并发访问启动hiveserver2服务:查看该命令可知hiveserver2,等价于hive --service hiveserve... 阅读全文
beeline执行insert命令时报错Permission denied: user=anonymous, access=EXECUTE, inode="/tmp/hadoop-yarn":xiao
摘要:
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... 阅读全文
摘要:
Access denied for user xiaoqiu@localhost (using password :NO) resolution:删除匿名用户(mysql.user表中user为空的用户)delete from user where mysql.us... 阅读全文
摘要:
当执行下面的命令时出现上述errorMariaDB [(none)]> grant all privileges on hive_meta.* to 'xiaoqiu'@'%';ERROR 1133 (42000): Can't find any matching r... 阅读全文
摘要:
[xiaoqiu@s150 /soft/hive/conf]$ schematool -initSchema -dbType mysqlSLF4J: Class path contains multiple SLF4J bindings.SLF4J: Found bi... 阅读全文
摘要:
现在有两张表customer和order,需要通过customerid实现customer和order的连接mapperpackage com.cr.JoinMap;import org.apache.hadoop.conf.Configuration;import ... 阅读全文
摘要:
错误提示如下:FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTaskMapReduce Jobs Launched:Stage-Stage-1:... 阅读全文
摘要:
java.net.ConnectException: Call From s150/192.168.109.150 to s153:8020 failed on connection exception: java.net.ConnectException: Conn... 阅读全文