By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

**FAILED: SemanticException [Error 10035]: Column repeated in partitioning columns ** while creating another table with partitioning enabled

1

This query ran against the "sf_sav_raw" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: 70884e2f-ed4d-4268-b5b5-1c630aa47570

Topics
Analytics
Tags
Amazon Athena
Language
English
rePost-User-8051465
asked 2 years ago1648 views
1 Answer
1

This error in CREATE TABLE occurs when a partitioned column name is same as one of the table columns name defined in schema.

For more information: https://docs.aws.amazon.com/athena/latest/ug/create-table.html

AWS
Sachin_KV
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content