Query Optimization with Predicate Pushdown

CodingDatabricksLast reported January 2026Low Frequency
Reported
1× across candidate reports
First seen
January 2026
Last reported
January 2026
Reported outcome
unknown

Problem Overview

You are given a data structure (a tree of nodes) representing a SQL query. Your task is to implement query optimizations on this tree. The interviewer expects you to know or derive the concept of predicate pushdown (filter pushdown) and related optimizations. Specifically, candidates were asked to implement: (1) column…

  • 2 candidate-reported follow-ups — the exact probes interviewers asked, with the trigger for each
  • The rest of the problem statement — full requirements, constraints, and edge cases
  • Approach and trade-offs — what passing candidates did, and the mistakes that sink people
Unlock the full Databricks catalog
Full problem statements, candidate-reported follow-ups, and walkthroughs — for every Databricks question.
Unlock with Pro
Already a member? Sign in
Verified Source
Every question is reconstructed from multiple independent candidate reports. Verbatim follow-ups, not invented ones.
Codex Fact-Checked
Technical claims, formulas, and scale numbers are reviewed against primary sources.
Interviewer Follow-ups
The exact follow-ups reported by candidates, with the trigger that prompts each one — plus the mistakes that sink people.
Is this helpful?