Hi Team,
I am getting the following error while creating external table in hive. It is related to the host name.
My host name is [rittikde929532@cxln4 ~]$ hdfs dfs -ls.
Could you please help to resolve my issue. I am getting the following error.
CREATE EXTERNAL TABLE Standard_Chartered.Account(Name string, Age int, Salary Decimal(10,2))
> PARTITIONED BY (ods Date)
> ROW FORMAT DELIMITED
> Fields Terminated By ‘,’
> STORED AS TEXTFILE
> LOCATION ‘hdfs://cxln1.c.thelab-240901.internal:8020./rittikde929532/user/External_Table/Standard_Chartered/Account’;
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:java.io.IOException: Incomplete HDFS URI, no host: hdfs:/
/cxln1.c.thelab-240901.internal:8020./rittikde929532/user/External_Table/Standard_Chartered/Account)