Support Questions
Find answers, ask questions, and share your expertise

Hive Table creation error

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

@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.

@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.
; ;