SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `table_id`, `table_type` FROM `__all_table` WHERE 1=1 AND tenant_id = 0 ORDER BY `table_id` ASC
SELECT /*+ query_timeout(100000000) */ `tenant_id`, `tablet_id`, `svr_ip`, `svr_port`, `data_size` FROM `__all_tablet_meta_table` WHERE 1=1 AND tenant_id = 1 ORDER BY `tablet_id` ASC, `ls_id` ASC, `svr_ip` ASC, `svr_port` ASC
SELECT row_id, column_name, column_value FROM __all_core_table WHERE table_name = '__all_table' ORDER BY row_id, column_name
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `table_id` FROM `__all_table` WHERE 1=1 AND tenant_id = 0 ORDER BY `table_id` ASC
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `tablet_id`, `ls_id` FROM `__all_tablet_to_ls` WHERE 1=1 ORDER BY `tablet_id` ASC
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `tablegroup_id` FROM `__all_tablegroup` WHERE 1=1 AND tenant_id = 0 ORDER BY `tablegroup_id` ASC
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `database_id` FROM `__all_database` WHERE 1=1 AND tenant_id = 0 ORDER BY `database_id` ASC
SELECT /*+ query_timeout(100000000) */ `tenant_id`, `ls_id`, `svr_ip`, `svr_port` FROM `__all_ls_meta_table` WHERE 1=1 AND tenant_id = 1 ORDER BY `ls_id` ASC, `svr_ip` ASC, `svr_port` ASC
SELECT /*+ query_timeout(100000000) */ `tenant_id`, `ls_id`, `svr_ip`, `svr_port` FROM `__all_ls_meta_table` WHERE 1=1 AND tenant_id = 1001 ORDER BY `ls_id` ASC, `svr_ip` ASC, `svr_port` ASC
SELECT /*+ query_timeout(100000000) */ `tenant_id`, `ls_id`, `svr_ip`, `svr_port` FROM `__all_ls_meta_table` WHERE 1=1 AND tenant_id = 1003 ORDER BY `ls_id` ASC, `svr_ip` ASC, `svr_port` ASC
SELECT row_id, column_name, column_value FROM __all_core_table WHERE table_name = '__all_table' ORDER BY row_id, column_name
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `table_id`, `tablet_id`, `part_level`, `database_id`, `tablegroup_id` FROM `__all_table` WHERE 1=1 AND tenant_id = 0 ORDER BY `table_id` ASC
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `table_id`, `tablet_id` FROM `__all_part` WHERE 1=1 AND tenant_id = 0 ORDER BY `table_id` ASC, `part_id` ASC
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `table_id`, `part_level`, `database_id`, `tablegroup_id` FROM `__all_table` WHERE 1=1 AND tenant_id = 0 ORDER BY `table_id` ASC
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `table_id`, `part_level`, `database_id`, `tablegroup_id` FROM `__all_table` WHERE 1=1 AND tenant_id = 0 ORDER BY `table_id` ASC
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `table_id`, `part_id` FROM `__all_part` WHERE 1=1 AND tenant_id = 0 ORDER BY `table_id` ASC, `part_id` ASC
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `table_id`, `part_id`, `tablet_id` FROM `__all_sub_part` WHERE 1=1 AND tenant_id = 0 ORDER BY `table_id` ASC, `part_id` ASC, `sub_part_id` ASC
SELECT /*+ READ_CONSISTENCY(WEAK) QUERY_TIMEOUT(50000000) */ a.tenant_id,a.svr_ip,a.svr_port,SUM(data_size) AS data_size FROM cdb_ob_table_locations a JOIN (SELECT tenant_id,tablet_id,svr_ip,svr_port,data_size,required_size FROM __all_virtual_tablet_meta_table) b ON a.tenant_id = b.tenant_id AND a.tablet_id = b.tablet_id AND a.svr_ip = b.svr_ip AND a.svr_port = b.svr_port JOIN __all_virtual_table c ON a.tenant_id = c.tenant_id AND c.table_type = 5 AND a.table_id = c.table_id GROUP BY a.tenant_id,a.svr_ip,a.svr_port
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `table_id`, `table_type` FROM `__all_table` WHERE 1=1 AND tenant_id = 0 ORDER BY `table_id` ASC
SELECT row_id, column_name, column_value FROM __all_core_table WHERE table_name = '__all_table' ORDER BY row_id, column_name
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `table_id` FROM `__all_table` WHERE 1=1 AND tenant_id = 0 ORDER BY `table_id` ASC
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `tablet_id`, `ls_id` FROM `__all_tablet_to_ls` WHERE 1=1 ORDER BY `tablet_id` ASC
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `tablegroup_id` FROM `__all_tablegroup` WHERE 1=1 AND tenant_id = 0 ORDER BY `tablegroup_id` ASC
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `database_id` FROM `__all_database` WHERE 1=1 AND tenant_id = 0 ORDER BY `database_id` ASC
SELECT row_id, column_name, column_value FROM __all_core_table WHERE table_name = '__all_table' ORDER BY row_id, column_name
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `table_id`, `tablet_id`, `part_level`, `database_id`, `tablegroup_id` FROM `__all_table` WHERE 1=1 AND tenant_id = 0 ORDER BY `table_id` ASC
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `table_id`, `tablet_id` FROM `__all_part` WHERE 1=1 AND tenant_id = 0 ORDER BY `table_id` ASC, `part_id` ASC
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `table_id`, `part_level`, `database_id`, `tablegroup_id` FROM `__all_table` WHERE 1=1 AND tenant_id = 0 ORDER BY `table_id` ASC
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `table_id`, `part_level`, `database_id`, `tablegroup_id` FROM `__all_table` WHERE 1=1 AND tenant_id = 0 ORDER BY `table_id` ASC
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `table_id`, `part_id`, `tablet_id` FROM `__all_sub_part` WHERE 1=1 AND tenant_id = 0 ORDER BY `table_id` ASC, `part_id` ASC, `sub_part_id` ASC
SELECT /*+ query_timeout(100000000) */ effective_tenant_id(), `table_id`, `part_id` FROM `__all_part` WHERE 1=1 AND tenant_id = 0 ORDER BY `table_id` ASC, `part_id` ASC