failed during adding a partition in hive external tables

Question

im trying to create a simple external table in hive cli and I got an error while creating a partition. I have searched on google, but I was not able to get a proper result. Can you please help

hive (sampledb)> create external table externalhive(id int,name varchar(100),age tinyint,city varchar(100),state varchar(100)) partitioned by (year string)
            > row format delimited fields terminated by '/t' stored as textfile location '/user/ah12x/external';                                      
OK
Time taken: 0.169 seconds
hive (sampledb)> show tables;
OK
externalhive

hive (sampledb)> alter table externalhive add partition (year ='2014')
            > location ('/2012');                                  
FAILED: ParseException line 2:9 extraneous input '(' expecting StringLiteral near '<EOF>'

serge_k · Accepted Answer · 2020-01-31 08:19:45Z

1

There is no need for braces after location, https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterTable/PartitionLocation

answered Jan 31, 2020 at 8:19

serge_k

1,7822 gold badges16 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

failed during adding a partition in hive external tables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related