- 博客(2)
- 问答 (1)
- 收藏
- 关注
原创 Hive添加自增列
select row_number() over(order by 1) as id, a.* from dp_ipo_tmp.tmp_ipo_yekuai_118_2018q4_06 a where Finterest_date <= '2018-12-31' 代码line2所示,即为添加的自增id列
2019-01-29 16:47:58 7787 1
原创 Add to group by or wrap in first() (or first_value) if you don't care which value you get. 报错解决方案
SELECT SUBSTR(i.fdate,1,10) fdate ,Ftype ,SUM(i.Fdate_interest/100-i.Fpetty_date_ticket/1000000) fbase_interest ,SUM(Fpetty_date_ticket)/1000000 fticket_interest FROM jz_snap.finance_db_t_finance_up_...
2019-01-25 14:44:42 4789
空空如也
Caused by: java.lang.ClassNotFoundException
2017-03-31
TA创建的收藏夹 TA关注的收藏夹
TA关注的人