Hive Metastore doubt



For below question in Aruns Blog I used same sqoop command…

–>create a hive meta store database named problem6 and import all tables from mysql retail_db database into hive meta store

–>sqoop import-all-tables --connect “jdbc:mysql://quickstart.cloudera:3306/retail_db” --username retail_dba --password cloudera --warehouse-dir /user/hive/warehouse/problem6.db --hive-import --hive-database problem6 --create-hive-table --as-textfile;

While using sqlContext.sql("…") and perform operations which database should i use problem6 or problem.db

Thank you


Can anyone kindly clear my above doubt.
Thank you



We have to use the database.table name