Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive Table creation error

avatar
New Contributor
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: hdfs://nameservice1./home/xxx/Airports_new
 

 I am unable to create a table in hive since i am new to this HIVE

2 REPLIES 2

avatar
Master Guru

@Dasan I am not the expert but This issue due to bad HDFS URI (hdfs://hdfs://nameservice1./home/xxx/Airports_new) for one of your hive databases. You can test using below steps. 

1. Delete the database from Hive
2. Clean HDFS directory folder which is manually created.
3. Clean all its metadata entires.
4. Create the database again. 

 


Cheers!
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

avatar
Master Guru

@Dasan Did this resolved your issue? If so Please accept as Solution 


Cheers!
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.