app dynamics query language - In AppDynamics ADQL is there a way to select distinct across multiple colums?

Question

In regular SQL, I could write a query like:

SELECT DISTINCT col_1, col_2
FROM transactions
WHERE ...

However in ADQL syntax, the following query will work for a single column, but not for multiple:

SELECT distinct(col_1)
FROM transactions
WHERE ...
--works

SELECT distinct(col_1, col_2)
FROM transactions
WHERE ...
--fails

Is there any options in ADQL (https://docs.appdynamics.com/display/PRO21/ADQL+Reference) to achieve the same end result?

I tried the following "hack" (and with a small set of data it seems to work... but will timeout with a large set of data).

SELECT distinct(concat(col_1, ",", col_2))
FROM transactions
WHERE ...
--works in limited cases... but it also just returns a single merged column
--that I would still later need to parse out (via CSV export)

question from:https://stackoverflow.com/questions/65942338/in-appdynamics-adql-is-there-a-way-to-select-distinct-across-multiple-colums

Answer 1

Waitting for answers