labeling queries with "union"

Hi,

We are using query labels to monitor our queries permanence.
(https://my.vertica.com/docs/6.1.x/HTML/index.htm#18282.htm)

For some reason, we can't see the queries which have "union" on the query_profiles table.

to test this -


1) execute this query
select /*+label(test34)*/ 1


2) execute
select * from query_profiles where identifier='test34'

-->
I get a result


3) execute
select /*+label(test56)*/ 1
union
select 2

4) execute
select * from query_profiles where identifier='test56'
-->
no results

Do you know why this happens and how can we fix it?

Thanks,
Dafna.


Comments


  • Looks like a bug to me.  One quick workaround is to do the following:

    select /*+label(test56)*/ *
    From ( select 1
    union
    select 2 ) A
    ;

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file