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, 2019 in Big Data Hadoop by Neil
3,367 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, 2019 by Omkar
• 69,220 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,300 points
2,908 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, 2019 in Big Data Hadoop by nitinrawat895
• 11,380 points
974 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, 2019 in Big Data Hadoop by Gitika
• 65,770 points
2,314 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, 2019 in Big Data Hadoop by Gitika
• 65,770 points
1,538 views
+1 vote
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
• 11,380 points
11,070 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
• 11,380 points
2,569 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
109,020 views
–1 vote
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,350 points
4,635 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
• 69,220 points
1,576 views
–1 vote
1 answer

Error while creating Hive Database table

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

answered Jan 8, 2019 in Big Data Hadoop by Omkar
• 69,220 points
2,927 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP