Error creating External Tables in Hive

0 votes

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

Feb 9 in Big Data Hadoop by Neil
447 views

1 answer to this question.

0 votes

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.

answered Feb 9 by Omkar
• 67,610 points

Related Questions In Big Data Hadoop

0 votes
1 answer

What is the difference between Hive internal tables and external tables?

Hive has a relational database on the ...READ MORE

answered Nov 19, 2018 in Big Data Hadoop by Neha
• 6,280 points
684 views
0 votes
1 answer

Differentiate between Hive internal tables an external tables.

Hive comprises of an RDBMS(Relational-Database-Management-Systems) on its ...READ MORE

answered Mar 27 in Big Data Hadoop by nitinrawat895
• 10,670 points
113 views
0 votes
1 answer

Why CREATE EXTERNAL keyword is used in Hive?

Hey, The create external keyword is used to create a ...READ MORE

answered May 15 in Big Data Hadoop by Gitika
• 25,340 points
25 views
0 votes
1 answer

What is the syntax for creating bucketing table in hive?

Hi, Syntax for creating bucketed table is as ...READ MORE

answered May 16 in Big Data Hadoop by Gitika
• 25,340 points
60 views
0 votes
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,670 points
2,958 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,670 points
330 views
0 votes
10 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
14,661 views
0 votes
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,240 points
1,089 views
–1 vote
1 answer

How we can run spark SQL over hive tables in our cluster?

Open spark-shell. scala> import org.apache.spark.sql.hive._ scala> val hc = ...READ MORE

answered Dec 26, 2018 in Big Data Hadoop by Omkar
• 67,610 points
59 views
–1 vote
1 answer

Error while creating Hive Database table

In your error, it says that the ...READ MORE

answered Jan 8 in Big Data Hadoop by Omkar
• 67,610 points
192 views