hive
qq_42506914
这个作者很懒,什么都没留下…
展开
-
hive 安装mysql,启动hive异常和建表时候异常
一、启动hive异常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...原创 2019-01-14 16:44:14 · 440 阅读 · 0 评论 -
sql练习一(蚂蚁森林)
背景说明:以下表记录了用户每天的蚂蚁森林低碳生活领取的记录流水。table_name:user_low_carbonseq(key)user_iddata_dtlow_carbon流水号用户日期减少碳排放(g)xxxxx01u_0012017/1/110xxxxx02u_0012017/1/2150xxx...原创 2019-03-17 11:02:48 · 1597 阅读 · 0 评论 -
hive练习
学生课程成绩use myhive;CREATE TABLE `course` ( `id` int, `sid` int , `course` string, `score` int ) ;// 插入数据// 字段解释:id, 学号, 课程, 成绩INSERT INTO `course` VALUES (1, 1, 'yuwen', 43);INSERT IN...原创 2019-03-25 20:21:38 · 230 阅读 · 0 评论 -
hive sql练习
字段说明:** 用户名,月份,访问次数数据内容如下A,2015-01,5A,2015-01,15B,2015-01,5A,2015-01,8B,2015-01,25A,2015-01,5A,2015-02,4A,2015-02,6B,2015-02,10B,2015-02,5A,2015-03,16A,2015-03,22B,2015-03,23B,2015...原创 2019-03-23 08:16:27 · 234 阅读 · 0 评论