select * from (select 'dw_test_1' as catalog_name, schema_name, table_name, table_type, remarks from v_catalog.all_tables order by table_type, catalog_name, schema_name, table_name) as vmd where TABLE_TYPE in ('TABLE') and TABLE_NAME ilike 'PROBABLYNOT' escape E'\\'
We could not trace the source of this query and it seems that this is something Vertica runs itself. Is there a way to know what invokes this query and why it runs so frequently and slowly?
Thanks,
Rupendra