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'