syntax
SQL:结构化查询语言,是一种用于操作数据库的语言,它是用于所有数据库的基本语言。MySQL:数据库管理系统,是一个数据库软件或应用程序,它是使用SQL语言来查询数据库。Hive SQL:一种类SQL的查询语言。基于大数据的背景下,传统数据库不能满足我们的工作需求,SQL被广泛应用在数据仓库中,因此专门针对Hive的特性设计了类SQL查询语言HQL当谈到Hive SQL,就不得不提一下Hive!Hive是什么呢?Hive是一个数据仓库工具,用于解决海量结构化日志的数据统计工具。
Mysql优化之Explain详解、索引最佳实践_mysql explain 优化-CSDN博客
索引:
mysql:
mysql表操作 create,drop,desc,alter, inster,update, delete_mysql create alter update-CSDN博客
hive sql:
sum开窗 SUM(结果和ORDER BY相关,默认为升序)_sum order by-CSDN博客
SQL——求用户最长连续登录时间_sql 如何查询连续登录天数-CSDN博客
select id,max(active_day) as max_Continuous_login_days
from (
select id,day,count(day) as active_day
from (
select id,visit_date,r,date_sub(visit_date,interval r day) as day
from (
select id,visit_date,row_number() over(partition by id order by visit_date) r
from user_visit_log) as t
) as t1
group by id,day
) as t2
group by id
select request_id
, cast(slot_id_split as string) slot_id
, coalesce(get_json_object(query_analysis, '$.cate_1')
, get_json_object(query_analysis, '$.cate1'), -1) query_frontcate1
, coalesce(get_json_object(query_analysis, '$.cate_2')
, get_json_object(query_analysis, '$.cate2'), -1) query_frontcate2
, row_number() over(partition by request_id, slot_id_split order by request_time) rowRank
from log.ads_sead_bizer_request_dp a lateral view explode(split(slot_ids, ',')) newtbl as slot_id_split
where dt = '$now.datekey'
and length(slot_ids) > 0
and traffic_type in (1,10)
and length(request_id) > 0