Common Operations

The contents of this section are designed to guide a new user through how to use DataFusion.

• Registering Views
• Basic Operations
• Column Selections
• Expressions
  • Column
  • Literal
  • Boolean
  • Arrays
  • Lambda functions
  • Testing membership in a list
  • Conditional expressions
  • Structs
  • Functions
• Joins
  • Inner Join
  • Left Join
  • Full Join
  • Left Semi Join
  • Left Anti Join
  • Duplicate Keys
  • Disambiguating Columns with DataFrame.col()
• Functions
  • Mathematical
  • Conditional
  • Temporal
  • String
  • Casting
  • Other
• Handling Missing Values
  • fill_null
• Spark-Compatible Functions
  • Why a Separate Namespace?
  • DataFrame API
  • SQL
  • Function Reference
• Aggregation
  • Setting Parameters
  • Grouping Sets
  • Aggregate Functions
  • User-Defined Aggregate Functions
• Window Functions
  • Setting Parameters
  • Aggregate Functions
  • Available Functions
  • User-Defined Window Functions
• User-Defined Functions
  • Scalar Functions
  • Aggregate Functions
  • Window Functions
  • Table Functions