hive面试题目：表大概有2T左右，对表数据转换

学习了

不懂啊啊 啊啊啊啊

0.0学习学习

学习学习,那不错的

学习学习,那不错的

纯HQL ，不是可以用row_number和lag()over()实现么

xin07020220 发表于 2014-8-28 23:06
对于第二题，当同一个user_id在不同的platform中出现时，此SQL是会有问题的。
a表与b表的关联条件应为 o ...

INSERT OVERWRITE TABLE ALLOG
SELECT t1.platform,t1.user_id,t1.seq,t2.click_url FROM_URL,t1.click_url TO_URL FROM
(SELECT platform,user_id,click_time,click_url,count(1) seq FROM (SELECT a.*,b.click_time click_time1,b.click_url click_url2  FROM trlog a left outer join trlog b on a.user_id = b.user_id and a.platform=b.platform)t WHERE click_time>=click_time1 GROUP BY platform,user_id,click_time,click_url)t1
LEFT OUTER JOIN
(SELECT platform,user_id,click_time,click_url,count(1) seq FROM (SELECT a.*,b.click_time click_time1,b.click_url click_url2  FROM trlog a left outer join trlog b on a.user_id = b.user_id and a.platform=b.platform)t WHERE click_time>=click_time1 GROUP BY platform,user_id,click_time,click_url )t2
on t1.user_id = t2.user_id and t1.platform=t2.platform and t1.seq = t2.seq + 1;

学习了 ,虽然看不懂