I am having an issue running an SQL query in Data Explorer, which uses
INNER JOIN for two tables. The problem starts when a
WHERE p_occurs_since('1 DAY') condition is added, which returns an SQL compilation error similar to the following:
SQL compilation error: ambiguous column name 'P_EVENT_TIME'
To resolve this issue you need to also specify the table alias you wish to use within the macro
p_occurs_since(offsetFromPresent [, tableAlias]).
You can find more information about how our Data Explorer macros work on our documentation page as well as some helpful examples including
inner join statements.
INNER JOIN the SQL uses 2 tables where both include a column with the same name
As a result, when running the
WHERE statement in the query with the
since()macro, there is a compilation error, since it's not specified which table is responsible for the macro.