Presto常用命令
一、常用命令
1、官方文档:https://prestodb.io/docs/current/connector/system.html?highlight=kill
2、kill任务,登录presto客户端
CALL system.runtime.kill_query(query_id => '20220317_083239_04518_ik27u', message => 'Using too many resources');
3、LATERAL VIEW
select col_id,col_type,col_type
,nvl(json_temp.exl_page,"") as exl_page
from dw.dm_tab1 LATERAL VIEW
json_tuple(params,'page') json_temp as exl_page where dt = '20220725'