Skip to main content
Panther Knowledge Base

I get the error "SQL compilation error: ambiguous column name 'P_EVENT_TIME'" in my Panther Console when using INNER JOIN in Data Explorer

  1. Last updated
  2. Save as PDF

Issue

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'

Resolution

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.

Cause

By using INNER JOIN the SQL uses 2 tables where both include a column with the same name p_event_time.

As a result, when running the WHERE statement in the query with the p_occurs_since()macro, there is a compilation error, since it's not specified which table is responsible for the macro.