While creating a new table with partition and you got this error:
SemanticException [Error 10035]: Column repeated in partitioning columns
You have redundantly included a column to be partitioned on your create table clause.
Say we want to create a user table partitioned by lastname the following create statement will generate the above error:
CREATE TABLE `user` ( `firstname` STRING, `lastname` STRING, `age` INT ) PARTITIONED BY (lastname STRING);
Moving of Columns to Partioned By Clause
To fix this, we need to remove the declaration of lastname column from the create table clause.
CREATE TABLE `user` ( `firstname` STRING, `age` INT ) PARTITIONED BY (`lastname` STRING);