Error creating External Tables in Hive

Question

I got the below issue while creating External Table in Hive

hive> CREATE EXTERNAL TABLE page_view_stg2(viewTime INT, userid BIGINT,
> page_url STRING, referrer_url STRING,
> ip STRING COMMENT "IP Address of the User",
> country STRING COMMENT "country of origination")
> COMMENT "This is the staging page view table"
> ROW FORMAT DELIMITED FIELDS TERMINATED BY "44" LINES TERMINATED BY "\n"
> STORED AS TEXTFILE
> LOCATION "vnvs/hive/stgtbl";
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./vnvs/hive/stgtbl)

Could you please help me ..?

Answer 1

The path which you have given for the External table creation is vnvs/hive/stgtbl. You have to give the absolute path for the table and not the relative path.

To find the absolute path, you can run the following command in the terminal (for linux):

$ pwd

For windows, you can already see the absolute path at the command prompt.