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 in Big Data Hadoop by Richard
26 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 by Raj

Related Questions In Big Data Hadoop

0 votes
1 answer
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 in Big Data Hadoop by Vidya
50 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 in Big Data Hadoop by Rashmi
67 views
0 votes
1 answer
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,739 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
289 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
13,573 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
995 views
0 votes
1 answer

Getting error while using sqoop import.

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

answered Jul 5 in Big Data Hadoop by Reshma
46 views
0 votes
1 answer