hive
文章平均质量分 92
周小西zxx
学生党一枚,网上找教程自学的心得和记录,只是随笔记录,可能部分没有写的很详细
展开
-
hive插入数据失败FAILED: SemanticException [Error 10293]: Unable to create temp file for insert values File
向数据库插入数据失败,报错hive> insert into table a1 values(1,‘zzz’);FAILED: SemanticException [Error 10293]: Unable to create temp file for insert values File /tmp/hive/root/8af3f6fb-7116- could only be replicated to 0 nodes instead of minReplication (=1). The原创 2020-08-26 04:20:30 · 3494 阅读 · 0 评论 -
Hive
数据仓库通过sql语言管理hdfs上的数据,底层转化为MapReduce,效率很低。适合离线分析/批处理。将hive默认数据库调整为mysql后,每次启动hive需要先启动hadoop集群和数据库,再启动hivestart-all.sh #启动hadoopservice mysql start #启动数据库sh hive #进入hive操作页面没有主键的概念insert overwrite表示覆盖,insert into 追加创建表> create原创 2020-08-28 19:37:20 · 196 阅读 · 0 评论 -
hive启动失败Caused by: java.net.ConnectException: Connection refused
hive启动失败,遇到以下错误[root@hadoop01 bin]# hiveLogging initialized using configuration injar:file:/home/software/hive/lib/hive-common-1.2.0.jar!/hive-log4j.propertiesException in thread “main” java.lang.RuntimeException:java.net.ConnectException: Call From原创 2020-08-26 02:05:51 · 2088 阅读 · 0 评论 -
hive启动失败READ COMMITTED, hive创建表失败org.apache.hadoop.hive.ql.exec.DDLTask. MetaException问题总结
hive元数据使用mysql,发现hive启动和在hive中创建表失败的BUG。启动失败报错提示:Caused by: java.sql.SQLException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. Inn原创 2020-08-19 11:04:55 · 912 阅读 · 0 评论