tencent cloud

--SQL/VMSCRIPT
#set( $cnt = 10 )
select  $cnt;

--SQL/VMSCRIPT
#set( $cnt = 10 )
#set( $cnt = $cnt + 1  )
select $cnt;

--SQL/VMSCRIPT
#set( $cnt = 10 )
#set( $cnt = $cnt + 1  )
#foreach($i in $_range.of(1, $cnt, 1))
select $cnt,$i;
#end

--SQL/VMSCRIPT
--此语句会执行age>2的分支
#set( $flag_1 = 0 )
#set( $flag_2 = 0 )
select * from  default.demo_hive
where 
#if($flag_1 == 1)
id = 1;
#elseif( $flag_2 == 1)
id = 2;
#else
id >2;
#end

--SQL/VMSCRIPT
--此语句会执行age>2的分支
select * from  default.demo_hive
where 
#if(${flag_1} == 1)
age = 1;
#elseif(${flag_2} == 1)
age = 2;
#else
age >2;
#end

--SQL/VMSCRIPT
--此语句会执行else的分支
select * from  default.user_info  
where 
#if(${is_reload} == "1")
create_time <= ${dt};
#elseif(${is_deltareload} == "1")
create_time  between ${dt_pre_7d} and  ${dt};
#else
create_time  between ${dt_pre_1d} and  ${dt};
#end