select cookieid,--min(createtime_detail) as r,--求最小值--find_in_set(min(createtime_detail),concat_ws(',',collect_list(cast(createtime_detail as string))))-1 as r1--求值在数组中的索引
collect_list(createtime_detail)[find_in_set(min(createtime_detail),concat_ws(',',collect_list(cast(createtime_detail as string))))-1]as time_listfrist,--求值
collect_list(createtime_detail)[find_in_set(max(createtime_detail),concat_ws(',',collect_list(cast(createtime_detail as string))))-1]as time_listend,
collect_list(pv)[find_in_set(min(createtime_detail),concat_ws(',',collect_list(cast(createtime_detail as string))))-1]as pv_createtime_detail_min,
collect_list(pv)[find_in_set(max(createtime_detail),concat_ws(',',collect_list(cast(createtime_detail as string))))-1]as pv_createtime_detail_max
from cookie
groupby cookieid;