qq_42454058的博客

1.开窗函数over（）开窗函数，其括号内部主要有两种形式，固定搭配，不能更改：over(partition by…order by… )和over(distribute by…sort by…)2.两种开窗方式区别patition by是按照一个一个reduce去处理数据的，所以要使用全局排序order bydistribute by是按照多个reduce去处理数据的，所以对应的排序是局部排序sort by3.开窗函数的窗口大小问题窗口大小：hive的窗口大小默认是从起始行到当前行的ti

--多行合成一行with tmp as (select 'CQH8885' AS callsign,20200501 as tobt,null as asbt,null as aobtunion allselect 'CQH8885' AS callsign,null as tobt,20200522 as asbt,null as aobtunion allselect 'CQH8885' AS callsign,null as tobt,null as asbt,20200523 as...

1.获取到当前日期hive> select current_date();OK2020-11-14Time taken: 0.036 seconds, Fetched: 1 row(s)2.获取到当前日期和时间hive> select current_timestamp();OK2020-11-14 09:38:27.674Time taken: 0.044 seconds, Fetched: 1 row(s)3.获取到当前的时间戳hive> select uni

null值(一般说空值)就是不写 再mysql背景显示null空字符串就是写了任何东西后删除就变成了空字符串CREATE TABLE test_null (id int,value_1 varchar(128),value_2 varchar(128) not null);1.条件查询select * from test_null where value_1='';select * from tset_null where value_1 is null;2.参与运算select

前提安装好mysql在一台分布式集群上（例如hadoop02）参照：