Skip to content

Main Navigation

Layout & Formatting

Appearance

Sidebar Navigation

Getting Started

Introduction

Installation

Basic Usage

Custom Usage

Why SQLFluff?

Vision

Usage Guides

Production Usage

Team Rollout

CI/CD Integration

Pre-commit

Diff Quality

Troubleshooting

Development

Architecture

Dialect Changes

Developing Rules

Plugins

Custom Rules

Documentation

Configuration

Overview

Rules

Layout & Formatting

Templating

Overview

Variants Rendering

Jinja

Placeholder

Python

dbt

Generic Templater

Ignoring Errors

Default Configuration

Reference

CLI Reference

Overview

dialects

fix

format

lint

parse

render

rules

version

Rules Reference

Overview

Aliasing

Ambiguous

Capitalisation

Convention

Jinja

Layout

Oracle

Postgres

References

Structure

Tsql

Python API

Overview

Simple API

Advanced API

Info

SQL Dialects

Overview

ANSI

AWS Athena

Google BigQuery

ClickHouse

Databricks

IBM Db2

Apache Doris

DuckDB

Exasol

Apache Flink SQL

Greenplum

Apache Hive

Apache Impala

MariaDB

Materialize

MySQL

Oracle

PostgreSQL

AWS Redshift

Snowflake

Salesforce Object Query Language (SOQL)

Apache Spark SQL

SQLite

StarRocks

Teradata

Trino

Microsoft T-SQL

Vertica

Release Notes

On this page

Apache Hive

Property	Value
Label	`hive`
Inherits From	ansi

The dialect for Apache Hive.

Edit this page on GitHub

Pager

Previous pageGreenplum

Next pageApache Impala

Released under the MIT License.

Copyright © 2026 SQLFluff Contributors