Parsed Logical Plan report UnresolvedHint RANGE_JOIN

hukel
Contributor

I'm new to RANGE_JOIN so this may be completely normal, but I'd like confirmation.

Whenever I put a RANGE_JOIN hint in my query

 

SELECT    /*+ RANGE_JOIN(pr2, 3600) */  
     event.FirstIP4Record    
FROM SCHEMA_NAME_HERE.dnsrequest event
INNER JOIN SCHEMA_NAME_HERE.processrollup2 pr2 ON 
       (pr2.timestamp BETWEEN dateadd(HOUR, -2 , event.timestamp) AND event.timestamp)
   AND event.aid=pr2.aid
   AND event.ContextProcessId=pr2.TargetProcessId

 

I get this message in the Parsed Logical plan, even though I see a "Generate rangejoinbingenerator" step down in the physical plan.

== Parsed Logical Plan ==
'UnresolvedHint RANGE_JOIN, ['pr2, 3600]
+- 'Project ['event.FirstIP4Record]