首页 > 其他 > 详细

Hive实现自增列

时间:2017-10-17 21:37:45      阅读:807      评论:0      收藏:0      [点我收藏+]

1、用row_number()函数生成代理键

insert into table id_test 

select row_number() over() + t2.max_id as id, t1.name
from (select name from nametb) t1

cross join (select coalesce(max(id),0) max_id from id_test) t2;

 

2、用UDFRowSequence生成代理键              ——报错?

add jar /usr/local/hive.bak/lib/hive-contrib-2.1.1.jar;

create temporary function row_sequence as org.apache.hadoop.hive.contrib.udf.udfrowsequence; insert into tbl_dim select row_sequence() + t2.sk_max,
nametb.* from nametb
cross join (select coalesce(max(sk),0) sk_max from tbl_dim) t2;

 

Hive实现自增列

原文:http://www.cnblogs.com/qiuhong10/p/7607655.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!