Support Questions

keerthanakumar2 · ‎01-31-2016

Whenever I execute the following query : sqoop list-databases --connect jdbc:mysql://localhost:3306 --username xxx -password xxx . Only the following tables are displayed information_schema, hive, mysql, ranger, ranger_audit,test, but not the databases which I created inside mysql workbench. Your guidance will be appreciated.

nsabharwal · ‎02-01-2016

@keerthana gajarajakumar I suggest to load the file from OS.

yum -y install git

git clone https://github.com/datacharmer/test_db.git

[root@sandbox ~]# cd test_db/

[root@sandbox test_db]# ls

Changelog employees.sql load_dept_emp.dump load_salaries1.dump load_titles.dump sakila test_employees_md5.sql

employees_partitioned_5.1.sql images load_dept_manager.dump load_salaries2.dump objects.sql show_elapsed.sql test_employees_sha.sql

employees_partitioned.sql load_departments.dump load_employees.dump load_salaries3.dump README.md sql_test.sh

[root@sandbox test_db]# mysql < employees.sql

View solution in original post

nsabharwal · ‎02-01-2016

@keerthana gajarajakumar In case of mysql password

[root@sandbox test_db]# mysql -u root -proot < employees.sql

INFO

CREATING DATABASE STRUCTURE

INFO

LOADING departments

INFO

LOADING employees

INFO

LOADING dept_emp

INFO

LOADING dept_manager

INFO

Cloudera Community

Support Questions

I'm unable to view the databases inside Mysqlworkbench. Instead the following databases are listed : information_schema, hive, mysql, ranger, ranger_audit,test

High Availability for MySQL Database

Make mysql database as Hive's Metastore:

CDP Private Cloud 7.16 : HUE MYSQL 8 connection er...

Script to get all Hive Databases and underling tab...

Migrating Hive database from Postgress to Mysql

sqoop list-databases error

Hbase Vs MySQL database ( Hadoop ) vs (Conventiona...

Change default permission of hive database

MySQL HA for Cloudera CDP Provate Cloud Base Datab...

Restore Hive MySQL database for new Hive service o...