Issues using sqoop command while listing database

0 votes

I was able to successfully create databases, tables and inserted records into it. Now, I am encountering an issue while executing sqoop command to either list the databases/tables or to insert into HDFS using the command. 

$ sqoop -list-databases \
> --connect jdbc:mysql://mysqld \
> --username root -password edureka;
Warning: /usr/lib/hcatalog does not exist! HCatalog jobs will fail.
Please set to the root of your HCatalog installation.
No such sqoop tool: -list-databases. See sqoop
May 23, 2019 in Big Data Hadoop by Richard
1,234 views

Hi @Richard. Please share the output of the jps command

hey @Jimmy, this is the output you asked for:

$ jps
1943 JobHistoryServer
29191 SecondaryNameNode
1887 NodeManager
28896 NameNode
29001 DataNode
1830 ResourceManager
26480 Jps

1 answer to this question.

0 votes

Please use the following command.

sqoop list-databases --connect jdbc:mysql://localhost/ -username root -P

It should work

answered May 23, 2019 by Raj

Related Questions In Big Data Hadoop

0 votes
1 answer

How to fetch more data from database while using Sqoop import?

Hey. You guessed it right. The max ...READ MORE

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

How to overwrite HIVE_HOME while using sqoop?

Sqoop by default takes the HIVE_HOME as ...READ MORE

answered May 15, 2019 in Big Data Hadoop by Vidya
1,437 views
0 votes
1 answer

Getting error message on execution of sqoop command to list database

Please use the sqoop list database syntax ...READ MORE

answered May 23, 2019 in Big Data Hadoop by Rashmi
2,123 views
0 votes
1 answer

Connection String for MySQL database using Sqoop

The format for the connection string and ...READ MORE

answered Jun 6, 2019 in Big Data Hadoop by John
2,023 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,029 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,537 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
108,836 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,612 views
0 votes
1 answer

Getting error while using sqoop import.

You are trying to execute the sqoop ...READ MORE

answered Jul 5, 2019 in Big Data Hadoop by Reshma
1,409 views
0 votes
2 answers

How to see MySql service is running or not using linux command?

Hi, You can simply run the following commands ...READ MORE

answered Jan 21, 2020 in Big Data Hadoop by anonymous
2,256 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