Error Hive show tables does not display table sqooptest which was imported by SQOOP

0 votes
hive> show tables tablename I have imported MySQL to HVE using SQOOP, once it done I can able to see from Hadoop File System(HDFS), but When I use "show tables tablname" from HIVE console, it throws no table exists.

Can anyone tell how to solve this?
Aug 7, 2019 in Big Data Hadoop by Sheena
1,430 views

1 answer to this question.

0 votes

Hi,

You can follow the below-given solution.

Just enter into hiveQL from where you used the sqoop import commands.

bin# cd /opt 

[opt]#$SQOOP_HOME/bin/sqoop import --connect jdbc:mysql://localhost:3306/hadoop --table huser --hive-import --split-by name --hive-table sqooptest -username root -P

Execute hive from /opt, if you are trying to enter other-then this dir, you will not able to view 

[opt]#$HIVE_HOME/bin/hive hive> show tables tablename

By default HIVE metadata stored in derby database. Derby store the data into current working dir. That can be customized by user "hive-default.xml"

answered Aug 7, 2019 by Gitika
• 65,770 points

edited Aug 7, 2019 by Gitika

Related Questions In Big Data Hadoop

+3 votes
1 answer

Getting Connection Error while loading data into table using cloudera hive

Hey Nafeesa, Itseems that Hive is not able ...READ MORE

answered Oct 4, 2018 in Big Data Hadoop by Vardhan
• 13,150 points
1,013 views
+2 votes
1 answer

Hadoop Jersey 1.x injection which is now not supported by Weblogic 12C

Add these lines to your weblogic-application.xml file ...READ MORE

answered Oct 31, 2018 in Big Data Hadoop by Omkar
• 69,220 points
1,355 views
0 votes
1 answer

Hadoop Java: org.apache.hadoop.conf.Configuration does not exist error

To solve this error, add hadoop-common to ...READ MORE

answered Nov 21, 2018 in Big Data Hadoop by Omkar
• 69,220 points
7,563 views
0 votes
2 answers

Hadoop error: Input path does not exist

I was able to fix the issue. ...READ MORE

answered Jan 13, 2019 in Big Data Hadoop by Ponezhil Ramu
14,370 views
0 votes
1 answer

Update hdfs data before stroring in MySql

Yes, you can update the data before ...READ MORE

answered Jan 27, 2019 in Big Data Hadoop by Omkar
• 69,220 points
784 views
0 votes
1 answer

How to connect Sqoop to mysql Database?

Hi. You can connect Sqoop to MySql ...READ MORE

answered May 15, 2019 in Big Data Hadoop by Tina
2,704 views
0 votes
1 answer

Problem connecting Sqoop to MySql

Perhaps, you have slightly misunderstood the method ...READ MORE

answered May 15, 2019 in Big Data Hadoop by Ali
2,297 views
0 votes
2 answers

How to pass a password to Sqoop import command?

You can directly pass the password in ...READ MORE

answered May 15, 2019 in Big Data Hadoop by Raj
7,201 views
0 votes
1 answer

Error: input path does not exist

Hey, This error looks like your job History ...READ MORE

answered Apr 30, 2019 in Big Data Hadoop by Gitika
• 65,770 points
3,330 views
0 votes
1 answer

Where is table data stored in Apache HIve by default?

Hi, yes, you can do it by using  ...READ MORE

answered Jun 19, 2019 in Big Data Hadoop by Gitika
• 65,770 points
1,603 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