UnresolvedHint Unary Logical Operator -- Attaching Hint to Logical Plan¶

UnresolvedHint is a spark-sql-LogicalPlan.md#UnaryNode[unary logical operator] that represents a hint (by <> and <>) for the <> logical plan.

UnresolvedHint is <> and added to a spark-sql-LogicalPlan.md[logical plan] when:

• spark-sql-dataset-operators.md#hint[Dataset.hint] operator is used

• AstBuilder sql/AstBuilder.md#withHints[converts] /*+ hint */ in SELECT SQL queries

[source, scala]¶

// Dataset API val q = spark.range(1).hint("myHint", 100, true) val plan = q.queryExecution.logical scala> println(plan.numberedTreeString) 00 'UnresolvedHint myHint, [100, true] 01 +- Range (0, 1, step=1, splits=Some(8))

// SQL val q = sql("SELECT /*+ myHint (100, true) */ 1") val plan = q.queryExecution.logical scala> println(plan.numberedTreeString) 00 'UnresolvedHint myHint, [100, true] 01 +- 'Project [unresolvedalias(1, None)] 02 +- OneRowRelation

[[creating-instance]] When created UnresolvedHint takes:

• [[name]] Name of a hint
• [[parameters]] Parameters of a hint
• [[child]] Child spark-sql-LogicalPlan.md[logical plan]

[[resolved]] UnresolvedHint can never be spark-sql-LogicalPlan.md#resolved[resolved] and is supposed to be converted to a ResolvedHint.md[ResolvedHint] unary logical operator during query analysis (or simply removed from a logical plan).

[NOTE]¶

There are the following logical rules that Logical Analyzer uses to analyze logical plans with the UnresolvedHint.md[UnresolvedHint] logical operator:

• ResolveJoinStrategyHints resolves UnresolvedHint operators with BROADCAST, BROADCASTJOIN, MAPJOIN hints to a ResolvedHint.md[ResolvedHint]

• ResolveCoalesceHints resolves <> logical operators with COALESCE or REPARTITION hints

• RemoveAllHints simply removes all UnresolvedHint operators

The order of executing the above rules matters.¶

// Let's hint the query twice
// The order of hints matters as every hint operator executes Spark analyzer
// That will resolve all but the last hint
val q = spark.range(100).
  hint("broadcast").
  hint("myHint", 100, true)
val plan = q.queryExecution.logical
scala> println(plan.numberedTreeString)
00 'UnresolvedHint myHint, [100, true]
01 +- ResolvedHint (broadcast)
02    +- Range (0, 100, step=1, splits=Some(8))

// Let's resolve unresolved hints
import org.apache.spark.sql.catalyst.rules.RuleExecutor
import org.apache.spark.sql.catalyst.plans.logical.LogicalPlan
import org.apache.spark.sql.catalyst.analysis.ResolveHints
import org.apache.spark.sql.internal.SQLConf
object HintResolver extends RuleExecutor[LogicalPlan] {
  lazy val batches =
    Batch("Hints", FixedPoint(maxIterations = 100),
      new ResolveHints.ResolveJoinStrategyHints(SQLConf.get),
      ResolveHints.RemoveAllHints) :: Nil
}
val resolvedPlan = HintResolver.execute(plan)
scala> println(resolvedPlan.numberedTreeString)
00 ResolvedHint (broadcast)
01 +- Range (0, 100, step=1, splits=Some(8))

[[output]] UnresolvedHint uses the <> operator's output schema for yours.

[TIP]¶

Use hint operator from Catalyst DSL to create a UnresolvedHint logical operator, e.g. for testing or Spark SQL internals exploration.

[source, scala]¶

// Create a logical plan to add hint to import org.apache.spark.sql.catalyst.plans.logical.LocalRelation val r1 = LocalRelation('a.int, 'b.timestamp, 'c.boolean) scala> println(r1.numberedTreeString) 00 LocalRelation , [a#0, b#1, c#2]

// Attach hint to the plan import org.apache.spark.sql.catalyst.dsl.plans._ val plan = r1.hint(name = "myHint", 100, true) scala> println(plan.numberedTreeString) 00 'UnresolvedHint myHint, [100, true] 01 +- LocalRelation , [a#0, b#1, c#2]

====