select tb1.binary_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.binary_16_col is not null group by tb1.binary_16_col having tb1.binary_16_col is not null order by 1 slimit 20 limit 20;
select tb1.binary_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.binary_16_col is not null group by tb1.binary_16_col having tb1.binary_16_col is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select tb1.nchar_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.nchar_16_col is not null group by tb1.nchar_16_col having tb1.nchar_16_col is not null order by 1 slimit 20 limit 20;
select tb1.nchar_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.nchar_16_col is not null group by tb1.nchar_16_col having tb1.nchar_16_col is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select round( tb1.int_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.int_col ) is not null group by round( tb1.int_col ) having round( tb1.int_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.int_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.int_col ) is not null group by round( tb1.int_col ) having round( tb1.int_col ) is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.int_col is not null group by tb1.int_col + tb1.int_col having tb1.int_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.int_col is not null group by tb1.int_col + tb1.int_col having tb1.int_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.bigint_col is not null group by tb1.int_col + tb1.bigint_col having tb1.int_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.bigint_col is not null group by tb1.int_col + tb1.bigint_col having tb1.int_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.smallint_col is not null group by tb1.int_col + tb1.smallint_col having tb1.int_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.smallint_col is not null group by tb1.int_col + tb1.smallint_col having tb1.int_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.tinyint_col is not null group by tb1.int_col + tb1.tinyint_col having tb1.int_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.tinyint_col is not null group by tb1.int_col + tb1.tinyint_col having tb1.int_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.float_col is not null group by tb1.int_col + tb1.float_col having tb1.int_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.float_col is not null group by tb1.int_col + tb1.float_col having tb1.int_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.double_col is not null group by tb1.int_col + tb1.double_col having tb1.int_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.double_col is not null group by tb1.int_col + tb1.double_col having tb1.int_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.bigint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.bigint_col ) is not null group by round( tb1.bigint_col ) having round( tb1.bigint_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.bigint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.bigint_col ) is not null group by round( tb1.bigint_col ) having round( tb1.bigint_col ) is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.int_col is not null group by tb1.bigint_col + tb1.int_col having tb1.bigint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.int_col is not null group by tb1.bigint_col + tb1.int_col having tb1.bigint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.bigint_col is not null group by tb1.bigint_col + tb1.bigint_col having tb1.bigint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.bigint_col is not null group by tb1.bigint_col + tb1.bigint_col having tb1.bigint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.smallint_col is not null group by tb1.bigint_col + tb1.smallint_col having tb1.bigint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.smallint_col is not null group by tb1.bigint_col + tb1.smallint_col having tb1.bigint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.tinyint_col is not null group by tb1.bigint_col + tb1.tinyint_col having tb1.bigint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.tinyint_col is not null group by tb1.bigint_col + tb1.tinyint_col having tb1.bigint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.float_col is not null group by tb1.bigint_col + tb1.float_col having tb1.bigint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.float_col is not null group by tb1.bigint_col + tb1.float_col having tb1.bigint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.double_col is not null group by tb1.bigint_col + tb1.double_col having tb1.bigint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.double_col is not null group by tb1.bigint_col + tb1.double_col having tb1.bigint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.smallint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.smallint_col ) is not null group by round( tb1.smallint_col ) having round( tb1.smallint_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.smallint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.smallint_col ) is not null group by round( tb1.smallint_col ) having round( tb1.smallint_col ) is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.int_col is not null group by tb1.smallint_col + tb1.int_col having tb1.smallint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.int_col is not null group by tb1.smallint_col + tb1.int_col having tb1.smallint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.bigint_col is not null group by tb1.smallint_col + tb1.bigint_col having tb1.smallint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.bigint_col is not null group by tb1.smallint_col + tb1.bigint_col having tb1.smallint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.smallint_col is not null group by tb1.smallint_col + tb1.smallint_col having tb1.smallint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.smallint_col is not null group by tb1.smallint_col + tb1.smallint_col having tb1.smallint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.tinyint_col is not null group by tb1.smallint_col + tb1.tinyint_col having tb1.smallint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.tinyint_col is not null group by tb1.smallint_col + tb1.tinyint_col having tb1.smallint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.float_col is not null group by tb1.smallint_col + tb1.float_col having tb1.smallint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.float_col is not null group by tb1.smallint_col + tb1.float_col having tb1.smallint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.double_col is not null group by tb1.smallint_col + tb1.double_col having tb1.smallint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.double_col is not null group by tb1.smallint_col + tb1.double_col having tb1.smallint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.tinyint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.tinyint_col ) is not null group by round( tb1.tinyint_col ) having round( tb1.tinyint_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.tinyint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.tinyint_col ) is not null group by round( tb1.tinyint_col ) having round( tb1.tinyint_col ) is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.int_col is not null group by tb1.tinyint_col + tb1.int_col having tb1.tinyint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.int_col is not null group by tb1.tinyint_col + tb1.int_col having tb1.tinyint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.bigint_col is not null group by tb1.tinyint_col + tb1.bigint_col having tb1.tinyint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.bigint_col is not null group by tb1.tinyint_col + tb1.bigint_col having tb1.tinyint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.smallint_col is not null group by tb1.tinyint_col + tb1.smallint_col having tb1.tinyint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.smallint_col is not null group by tb1.tinyint_col + tb1.smallint_col having tb1.tinyint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.tinyint_col is not null group by tb1.tinyint_col + tb1.tinyint_col having tb1.tinyint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.tinyint_col is not null group by tb1.tinyint_col + tb1.tinyint_col having tb1.tinyint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.float_col is not null group by tb1.tinyint_col + tb1.float_col having tb1.tinyint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.float_col is not null group by tb1.tinyint_col + tb1.float_col having tb1.tinyint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.double_col is not null group by tb1.tinyint_col + tb1.double_col having tb1.tinyint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.double_col is not null group by tb1.tinyint_col + tb1.double_col having tb1.tinyint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.float_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.float_col ) is not null group by round( tb1.float_col ) having round( tb1.float_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.float_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.float_col ) is not null group by round( tb1.float_col ) having round( tb1.float_col ) is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.int_col is not null group by tb1.float_col + tb1.int_col having tb1.float_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.int_col is not null group by tb1.float_col + tb1.int_col having tb1.float_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.bigint_col is not null group by tb1.float_col + tb1.bigint_col having tb1.float_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.bigint_col is not null group by tb1.float_col + tb1.bigint_col having tb1.float_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.smallint_col is not null group by tb1.float_col + tb1.smallint_col having tb1.float_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.smallint_col is not null group by tb1.float_col + tb1.smallint_col having tb1.float_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.tinyint_col is not null group by tb1.float_col + tb1.tinyint_col having tb1.float_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.tinyint_col is not null group by tb1.float_col + tb1.tinyint_col having tb1.float_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.float_col is not null group by tb1.float_col + tb1.float_col having tb1.float_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.float_col is not null group by tb1.float_col + tb1.float_col having tb1.float_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.double_col is not null group by tb1.float_col + tb1.double_col having tb1.float_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.double_col is not null group by tb1.float_col + tb1.double_col having tb1.float_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.double_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.double_col ) is not null group by round( tb1.double_col ) having round( tb1.double_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.double_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.double_col ) is not null group by round( tb1.double_col ) having round( tb1.double_col ) is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.int_col is not null group by tb1.double_col + tb1.int_col having tb1.double_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.int_col is not null group by tb1.double_col + tb1.int_col having tb1.double_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.bigint_col is not null group by tb1.double_col + tb1.bigint_col having tb1.double_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.bigint_col is not null group by tb1.double_col + tb1.bigint_col having tb1.double_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.smallint_col is not null group by tb1.double_col + tb1.smallint_col having tb1.double_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.smallint_col is not null group by tb1.double_col + tb1.smallint_col having tb1.double_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.tinyint_col is not null group by tb1.double_col + tb1.tinyint_col having tb1.double_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.tinyint_col is not null group by tb1.double_col + tb1.tinyint_col having tb1.double_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.float_col is not null group by tb1.double_col + tb1.float_col having tb1.double_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.float_col is not null group by tb1.double_col + tb1.float_col having tb1.double_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.double_col is not null group by tb1.double_col + tb1.double_col having tb1.double_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.double_col is not null group by tb1.double_col + tb1.double_col having tb1.double_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select "test1234!@#$%^&*():'><?/.,][}{" from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where "test1234!@#$%^&*():'><?/.,][}{" is not null group by "test1234!@#$%^&*():'><?/.,][}{" having "test1234!@#$%^&*():'><?/.,][}{" is not null order by 1 slimit 20 limit 20;
select "test1234!@#$%^&*():'><?/.,][}{" from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where "test1234!@#$%^&*():'><?/.,][}{" is not null group by "test1234!@#$%^&*():'><?/.,][}{" having "test1234!@#$%^&*():'><?/.,][}{" is not null order by 1 slimit 20 limit 20;
select tb1.binary_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.binary_16_col is not null group by tb1.binary_16_col having tb1.binary_16_col is not null order by 1 slimit 20 limit 20;
select tb1.binary_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.binary_16_col is not null group by tb1.binary_16_col having tb1.binary_16_col is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select tb1.nchar_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.nchar_16_col is not null group by tb1.nchar_16_col having tb1.nchar_16_col is not null order by 1 slimit 20 limit 20;
select tb1.nchar_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.nchar_16_col is not null group by tb1.nchar_16_col having tb1.nchar_16_col is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select round( tb1.int_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.int_col ) is not null group by round( tb1.int_col ) having round( tb1.int_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.int_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.int_col ) is not null group by round( tb1.int_col ) having round( tb1.int_col ) is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.int_col is not null group by tb1.int_col + tb1.int_col having tb1.int_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.int_col is not null group by tb1.int_col + tb1.int_col having tb1.int_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.bigint_col is not null group by tb1.int_col + tb1.bigint_col having tb1.int_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.bigint_col is not null group by tb1.int_col + tb1.bigint_col having tb1.int_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.smallint_col is not null group by tb1.int_col + tb1.smallint_col having tb1.int_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.smallint_col is not null group by tb1.int_col + tb1.smallint_col having tb1.int_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.tinyint_col is not null group by tb1.int_col + tb1.tinyint_col having tb1.int_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.tinyint_col is not null group by tb1.int_col + tb1.tinyint_col having tb1.int_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.float_col is not null group by tb1.int_col + tb1.float_col having tb1.int_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.float_col is not null group by tb1.int_col + tb1.float_col having tb1.int_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.double_col is not null group by tb1.int_col + tb1.double_col having tb1.int_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.double_col is not null group by tb1.int_col + tb1.double_col having tb1.int_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.bigint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.bigint_col ) is not null group by round( tb1.bigint_col ) having round( tb1.bigint_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.bigint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.bigint_col ) is not null group by round( tb1.bigint_col ) having round( tb1.bigint_col ) is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.int_col is not null group by tb1.bigint_col + tb1.int_col having tb1.bigint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.int_col is not null group by tb1.bigint_col + tb1.int_col having tb1.bigint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.bigint_col is not null group by tb1.bigint_col + tb1.bigint_col having tb1.bigint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.bigint_col is not null group by tb1.bigint_col + tb1.bigint_col having tb1.bigint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.smallint_col is not null group by tb1.bigint_col + tb1.smallint_col having tb1.bigint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.smallint_col is not null group by tb1.bigint_col + tb1.smallint_col having tb1.bigint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.tinyint_col is not null group by tb1.bigint_col + tb1.tinyint_col having tb1.bigint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.tinyint_col is not null group by tb1.bigint_col + tb1.tinyint_col having tb1.bigint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.float_col is not null group by tb1.bigint_col + tb1.float_col having tb1.bigint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.float_col is not null group by tb1.bigint_col + tb1.float_col having tb1.bigint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.double_col is not null group by tb1.bigint_col + tb1.double_col having tb1.bigint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.double_col is not null group by tb1.bigint_col + tb1.double_col having tb1.bigint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.smallint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.smallint_col ) is not null group by round( tb1.smallint_col ) having round( tb1.smallint_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.smallint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.smallint_col ) is not null group by round( tb1.smallint_col ) having round( tb1.smallint_col ) is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.int_col is not null group by tb1.smallint_col + tb1.int_col having tb1.smallint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.int_col is not null group by tb1.smallint_col + tb1.int_col having tb1.smallint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.bigint_col is not null group by tb1.smallint_col + tb1.bigint_col having tb1.smallint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.bigint_col is not null group by tb1.smallint_col + tb1.bigint_col having tb1.smallint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.smallint_col is not null group by tb1.smallint_col + tb1.smallint_col having tb1.smallint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.smallint_col is not null group by tb1.smallint_col + tb1.smallint_col having tb1.smallint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.tinyint_col is not null group by tb1.smallint_col + tb1.tinyint_col having tb1.smallint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.tinyint_col is not null group by tb1.smallint_col + tb1.tinyint_col having tb1.smallint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.float_col is not null group by tb1.smallint_col + tb1.float_col having tb1.smallint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.float_col is not null group by tb1.smallint_col + tb1.float_col having tb1.smallint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.double_col is not null group by tb1.smallint_col + tb1.double_col having tb1.smallint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.double_col is not null group by tb1.smallint_col + tb1.double_col having tb1.smallint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.tinyint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.tinyint_col ) is not null group by round( tb1.tinyint_col ) having round( tb1.tinyint_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.tinyint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.tinyint_col ) is not null group by round( tb1.tinyint_col ) having round( tb1.tinyint_col ) is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.int_col is not null group by tb1.tinyint_col + tb1.int_col having tb1.tinyint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.int_col is not null group by tb1.tinyint_col + tb1.int_col having tb1.tinyint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.bigint_col is not null group by tb1.tinyint_col + tb1.bigint_col having tb1.tinyint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.bigint_col is not null group by tb1.tinyint_col + tb1.bigint_col having tb1.tinyint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.smallint_col is not null group by tb1.tinyint_col + tb1.smallint_col having tb1.tinyint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.smallint_col is not null group by tb1.tinyint_col + tb1.smallint_col having tb1.tinyint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.tinyint_col is not null group by tb1.tinyint_col + tb1.tinyint_col having tb1.tinyint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.tinyint_col is not null group by tb1.tinyint_col + tb1.tinyint_col having tb1.tinyint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.float_col is not null group by tb1.tinyint_col + tb1.float_col having tb1.tinyint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.float_col is not null group by tb1.tinyint_col + tb1.float_col having tb1.tinyint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.double_col is not null group by tb1.tinyint_col + tb1.double_col having tb1.tinyint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.double_col is not null group by tb1.tinyint_col + tb1.double_col having tb1.tinyint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.float_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.float_col ) is not null group by round( tb1.float_col ) having round( tb1.float_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.float_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.float_col ) is not null group by round( tb1.float_col ) having round( tb1.float_col ) is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.int_col is not null group by tb1.float_col + tb1.int_col having tb1.float_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.int_col is not null group by tb1.float_col + tb1.int_col having tb1.float_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.bigint_col is not null group by tb1.float_col + tb1.bigint_col having tb1.float_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.bigint_col is not null group by tb1.float_col + tb1.bigint_col having tb1.float_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.smallint_col is not null group by tb1.float_col + tb1.smallint_col having tb1.float_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.smallint_col is not null group by tb1.float_col + tb1.smallint_col having tb1.float_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.tinyint_col is not null group by tb1.float_col + tb1.tinyint_col having tb1.float_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.tinyint_col is not null group by tb1.float_col + tb1.tinyint_col having tb1.float_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.float_col is not null group by tb1.float_col + tb1.float_col having tb1.float_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.float_col is not null group by tb1.float_col + tb1.float_col having tb1.float_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.double_col is not null group by tb1.float_col + tb1.double_col having tb1.float_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.double_col is not null group by tb1.float_col + tb1.double_col having tb1.float_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.double_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.double_col ) is not null group by round( tb1.double_col ) having round( tb1.double_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.double_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.double_col ) is not null group by round( tb1.double_col ) having round( tb1.double_col ) is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.int_col is not null group by tb1.double_col + tb1.int_col having tb1.double_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.int_col is not null group by tb1.double_col + tb1.int_col having tb1.double_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.bigint_col is not null group by tb1.double_col + tb1.bigint_col having tb1.double_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.bigint_col is not null group by tb1.double_col + tb1.bigint_col having tb1.double_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.smallint_col is not null group by tb1.double_col + tb1.smallint_col having tb1.double_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.smallint_col is not null group by tb1.double_col + tb1.smallint_col having tb1.double_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.tinyint_col is not null group by tb1.double_col + tb1.tinyint_col having tb1.double_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.tinyint_col is not null group by tb1.double_col + tb1.tinyint_col having tb1.double_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.float_col is not null group by tb1.double_col + tb1.float_col having tb1.double_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.float_col is not null group by tb1.double_col + tb1.float_col having tb1.double_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.double_col is not null group by tb1.double_col + tb1.double_col having tb1.double_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.double_col is not null group by tb1.double_col + tb1.double_col having tb1.double_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select "test1234!@#$%^&*():'><?/.,][}{" from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where "test1234!@#$%^&*():'><?/.,][}{" is not null group by "test1234!@#$%^&*():'><?/.,][}{" having "test1234!@#$%^&*():'><?/.,][}{" is not null order by 1 slimit 20 limit 20;
select "test1234!@#$%^&*():'><?/.,][}{" from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where "test1234!@#$%^&*():'><?/.,][}{" is not null group by "test1234!@#$%^&*():'><?/.,][}{" having "test1234!@#$%^&*():'><?/.,][}{" is not null order by 1 slimit 20 limit 20;
select tb1.binary_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.binary_16_col is not null group by tb1.binary_16_col having tb1.binary_16_col is not null order by 1 slimit 20 limit 20;
select tb1.binary_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.binary_16_col is not null group by tb1.binary_16_col having tb1.binary_16_col is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select tb1.nchar_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.nchar_16_col is not null group by tb1.nchar_16_col having tb1.nchar_16_col is not null order by 1 slimit 20 limit 20;
select tb1.nchar_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.nchar_16_col is not null group by tb1.nchar_16_col having tb1.nchar_16_col is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select round( tb1.int_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.int_col ) is not null group by round( tb1.int_col ) having round( tb1.int_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.int_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.int_col ) is not null group by round( tb1.int_col ) having round( tb1.int_col ) is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.int_col is not null group by tb1.int_col + tb1.int_col having tb1.int_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.int_col is not null group by tb1.int_col + tb1.int_col having tb1.int_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.bigint_col is not null group by tb1.int_col + tb1.bigint_col having tb1.int_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.bigint_col is not null group by tb1.int_col + tb1.bigint_col having tb1.int_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.smallint_col is not null group by tb1.int_col + tb1.smallint_col having tb1.int_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.smallint_col is not null group by tb1.int_col + tb1.smallint_col having tb1.int_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.tinyint_col is not null group by tb1.int_col + tb1.tinyint_col having tb1.int_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.tinyint_col is not null group by tb1.int_col + tb1.tinyint_col having tb1.int_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.float_col is not null group by tb1.int_col + tb1.float_col having tb1.int_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.float_col is not null group by tb1.int_col + tb1.float_col having tb1.int_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.double_col is not null group by tb1.int_col + tb1.double_col having tb1.int_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.double_col is not null group by tb1.int_col + tb1.double_col having tb1.int_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.bigint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.bigint_col ) is not null group by round( tb1.bigint_col ) having round( tb1.bigint_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.bigint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.bigint_col ) is not null group by round( tb1.bigint_col ) having round( tb1.bigint_col ) is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.int_col is not null group by tb1.bigint_col + tb1.int_col having tb1.bigint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.int_col is not null group by tb1.bigint_col + tb1.int_col having tb1.bigint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.bigint_col is not null group by tb1.bigint_col + tb1.bigint_col having tb1.bigint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.bigint_col is not null group by tb1.bigint_col + tb1.bigint_col having tb1.bigint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.smallint_col is not null group by tb1.bigint_col + tb1.smallint_col having tb1.bigint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.smallint_col is not null group by tb1.bigint_col + tb1.smallint_col having tb1.bigint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.tinyint_col is not null group by tb1.bigint_col + tb1.tinyint_col having tb1.bigint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.tinyint_col is not null group by tb1.bigint_col + tb1.tinyint_col having tb1.bigint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.float_col is not null group by tb1.bigint_col + tb1.float_col having tb1.bigint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.float_col is not null group by tb1.bigint_col + tb1.float_col having tb1.bigint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.double_col is not null group by tb1.bigint_col + tb1.double_col having tb1.bigint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.double_col is not null group by tb1.bigint_col + tb1.double_col having tb1.bigint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.smallint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.smallint_col ) is not null group by round( tb1.smallint_col ) having round( tb1.smallint_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.smallint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.smallint_col ) is not null group by round( tb1.smallint_col ) having round( tb1.smallint_col ) is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.int_col is not null group by tb1.smallint_col + tb1.int_col having tb1.smallint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.int_col is not null group by tb1.smallint_col + tb1.int_col having tb1.smallint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.bigint_col is not null group by tb1.smallint_col + tb1.bigint_col having tb1.smallint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.bigint_col is not null group by tb1.smallint_col + tb1.bigint_col having tb1.smallint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.smallint_col is not null group by tb1.smallint_col + tb1.smallint_col having tb1.smallint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.smallint_col is not null group by tb1.smallint_col + tb1.smallint_col having tb1.smallint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.tinyint_col is not null group by tb1.smallint_col + tb1.tinyint_col having tb1.smallint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.tinyint_col is not null group by tb1.smallint_col + tb1.tinyint_col having tb1.smallint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.float_col is not null group by tb1.smallint_col + tb1.float_col having tb1.smallint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.float_col is not null group by tb1.smallint_col + tb1.float_col having tb1.smallint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.double_col is not null group by tb1.smallint_col + tb1.double_col having tb1.smallint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.double_col is not null group by tb1.smallint_col + tb1.double_col having tb1.smallint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.tinyint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.tinyint_col ) is not null group by round( tb1.tinyint_col ) having round( tb1.tinyint_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.tinyint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.tinyint_col ) is not null group by round( tb1.tinyint_col ) having round( tb1.tinyint_col ) is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.int_col is not null group by tb1.tinyint_col + tb1.int_col having tb1.tinyint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.int_col is not null group by tb1.tinyint_col + tb1.int_col having tb1.tinyint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.bigint_col is not null group by tb1.tinyint_col + tb1.bigint_col having tb1.tinyint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.bigint_col is not null group by tb1.tinyint_col + tb1.bigint_col having tb1.tinyint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.smallint_col is not null group by tb1.tinyint_col + tb1.smallint_col having tb1.tinyint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.smallint_col is not null group by tb1.tinyint_col + tb1.smallint_col having tb1.tinyint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.tinyint_col is not null group by tb1.tinyint_col + tb1.tinyint_col having tb1.tinyint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.tinyint_col is not null group by tb1.tinyint_col + tb1.tinyint_col having tb1.tinyint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.float_col is not null group by tb1.tinyint_col + tb1.float_col having tb1.tinyint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.float_col is not null group by tb1.tinyint_col + tb1.float_col having tb1.tinyint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.double_col is not null group by tb1.tinyint_col + tb1.double_col having tb1.tinyint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.double_col is not null group by tb1.tinyint_col + tb1.double_col having tb1.tinyint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.float_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.float_col ) is not null group by round( tb1.float_col ) having round( tb1.float_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.float_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.float_col ) is not null group by round( tb1.float_col ) having round( tb1.float_col ) is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.int_col is not null group by tb1.float_col + tb1.int_col having tb1.float_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.int_col is not null group by tb1.float_col + tb1.int_col having tb1.float_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.bigint_col is not null group by tb1.float_col + tb1.bigint_col having tb1.float_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.bigint_col is not null group by tb1.float_col + tb1.bigint_col having tb1.float_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.smallint_col is not null group by tb1.float_col + tb1.smallint_col having tb1.float_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.smallint_col is not null group by tb1.float_col + tb1.smallint_col having tb1.float_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.tinyint_col is not null group by tb1.float_col + tb1.tinyint_col having tb1.float_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.tinyint_col is not null group by tb1.float_col + tb1.tinyint_col having tb1.float_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.float_col is not null group by tb1.float_col + tb1.float_col having tb1.float_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.float_col is not null group by tb1.float_col + tb1.float_col having tb1.float_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.double_col is not null group by tb1.float_col + tb1.double_col having tb1.float_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.double_col is not null group by tb1.float_col + tb1.double_col having tb1.float_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.double_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.double_col ) is not null group by round( tb1.double_col ) having round( tb1.double_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.double_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.double_col ) is not null group by round( tb1.double_col ) having round( tb1.double_col ) is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.int_col is not null group by tb1.double_col + tb1.int_col having tb1.double_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.int_col is not null group by tb1.double_col + tb1.int_col having tb1.double_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.bigint_col is not null group by tb1.double_col + tb1.bigint_col having tb1.double_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.bigint_col is not null group by tb1.double_col + tb1.bigint_col having tb1.double_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.smallint_col is not null group by tb1.double_col + tb1.smallint_col having tb1.double_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.smallint_col is not null group by tb1.double_col + tb1.smallint_col having tb1.double_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.tinyint_col is not null group by tb1.double_col + tb1.tinyint_col having tb1.double_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.tinyint_col is not null group by tb1.double_col + tb1.tinyint_col having tb1.double_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.float_col is not null group by tb1.double_col + tb1.float_col having tb1.double_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.float_col is not null group by tb1.double_col + tb1.float_col having tb1.double_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.double_col is not null group by tb1.double_col + tb1.double_col having tb1.double_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.double_col is not null group by tb1.double_col + tb1.double_col having tb1.double_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select "test1234!@#$%^&*():'><?/.,][}{" from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where "test1234!@#$%^&*():'><?/.,][}{" is not null group by "test1234!@#$%^&*():'><?/.,][}{" having "test1234!@#$%^&*():'><?/.,][}{" is not null order by 1 slimit 20 limit 20;
select "test1234!@#$%^&*():'><?/.,][}{" from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where "test1234!@#$%^&*():'><?/.,][}{" is not null group by "test1234!@#$%^&*():'><?/.,][}{" having "test1234!@#$%^&*():'><?/.,][}{" is not null order by 1 slimit 20 limit 20;
select tb1.binary_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.binary_16_col is not null group by tb1.binary_16_col having tb1.binary_16_col is not null order by 1 slimit 20 limit 20;
select tb1.binary_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.binary_16_col is not null group by tb1.binary_16_col having tb1.binary_16_col is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select tb1.nchar_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.nchar_16_col is not null group by tb1.nchar_16_col having tb1.nchar_16_col is not null order by 1 slimit 20 limit 20;
select tb1.nchar_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.nchar_16_col is not null group by tb1.nchar_16_col having tb1.nchar_16_col is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select round( tb1.int_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.int_col ) is not null group by round( tb1.int_col ) having round( tb1.int_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.int_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.int_col ) is not null group by round( tb1.int_col ) having round( tb1.int_col ) is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.int_col is not null group by tb1.int_col + tb1.int_col having tb1.int_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.int_col is not null group by tb1.int_col + tb1.int_col having tb1.int_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.bigint_col is not null group by tb1.int_col + tb1.bigint_col having tb1.int_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.bigint_col is not null group by tb1.int_col + tb1.bigint_col having tb1.int_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.smallint_col is not null group by tb1.int_col + tb1.smallint_col having tb1.int_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.smallint_col is not null group by tb1.int_col + tb1.smallint_col having tb1.int_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.tinyint_col is not null group by tb1.int_col + tb1.tinyint_col having tb1.int_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.tinyint_col is not null group by tb1.int_col + tb1.tinyint_col having tb1.int_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.float_col is not null group by tb1.int_col + tb1.float_col having tb1.int_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.float_col is not null group by tb1.int_col + tb1.float_col having tb1.int_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.double_col is not null group by tb1.int_col + tb1.double_col having tb1.int_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.double_col is not null group by tb1.int_col + tb1.double_col having tb1.int_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.bigint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.bigint_col ) is not null group by round( tb1.bigint_col ) having round( tb1.bigint_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.bigint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.bigint_col ) is not null group by round( tb1.bigint_col ) having round( tb1.bigint_col ) is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.int_col is not null group by tb1.bigint_col + tb1.int_col having tb1.bigint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.int_col is not null group by tb1.bigint_col + tb1.int_col having tb1.bigint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.bigint_col is not null group by tb1.bigint_col + tb1.bigint_col having tb1.bigint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.bigint_col is not null group by tb1.bigint_col + tb1.bigint_col having tb1.bigint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.smallint_col is not null group by tb1.bigint_col + tb1.smallint_col having tb1.bigint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.smallint_col is not null group by tb1.bigint_col + tb1.smallint_col having tb1.bigint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.tinyint_col is not null group by tb1.bigint_col + tb1.tinyint_col having tb1.bigint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.tinyint_col is not null group by tb1.bigint_col + tb1.tinyint_col having tb1.bigint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.float_col is not null group by tb1.bigint_col + tb1.float_col having tb1.bigint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.float_col is not null group by tb1.bigint_col + tb1.float_col having tb1.bigint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.double_col is not null group by tb1.bigint_col + tb1.double_col having tb1.bigint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.double_col is not null group by tb1.bigint_col + tb1.double_col having tb1.bigint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.smallint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.smallint_col ) is not null group by round( tb1.smallint_col ) having round( tb1.smallint_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.smallint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.smallint_col ) is not null group by round( tb1.smallint_col ) having round( tb1.smallint_col ) is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.int_col is not null group by tb1.smallint_col + tb1.int_col having tb1.smallint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.int_col is not null group by tb1.smallint_col + tb1.int_col having tb1.smallint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.bigint_col is not null group by tb1.smallint_col + tb1.bigint_col having tb1.smallint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.bigint_col is not null group by tb1.smallint_col + tb1.bigint_col having tb1.smallint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.smallint_col is not null group by tb1.smallint_col + tb1.smallint_col having tb1.smallint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.smallint_col is not null group by tb1.smallint_col + tb1.smallint_col having tb1.smallint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.tinyint_col is not null group by tb1.smallint_col + tb1.tinyint_col having tb1.smallint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.tinyint_col is not null group by tb1.smallint_col + tb1.tinyint_col having tb1.smallint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.float_col is not null group by tb1.smallint_col + tb1.float_col having tb1.smallint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.float_col is not null group by tb1.smallint_col + tb1.float_col having tb1.smallint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.double_col is not null group by tb1.smallint_col + tb1.double_col having tb1.smallint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.double_col is not null group by tb1.smallint_col + tb1.double_col having tb1.smallint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.tinyint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.tinyint_col ) is not null group by round( tb1.tinyint_col ) having round( tb1.tinyint_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.tinyint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.tinyint_col ) is not null group by round( tb1.tinyint_col ) having round( tb1.tinyint_col ) is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.int_col is not null group by tb1.tinyint_col + tb1.int_col having tb1.tinyint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.int_col is not null group by tb1.tinyint_col + tb1.int_col having tb1.tinyint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.bigint_col is not null group by tb1.tinyint_col + tb1.bigint_col having tb1.tinyint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.bigint_col is not null group by tb1.tinyint_col + tb1.bigint_col having tb1.tinyint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.smallint_col is not null group by tb1.tinyint_col + tb1.smallint_col having tb1.tinyint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.smallint_col is not null group by tb1.tinyint_col + tb1.smallint_col having tb1.tinyint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.tinyint_col is not null group by tb1.tinyint_col + tb1.tinyint_col having tb1.tinyint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.tinyint_col is not null group by tb1.tinyint_col + tb1.tinyint_col having tb1.tinyint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.float_col is not null group by tb1.tinyint_col + tb1.float_col having tb1.tinyint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.float_col is not null group by tb1.tinyint_col + tb1.float_col having tb1.tinyint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.double_col is not null group by tb1.tinyint_col + tb1.double_col having tb1.tinyint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.double_col is not null group by tb1.tinyint_col + tb1.double_col having tb1.tinyint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.float_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.float_col ) is not null group by round( tb1.float_col ) having round( tb1.float_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.float_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.float_col ) is not null group by round( tb1.float_col ) having round( tb1.float_col ) is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.int_col is not null group by tb1.float_col + tb1.int_col having tb1.float_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.int_col is not null group by tb1.float_col + tb1.int_col having tb1.float_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.bigint_col is not null group by tb1.float_col + tb1.bigint_col having tb1.float_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.bigint_col is not null group by tb1.float_col + tb1.bigint_col having tb1.float_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.smallint_col is not null group by tb1.float_col + tb1.smallint_col having tb1.float_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.smallint_col is not null group by tb1.float_col + tb1.smallint_col having tb1.float_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.tinyint_col is not null group by tb1.float_col + tb1.tinyint_col having tb1.float_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.tinyint_col is not null group by tb1.float_col + tb1.tinyint_col having tb1.float_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.float_col is not null group by tb1.float_col + tb1.float_col having tb1.float_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.float_col is not null group by tb1.float_col + tb1.float_col having tb1.float_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.double_col is not null group by tb1.float_col + tb1.double_col having tb1.float_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.double_col is not null group by tb1.float_col + tb1.double_col having tb1.float_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.double_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.double_col ) is not null group by round( tb1.double_col ) having round( tb1.double_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.double_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.double_col ) is not null group by round( tb1.double_col ) having round( tb1.double_col ) is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.int_col is not null group by tb1.double_col + tb1.int_col having tb1.double_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.int_col is not null group by tb1.double_col + tb1.int_col having tb1.double_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.bigint_col is not null group by tb1.double_col + tb1.bigint_col having tb1.double_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.bigint_col is not null group by tb1.double_col + tb1.bigint_col having tb1.double_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.smallint_col is not null group by tb1.double_col + tb1.smallint_col having tb1.double_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.smallint_col is not null group by tb1.double_col + tb1.smallint_col having tb1.double_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.tinyint_col is not null group by tb1.double_col + tb1.tinyint_col having tb1.double_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.tinyint_col is not null group by tb1.double_col + tb1.tinyint_col having tb1.double_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.float_col is not null group by tb1.double_col + tb1.float_col having tb1.double_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.float_col is not null group by tb1.double_col + tb1.float_col having tb1.double_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.double_col is not null group by tb1.double_col + tb1.double_col having tb1.double_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.double_col is not null group by tb1.double_col + tb1.double_col having tb1.double_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select "test1234!@#$%^&*():'><?/.,][}{" from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where "test1234!@#$%^&*():'><?/.,][}{" is not null group by "test1234!@#$%^&*():'><?/.,][}{" having "test1234!@#$%^&*():'><?/.,][}{" is not null order by 1 slimit 20 limit 20;
select "test1234!@#$%^&*():'><?/.,][}{" from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where "test1234!@#$%^&*():'><?/.,][}{" is not null group by "test1234!@#$%^&*():'><?/.,][}{" having "test1234!@#$%^&*():'><?/.,][}{" is not null order by 1 slimit 20 limit 20;
select tb1.binary_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.binary_16_col is not null group by tb1.binary_16_col having tb1.binary_16_col is not null order by 1 slimit 20 limit 20;
select tb1.binary_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.binary_16_col is not null group by tb1.binary_16_col having tb1.binary_16_col is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select tb1.nchar_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.nchar_16_col is not null group by tb1.nchar_16_col having tb1.nchar_16_col is not null order by 1 slimit 20 limit 20;
select tb1.nchar_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.nchar_16_col is not null group by tb1.nchar_16_col having tb1.nchar_16_col is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select round( tb1.int_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.int_col ) is not null group by round( tb1.int_col ) having round( tb1.int_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.int_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.int_col ) is not null group by round( tb1.int_col ) having round( tb1.int_col ) is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.int_col is not null group by tb1.int_col + tb1.int_col having tb1.int_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.int_col is not null group by tb1.int_col + tb1.int_col having tb1.int_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.bigint_col is not null group by tb1.int_col + tb1.bigint_col having tb1.int_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.bigint_col is not null group by tb1.int_col + tb1.bigint_col having tb1.int_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.smallint_col is not null group by tb1.int_col + tb1.smallint_col having tb1.int_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.smallint_col is not null group by tb1.int_col + tb1.smallint_col having tb1.int_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.tinyint_col is not null group by tb1.int_col + tb1.tinyint_col having tb1.int_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.tinyint_col is not null group by tb1.int_col + tb1.tinyint_col having tb1.int_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.float_col is not null group by tb1.int_col + tb1.float_col having tb1.int_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.float_col is not null group by tb1.int_col + tb1.float_col having tb1.int_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.double_col is not null group by tb1.int_col + tb1.double_col having tb1.int_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.double_col is not null group by tb1.int_col + tb1.double_col having tb1.int_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.bigint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.bigint_col ) is not null group by round( tb1.bigint_col ) having round( tb1.bigint_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.bigint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.bigint_col ) is not null group by round( tb1.bigint_col ) having round( tb1.bigint_col ) is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.int_col is not null group by tb1.bigint_col + tb1.int_col having tb1.bigint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.int_col is not null group by tb1.bigint_col + tb1.int_col having tb1.bigint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.bigint_col is not null group by tb1.bigint_col + tb1.bigint_col having tb1.bigint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.bigint_col is not null group by tb1.bigint_col + tb1.bigint_col having tb1.bigint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.smallint_col is not null group by tb1.bigint_col + tb1.smallint_col having tb1.bigint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.smallint_col is not null group by tb1.bigint_col + tb1.smallint_col having tb1.bigint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.tinyint_col is not null group by tb1.bigint_col + tb1.tinyint_col having tb1.bigint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.tinyint_col is not null group by tb1.bigint_col + tb1.tinyint_col having tb1.bigint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.float_col is not null group by tb1.bigint_col + tb1.float_col having tb1.bigint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.float_col is not null group by tb1.bigint_col + tb1.float_col having tb1.bigint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.double_col is not null group by tb1.bigint_col + tb1.double_col having tb1.bigint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.double_col is not null group by tb1.bigint_col + tb1.double_col having tb1.bigint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.smallint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.smallint_col ) is not null group by round( tb1.smallint_col ) having round( tb1.smallint_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.smallint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.smallint_col ) is not null group by round( tb1.smallint_col ) having round( tb1.smallint_col ) is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.int_col is not null group by tb1.smallint_col + tb1.int_col having tb1.smallint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.int_col is not null group by tb1.smallint_col + tb1.int_col having tb1.smallint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.bigint_col is not null group by tb1.smallint_col + tb1.bigint_col having tb1.smallint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.bigint_col is not null group by tb1.smallint_col + tb1.bigint_col having tb1.smallint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.smallint_col is not null group by tb1.smallint_col + tb1.smallint_col having tb1.smallint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.smallint_col is not null group by tb1.smallint_col + tb1.smallint_col having tb1.smallint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.tinyint_col is not null group by tb1.smallint_col + tb1.tinyint_col having tb1.smallint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.tinyint_col is not null group by tb1.smallint_col + tb1.tinyint_col having tb1.smallint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.float_col is not null group by tb1.smallint_col + tb1.float_col having tb1.smallint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.float_col is not null group by tb1.smallint_col + tb1.float_col having tb1.smallint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.double_col is not null group by tb1.smallint_col + tb1.double_col having tb1.smallint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.double_col is not null group by tb1.smallint_col + tb1.double_col having tb1.smallint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.tinyint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.tinyint_col ) is not null group by round( tb1.tinyint_col ) having round( tb1.tinyint_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.tinyint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.tinyint_col ) is not null group by round( tb1.tinyint_col ) having round( tb1.tinyint_col ) is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.int_col is not null group by tb1.tinyint_col + tb1.int_col having tb1.tinyint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.int_col is not null group by tb1.tinyint_col + tb1.int_col having tb1.tinyint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.bigint_col is not null group by tb1.tinyint_col + tb1.bigint_col having tb1.tinyint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.bigint_col is not null group by tb1.tinyint_col + tb1.bigint_col having tb1.tinyint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.smallint_col is not null group by tb1.tinyint_col + tb1.smallint_col having tb1.tinyint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.smallint_col is not null group by tb1.tinyint_col + tb1.smallint_col having tb1.tinyint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.tinyint_col is not null group by tb1.tinyint_col + tb1.tinyint_col having tb1.tinyint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.tinyint_col is not null group by tb1.tinyint_col + tb1.tinyint_col having tb1.tinyint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.float_col is not null group by tb1.tinyint_col + tb1.float_col having tb1.tinyint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.float_col is not null group by tb1.tinyint_col + tb1.float_col having tb1.tinyint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.double_col is not null group by tb1.tinyint_col + tb1.double_col having tb1.tinyint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.double_col is not null group by tb1.tinyint_col + tb1.double_col having tb1.tinyint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.float_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.float_col ) is not null group by round( tb1.float_col ) having round( tb1.float_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.float_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.float_col ) is not null group by round( tb1.float_col ) having round( tb1.float_col ) is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.int_col is not null group by tb1.float_col + tb1.int_col having tb1.float_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.int_col is not null group by tb1.float_col + tb1.int_col having tb1.float_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.bigint_col is not null group by tb1.float_col + tb1.bigint_col having tb1.float_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.bigint_col is not null group by tb1.float_col + tb1.bigint_col having tb1.float_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.smallint_col is not null group by tb1.float_col + tb1.smallint_col having tb1.float_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.smallint_col is not null group by tb1.float_col + tb1.smallint_col having tb1.float_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.tinyint_col is not null group by tb1.float_col + tb1.tinyint_col having tb1.float_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.tinyint_col is not null group by tb1.float_col + tb1.tinyint_col having tb1.float_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.float_col is not null group by tb1.float_col + tb1.float_col having tb1.float_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.float_col is not null group by tb1.float_col + tb1.float_col having tb1.float_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.double_col is not null group by tb1.float_col + tb1.double_col having tb1.float_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.double_col is not null group by tb1.float_col + tb1.double_col having tb1.float_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.double_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.double_col ) is not null group by round( tb1.double_col ) having round( tb1.double_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.double_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where round( tb1.double_col ) is not null group by round( tb1.double_col ) having round( tb1.double_col ) is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.int_col is not null group by tb1.double_col + tb1.int_col having tb1.double_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.int_col is not null group by tb1.double_col + tb1.int_col having tb1.double_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.bigint_col is not null group by tb1.double_col + tb1.bigint_col having tb1.double_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.bigint_col is not null group by tb1.double_col + tb1.bigint_col having tb1.double_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.smallint_col is not null group by tb1.double_col + tb1.smallint_col having tb1.double_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.smallint_col is not null group by tb1.double_col + tb1.smallint_col having tb1.double_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.tinyint_col is not null group by tb1.double_col + tb1.tinyint_col having tb1.double_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.tinyint_col is not null group by tb1.double_col + tb1.tinyint_col having tb1.double_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.float_col is not null group by tb1.double_col + tb1.float_col having tb1.double_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.float_col is not null group by tb1.double_col + tb1.float_col having tb1.double_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.double_col is not null group by tb1.double_col + tb1.double_col having tb1.double_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.double_col is not null group by tb1.double_col + tb1.double_col having tb1.double_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select "test1234!@#$%^&*():'><?/.,][}{" from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where "test1234!@#$%^&*():'><?/.,][}{" is not null group by "test1234!@#$%^&*():'><?/.,][}{" having "test1234!@#$%^&*():'><?/.,][}{" is not null order by 1 slimit 20 limit 20;
select "test1234!@#$%^&*():'><?/.,][}{" from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ctb_2 as tb2 on tb1.ts=tb2.ts where "test1234!@#$%^&*():'><?/.,][}{" is not null group by "test1234!@#$%^&*():'><?/.,][}{" having "test1234!@#$%^&*():'><?/.,][}{" is not null order by 1 slimit 20 limit 20;
select tb1.binary_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.binary_16_col is not null group by tb1.binary_16_col having tb1.binary_16_col is not null order by 1 slimit 20 limit 20;
select tb1.binary_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.binary_16_col is not null group by tb1.binary_16_col having tb1.binary_16_col is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select tb1.nchar_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.nchar_16_col is not null group by tb1.nchar_16_col having tb1.nchar_16_col is not null order by 1 slimit 20 limit 20;
select tb1.nchar_16_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.nchar_16_col is not null group by tb1.nchar_16_col having tb1.nchar_16_col is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.int_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.int_col as binary(16) ) is not null group by cast( tb1.int_col as binary(16) ) having cast( tb1.int_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.bigint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.bigint_col as binary(16) ) is not null group by cast( tb1.bigint_col as binary(16) ) having cast( tb1.bigint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.smallint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.smallint_col as binary(16) ) is not null group by cast( tb1.smallint_col as binary(16) ) having cast( tb1.smallint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.tinyint_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.tinyint_col as binary(16) ) is not null group by cast( tb1.tinyint_col as binary(16) ) having cast( tb1.tinyint_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.float_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.float_col as binary(16) ) is not null group by cast( tb1.float_col as binary(16) ) having cast( tb1.float_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select cast( tb1.double_col as binary(16) ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where cast( tb1.double_col as binary(16) ) is not null group by cast( tb1.double_col as binary(16) ) having cast( tb1.double_col as binary(16) ) is not null order by 1 slimit 20 limit 20;
select round( tb1.int_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.int_col ) is not null group by round( tb1.int_col ) having round( tb1.int_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.int_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.int_col ) is not null group by round( tb1.int_col ) having round( tb1.int_col ) is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.int_col is not null group by tb1.int_col + tb1.int_col having tb1.int_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.int_col is not null group by tb1.int_col + tb1.int_col having tb1.int_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.bigint_col is not null group by tb1.int_col + tb1.bigint_col having tb1.int_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.bigint_col is not null group by tb1.int_col + tb1.bigint_col having tb1.int_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.smallint_col is not null group by tb1.int_col + tb1.smallint_col having tb1.int_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.smallint_col is not null group by tb1.int_col + tb1.smallint_col having tb1.int_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.tinyint_col is not null group by tb1.int_col + tb1.tinyint_col having tb1.int_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.tinyint_col is not null group by tb1.int_col + tb1.tinyint_col having tb1.int_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.float_col is not null group by tb1.int_col + tb1.float_col having tb1.int_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.float_col is not null group by tb1.int_col + tb1.float_col having tb1.int_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.double_col is not null group by tb1.int_col + tb1.double_col having tb1.int_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.int_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.int_col + tb1.double_col is not null group by tb1.int_col + tb1.double_col having tb1.int_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.bigint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.bigint_col ) is not null group by round( tb1.bigint_col ) having round( tb1.bigint_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.bigint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.bigint_col ) is not null group by round( tb1.bigint_col ) having round( tb1.bigint_col ) is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.int_col is not null group by tb1.bigint_col + tb1.int_col having tb1.bigint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.int_col is not null group by tb1.bigint_col + tb1.int_col having tb1.bigint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.bigint_col is not null group by tb1.bigint_col + tb1.bigint_col having tb1.bigint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.bigint_col is not null group by tb1.bigint_col + tb1.bigint_col having tb1.bigint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.smallint_col is not null group by tb1.bigint_col + tb1.smallint_col having tb1.bigint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.smallint_col is not null group by tb1.bigint_col + tb1.smallint_col having tb1.bigint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.tinyint_col is not null group by tb1.bigint_col + tb1.tinyint_col having tb1.bigint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.tinyint_col is not null group by tb1.bigint_col + tb1.tinyint_col having tb1.bigint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.float_col is not null group by tb1.bigint_col + tb1.float_col having tb1.bigint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.float_col is not null group by tb1.bigint_col + tb1.float_col having tb1.bigint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.double_col is not null group by tb1.bigint_col + tb1.double_col having tb1.bigint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.bigint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.bigint_col + tb1.double_col is not null group by tb1.bigint_col + tb1.double_col having tb1.bigint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.smallint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.smallint_col ) is not null group by round( tb1.smallint_col ) having round( tb1.smallint_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.smallint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.smallint_col ) is not null group by round( tb1.smallint_col ) having round( tb1.smallint_col ) is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.int_col is not null group by tb1.smallint_col + tb1.int_col having tb1.smallint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.int_col is not null group by tb1.smallint_col + tb1.int_col having tb1.smallint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.bigint_col is not null group by tb1.smallint_col + tb1.bigint_col having tb1.smallint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.bigint_col is not null group by tb1.smallint_col + tb1.bigint_col having tb1.smallint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.smallint_col is not null group by tb1.smallint_col + tb1.smallint_col having tb1.smallint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.smallint_col is not null group by tb1.smallint_col + tb1.smallint_col having tb1.smallint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.tinyint_col is not null group by tb1.smallint_col + tb1.tinyint_col having tb1.smallint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.tinyint_col is not null group by tb1.smallint_col + tb1.tinyint_col having tb1.smallint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.float_col is not null group by tb1.smallint_col + tb1.float_col having tb1.smallint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.float_col is not null group by tb1.smallint_col + tb1.float_col having tb1.smallint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.double_col is not null group by tb1.smallint_col + tb1.double_col having tb1.smallint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.smallint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.smallint_col + tb1.double_col is not null group by tb1.smallint_col + tb1.double_col having tb1.smallint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.tinyint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.tinyint_col ) is not null group by round( tb1.tinyint_col ) having round( tb1.tinyint_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.tinyint_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.tinyint_col ) is not null group by round( tb1.tinyint_col ) having round( tb1.tinyint_col ) is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.int_col is not null group by tb1.tinyint_col + tb1.int_col having tb1.tinyint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.int_col is not null group by tb1.tinyint_col + tb1.int_col having tb1.tinyint_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.bigint_col is not null group by tb1.tinyint_col + tb1.bigint_col having tb1.tinyint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.bigint_col is not null group by tb1.tinyint_col + tb1.bigint_col having tb1.tinyint_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.smallint_col is not null group by tb1.tinyint_col + tb1.smallint_col having tb1.tinyint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.smallint_col is not null group by tb1.tinyint_col + tb1.smallint_col having tb1.tinyint_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.tinyint_col is not null group by tb1.tinyint_col + tb1.tinyint_col having tb1.tinyint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.tinyint_col is not null group by tb1.tinyint_col + tb1.tinyint_col having tb1.tinyint_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.float_col is not null group by tb1.tinyint_col + tb1.float_col having tb1.tinyint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.float_col is not null group by tb1.tinyint_col + tb1.float_col having tb1.tinyint_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.double_col is not null group by tb1.tinyint_col + tb1.double_col having tb1.tinyint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.tinyint_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.tinyint_col + tb1.double_col is not null group by tb1.tinyint_col + tb1.double_col having tb1.tinyint_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.float_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.float_col ) is not null group by round( tb1.float_col ) having round( tb1.float_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.float_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.float_col ) is not null group by round( tb1.float_col ) having round( tb1.float_col ) is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.int_col is not null group by tb1.float_col + tb1.int_col having tb1.float_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.int_col is not null group by tb1.float_col + tb1.int_col having tb1.float_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.bigint_col is not null group by tb1.float_col + tb1.bigint_col having tb1.float_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.bigint_col is not null group by tb1.float_col + tb1.bigint_col having tb1.float_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.smallint_col is not null group by tb1.float_col + tb1.smallint_col having tb1.float_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.smallint_col is not null group by tb1.float_col + tb1.smallint_col having tb1.float_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.tinyint_col is not null group by tb1.float_col + tb1.tinyint_col having tb1.float_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.tinyint_col is not null group by tb1.float_col + tb1.tinyint_col having tb1.float_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.float_col is not null group by tb1.float_col + tb1.float_col having tb1.float_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.float_col is not null group by tb1.float_col + tb1.float_col having tb1.float_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.double_col is not null group by tb1.float_col + tb1.double_col having tb1.float_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.float_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.float_col + tb1.double_col is not null group by tb1.float_col + tb1.double_col having tb1.float_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select round( tb1.double_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.double_col ) is not null group by round( tb1.double_col ) having round( tb1.double_col ) is not null order by 1 slimit 20 limit 20;
select round( tb1.double_col ) from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where round( tb1.double_col ) is not null group by round( tb1.double_col ) having round( tb1.double_col ) is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.int_col is not null group by tb1.double_col + tb1.int_col having tb1.double_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.int_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.int_col is not null group by tb1.double_col + tb1.int_col having tb1.double_col + tb1.int_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.bigint_col is not null group by tb1.double_col + tb1.bigint_col having tb1.double_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.bigint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.bigint_col is not null group by tb1.double_col + tb1.bigint_col having tb1.double_col + tb1.bigint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.smallint_col is not null group by tb1.double_col + tb1.smallint_col having tb1.double_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.smallint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.smallint_col is not null group by tb1.double_col + tb1.smallint_col having tb1.double_col + tb1.smallint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.tinyint_col is not null group by tb1.double_col + tb1.tinyint_col having tb1.double_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.tinyint_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.tinyint_col is not null group by tb1.double_col + tb1.tinyint_col having tb1.double_col + tb1.tinyint_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.float_col is not null group by tb1.double_col + tb1.float_col having tb1.double_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.float_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.float_col is not null group by tb1.double_col + tb1.float_col having tb1.double_col + tb1.float_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.double_col is not null group by tb1.double_col + tb1.double_col having tb1.double_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select tb1.double_col + tb1.double_col from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where tb1.double_col + tb1.double_col is not null group by tb1.double_col + tb1.double_col having tb1.double_col + tb1.double_col is not null order by 1 slimit 20 limit 20;
select "test1234!@#$%^&*():'><?/.,][}{" from test_vtable_join.vtb_virtual_ctb_1 as tb1 join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where "test1234!@#$%^&*():'><?/.,][}{" is not null group by "test1234!@#$%^&*():'><?/.,][}{" having "test1234!@#$%^&*():'><?/.,][}{" is not null order by 1 slimit 20 limit 20;
select "test1234!@#$%^&*():'><?/.,][}{" from test_vtable_join.vtb_virtual_ctb_1 as tb1 inner join test_vtable_join.vtb_virtual_ntb_1 as tb2 on tb1.ts=tb2.ts where "test1234!@#$%^&*():'><?/.,][}{" is not null group by "test1234!@#$%^&*():'><?/.,][}{" having "test1234!@#$%^&*():'><?/.,][}{" is not null order by 1 slimit 20 limit 20;