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
170 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 66,880 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,180 points
369 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
• 9,310 points
94 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
• 13,670 points
12 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
• 13,670 points
17 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
• 9,310 points
1,824 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
• 9,310 points
152 views
0 votes
10 answers

hadoop fs -put command?

copy command can be used to copy files ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Sujay
9,017 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,260 points
647 views
0 votes
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
• 66,880 points
33 views
0 votes
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
• 66,880 points
47 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.