Hi, Please check below things
Spark SQL commands. > show databases; >show tables; Note: database and tables are already created using Hive database, and stored in Hive Metastore > For “show databases” command, it list databases ‘default’ and ‘dbanil’.. > For “show tables” command, it list table ‘order’ a] First run below command to change database: use ‘dbanil’ ; b] then run below command, which list table ‘order’ show tables; Thanks, Anil
