Hive Metastore doubt

hive

#1

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


#2

Can anyone kindly clear my above doubt.
Thank you


#3

@Tarun_Teja

We have to use the database.table name