- 博客(4)
- 收藏
- 关注
RSS订阅原创 Greenplum笔记
Greenplum笔记SCT项目，原始数据需入到GP库，这里记录一些简单的常用操作。1.查看数据库列表\l2.查看某shema下(以stg_bi为例)所有表\dt stg_bi.3.创建schemacreate schema stg_bi;4.给新建的schema赋予权限grant usage on schema stg_bi to daedb with grant option5.向表中插入数据insert into table_name values(1,1,1,1);...
2020-08-17 14:40:59
115
原创 hql排序函数之row_number,rank,dense_rank,ntile
1.原表select cid , score from score where cid = 2;以hive为例，显示课程编号为2的所有成绩2.row_number排序效果select cid ,score,row_number() over(order by score desc) as num from score where cid = 2;3.rank排序效果select cid ,score，rank() over(order by score desc) as num fro
2020-06-25 16:22:29
963
1
原创 虚拟机下hive连接win10上mysql的故障排除
这里写自定义目录标题1.安装环境问题1：Class path contains multiple SLF4J bindings问题2：Client dose not support authentication protocol requested by sever ; consider upgrading mysql client问题3：The server time zone value ...
2019-06-30 19:23:23
327
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人