Hive Table creation error

[#1]

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]

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

[#3]

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