schema and table_name fields are empty in QUERY_PROFILES table
I’m trying to profile some queries using syntax like
PROFILE SELECT /+label(profile_query)/ COUNT(*) FROM…;
Per Vertica documentation, I can then query the QUERY_PROFILES table (see below) to get statistics like how long the query took. However, the “table_name” in this query is always empty, and I don’t quite understand why. I tried google/SO, to no avail. Just wondering if you may have any insight on this issue.