select abs(tinyint_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select acos(u_tinyint_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select asin(u_tinyint_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select atan(u_tinyint_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select ceil(tinyint_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select cos(u_tinyint_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select floor(tinyint_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select log(tinyint_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select pow(tinyint_col, 2) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select round(double_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select sin(u_tinyint_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select sqrt(u_tinyint_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select tan(u_tinyint_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select PI() from test_vtable_select.vtb_virtual_ntb_full limit 50;
select PI(), u_tinyint_col from test_vtable_select.vtb_virtual_ntb_full limit 50;
select exp(tinyint_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select ln(tinyint_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select mod(tinyint_col, 10) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select sign(tinyint_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select degrees(u_tinyint_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select radians(u_tinyint_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select char_length(binary_16_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select concat(binary_16_col, binary_32_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select concat_ws(' ', binary_16_col, binary_32_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select length(binary_16_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select lower(binary_32_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select upper(binary_32_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select ltrim(binary_32_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select rtrim(binary_32_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select substring(nchar_32_col, 1, 5) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select substring_index(nchar_32_col, ' ', 1) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select char(u_tinyint_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select ascii(binary_32_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select position(' ' IN binary_32_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select repeat(binary_32_col, 2) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select replace(binary_32_col, ' ', '_') from test_vtable_select.vtb_virtual_ntb_full limit 50;
select cast(u_tinyint_col as nchar(16)) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select to_ISO8601(ts) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select to_unixtimestamp(to_ISO8601(ts)) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select to_char(ts, 'YYYY-MM-DD HH24:MI:SS') from test_vtable_select.vtb_virtual_ntb_full limit 50;
select timetruncate(ts, 1a) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select week(ts) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select dayofweek(ts) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select weekofyear(ts) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select weekday(ts) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select apercentile(int_col, 10) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select avg(int_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select count(int_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select count(*) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select elapsed(ts) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select leastsquares(int_col, 0, 1) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select spread(int_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select stddev(int_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select sum(int_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select var_pop(int_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select hyperloglog(int_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select percentile(int_col, 0.5) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select bottom(int_col, 10) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select top(int_col, 10) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select first(int_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select first(*) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select interp(u_smallint_col) from test_vtable_select.vtb_virtual_ntb_full where u_tinyint_col > 0 and u_int_col > 0 RANGE('2020-10-01 00:00:00.000', '2020-10-01 00:01:00.000') EVERY (2a) FILL(linear) limit 50;
select last(int_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select last(*) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select last_row(int_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select last_row(*) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select max(int_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select min(int_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select mode(int_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select tail(int_col, 20) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select unique(u_tinyint_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select csum(u_tinyint_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select derivative(int_col, 5a, 1) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select diff(int_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select irate(int_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select mavg(int_col, 100) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select statecount(u_tinyint_col, "GT", 20) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select stateduration(u_tinyint_col, "GT", 20, 1a) from test_vtable_select.vtb_virtual_ntb_full limit 50;
select twa(int_col) from test_vtable_select.vtb_virtual_ntb_full limit 50;

