XJUICMPDL CBUDI with test as ( select 1 num ) create table hive.adhoc.ctas_test_ng as select * from test ; create table hive.adhoc.ctas_test_ok as with test as ( select 1 num ) select * from test ; XJUI۟ΛDSFBUFจͰ͏߹ɺઌʹDSFBUFΛॻ͘ /( 0, with test as ( select 2 num ) insert into hive.adhoc.ctas_test_ok select * from test ; insert into hive.adhoc.ctas_test_ok with test as ( select 2 num ) select * from test ;