![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
hive
Mr_Jia_Yuan
生而为人,什么是正确
展开
-
hive beeline 跑历史数据
!/bin/bash #dt1=`date "+%Y-%m-%d"` d=2020-01-01 while [ "$d" != 2020-11-11 ]; do dt2=$d dt1=`date -d"$dt2" "+%Y%m%d"` echo $dt2 echo $dt1 beeline --showHeader=true -u "jdbc:hive2://****:10000/default" -n xxx -p XXX --incremental=true** -f ./.原创 2020-11-12 20:16:44 · 364 阅读 · 0 评论 -
hive split by “.”; hive 按句点切分
一些特殊字符的切分 > desc function split; > split(str, regex) - Splits str around occurances that match regex > select split('1.3.4.6','.'); +----------------------------+--+ | ["","","","","","","",""] | +----------------------------+--+ > sel.原创 2020-11-09 10:02:27 · 704 阅读 · 1 评论