presto 查询每天固定时间段
2024-09-05 02:40:09
select task_id,state,createymd,from_unixtime(createtime) "创建时间",manager_name,open_state,hosted_amount,hosted_date,hosted_time,hosted,
is_deal,deal_amout,order_mode,order_stype,order_id,manager_id,from_unixtime(close_time) "关闭时间"
from hive.bdc_dwd.dw_fact_task_new_ss_daily
where acct_time=format_datetime(date_add('day',-1,current_timestamp),'yyyy-MM-dd')
and order_mode not in (2,3,6,7)
and par_order_id = 0
and (from_cid in (149,192,199,121,126,127,130,197,191,198) or category1id in (4782,5892))
and category1id not in(4,9,21,448,2107,5787,5857,5788,4788,4791,3064)
and cast(from_unixtime(createtime) as varchar) BETWEEN concat(FORMAT_DATETIME(DATE_ADD('day',-1,CURRENT_TIMESTAMP),'yyyy-MM-dd'),' ','09:00:00') and
concat(FORMAT_DATETIME(DATE_ADD('day',-1,CURRENT_TIMESTAMP),'yyyy-MM-dd'),' ','12:00:00')
最新文章
- React-webpack开发需要的那些坑
- 利用mysql_multi来管理多实例:
- iOS 端的第三方语音识别库
- 树--四分树(UVa297)
- 动态生成xml文件
- SQL Server 调优:set statistics profile on
- ObjectOutputStream 追加写入读取错误
- 【Android 错误记录】Conversion to Dalvik format failed with error 1 错误
- UVa 12299 RMQ with Shifts(线段树)
- HTML5调用摄像头实现拍照功能(兼容各大主流浏览器)
- Linux常用Shell脚本珍藏【转载】
- 【SQL】- 基础知识梳理(六) - 游标
- hdu4686 Arc of Dream 2013 Multi-University Training Contest 9矩阵快速幂
- .Net Core在Ubuntu上操作MySql折腾实录
- Web前端开发好学吗?谈谈一位学姐的前端工程师之路
- 希尔排序(Go语言)
- MATLAB程序控制语句
- html5-常用的3个基本标签
- Win10 安装 Anaconda3 用 Anaconda3 安装TensorFlow 1.2 (只支持python3.5)
- Docker技术入门与实战 第二版-学习笔记-10-Docker Machine 项目-2-driver