1、查询连续登录天数题:数据表metaInfo中包含uid,event_day字段,现要查找用户的最大连续登录天数select uid, max(continue_day) as login_day from ( select uid, date_sub(event_day, rank) as df, c...
1、hive语句1)lateral view explode-- LATERAL VIEW udtf(expression) tableAlias AS columnAlias (’,’ columnAlias) tableAlias:表别名 columnAlias:表中的列别名-- explode() takes in an array (or a map) as an input and...
1、Doris建表mysql> show create table myTable \G *************************** 1. row *************************** Table: myTable Create Table: CREATE TABLE `myTable` ( `event_day` int(11) NOT...