Column already exists

Common SQL Errors

Schema

Duplicated column alias in output

ClickHouse
Sign up for the latest in common SQL errors from the Galaxy Team!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Typical Error Message

Column already exists

Explanation

This error means that the query includes multiple columns with the same alias or name in the SELECT clause. Rename one of the columns to resolve the conflict.

Common Causes

Using the same alias multiple times

Related Errors

FAQs

Check out some other errors

Trusted by top engineers on high-velocity teams
Aryeo Logo
Assort Health
Curri
Rubie
BauHealth Logo
Truvideo Logo