CODEWITHSUNDEEP
hadoophive
user2978621
user2978621

Reputation: 813

Hive alter table statement

ALTER TABLE abc ADD PARTITION (year = 2014,month=1,day=1) location '/data/input/abc/year=2014/month=1/day=1';
FAILED: ParseException line 1:47 character ' ' not supported here

why this error is coming up

Upvotes: 1

Views: 3534

Answers (1)

jtravaglini
jtravaglini

Reputation: 1746

It appears the error is occurring because you have a space inside your partition command.

year = 2014

Try instead

year=2014

...assuming your year column is of int. Type. If it's a string you'd need

year='2014'

Upvotes: 2

Related Questions