这是题目
数据结构
这里是数据依次表头解释
我现在写的是:
insert overwrite local directory '/usr/io/bike4' row format delimited fields terminated by '\t' select from_unixtime(unix_timestamp(regexp_replace('2021/10/25 06:55:42','/','-')),'yyyy-MM-dd'),bikenum,count(startdate) as a from io group by bikenum sort by a desc;