hxiaowang的博客

Hive 多数组合并 使用CONCAT_WS和split 完成多个数组合成一个数组

面试总结

with loin_format as( selectuser_id,dt,case when cast(hour(login_time) as int) <=4 then concat( (cast(hour(login_time) as int) + 24),'@',login_time) else concat(hour(login_time) ,'@',login_time) end as login_time_formatfrom ods.user_login ..

表结构id int 主键 projectid int 项目id createdate string 创建时间id projectid createdate 8 179 2019-01-03 1...

1. 等值比较: =语法：A=B操作类型：所有基本类型描述: 如果表达式A与表达式B相等，则为TRUE；否则为FALSE举例：hive>select 1 from test_table where 1=1;2. 不等值比较: <>语法: A <> B操作类型: 所有基本类型描述: 如果表达式A为NULL，或者表达式B为NULL，返回NULL；如果表达式A与表达式B不相等，则为TRUE；否则为FALSE举例：hive> select1 from tes

select unix_timestamp(checktime,'yyyy-MM-dd HH:mm')- unix_timestamp(applytime,'yyyy-MM-dd HH:mm')/60,checkuser from tableau.home_person_check_time limit 10;

hive cli 中 使用shell命令只要命令前加！并且以；结尾就可以了hive> > !pwd;/data/home/dwhive> 在hive内使用hadoop 的dfs 命令hive> dfs -ls;Found 14 itemsdrwx------ - dw dw 0 2020-03-18 08:0...

/build/env/bin/hue close_queries 0 清理hue请求/build/env/bin/hue close_sessions 0 hive 清理hue h2 sessions

原数据：[{"s_id":"0","s_name":"NEW"},{"s_id":"0","s_name":"A"}]使用方法hive ①:get_json_object(translate(translate(ab_test,'}{',''),'[|]','{|}'),'$.name')结果 Atranslate(ab_test,'}{','') ==>["s_id":...

干货Aggregate Query with GROUPING SETSEquivalent Aggregate Query with GROUP BYSELECT a, b, SUM(c) FROM tab1 GROUP BY a, b GROUPING SETS ( (a,b) )SELECT a, b, SUM(c) FROM tab1 GROUP BY a, bSELECT a, b, S...

select post_id, concat_ws(',',collect_set(tag_name)) tag_name from ( select post_id, tagid tag_id from ods.ods_remymartin_rtm_post lateral view explode(split(substring(post_tag,2,length(post_ta

  今天写几个hive函数， find_in_set,get_json_object,lateral view explode，方便以后查找话不多说开干。find_in_set函数说两点1.使用方法FIND_IN_SET(str,strlist) SELECT FIND_IN_SET('b','a,b,c,d'); -&gt; 2 SELECT FIND_IN_SET('e','a...

文章来自：https://blog.youkuaiyun.com/gavin_chun/article/details/78174492一、静态分区 1、创建分区表hive (default)&gt; create table order_mulit_partition( &gt; order_number string, &gt; event_time...