Slide 28
Slide 28 text
28
Copyright © since 1998 DMM All Rights Reserved.
$5"4CZ
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
;