Query types
This integration supports a wide range of Hive query types, including:
- CREATE TABLE AS SELECT(- CTAS): Captures lineage from source tables to the newly created table. Includes operations like- SELECT,- JOIN,- WHEREfilters, and aggregations within the- CTASstatement.
- INSERT(- OVERWRITE TABLE|- INTO TABLE): Captures lineage from source data to the destination table. Includes operations like- SELECT,- JOIN,- WHEREfilters, and aggregations within the- INSERTstatement.
- SELECTstatements: Do not emit lineage events on their own (as they don't change data). However, intermediate transformations within a- SELECTused in a- CTASor- INSERTare analyzed for column-level lineage.
- Complex Queries: Supports complex queries involving Common Table Expressions (CTEs), joins, filters, aggregations, sorting, window functions, and more.
- Union statements: UNION ALLstatements are supported capturing lineage from multiple input tables to a single destination.