weixin_42285610的博客

---------------------------------------------------------------------------------------------------------------hive--------------------customeridselect s_customer_profile_day.customerid from (select customerid, devset.deviceid from devicepro.

array_position实现自定义排序presto sql的查询结果期望按照固定顺序输出，可以使用array_position函数。`select LaunchSource from tableorder by array_position(array['all','FTE','setting'],LaunchSource) ` 其中LaunchSource为排序依赖的字段，array内字符串可自定义，以此实现自定义排序presto 计算当月天数的公式select day_of_mont