Support Questions
Find answers, ask questions, and share your expertise

sqoop list-databases is showing only system databases or public.!!

Hi,

sqoop list-databases --connect jdbc:mysql://sandbox.hortonworks.com/hive --username hive --password hive is showing only system databases or public. How can i see the databases i created in hive??

Mamta

3 REPLIES 3

Re: sqoop list-databases is showing only system databases or public.!!

you should use below hive command instead of sqoop to see the databases you creased in hive from your user.

-bash-4.1$ hive -e "show databases"

Re: sqoop list-databases is showing only system databases or public.!!

Guru

@Mamta Chawla: Are you looking for hive database or mysql database ?

In your sqoop command it look likes it is just for mysql.

Re: sqoop list-databases is showing only system databases or public.!!

@Saurabh Kumar

I am looking for bothe database, using sqoop.

sqoop list-databases --connect jdbc:mysql://sandbox.hortonworks.com/hive --username hive --password hive

sqoop list-databases --connect jdbc:mysql://sandbox.hortonworks.com/mysql --username hive --password hive

I got these urls from hive-site.xml. Is there any other connection string I need to refer???

Mamta