Hi Guna, i try as you said, default and cloudera both databases have the tables but its not showing tables. When i try as "show databases" its not showing bothdatabases its showing only default. Please See Bellow scala> val df = hiveObj.sql("show tables in cloudera") df: org.apache.spark.sql.DataFrame = [tableName: string, isTemporary: boolean] scala> df.show() +---------+-----------+ |tableName|isTemporary| +---------+-----------+ +---------+-----------+ scala> val df1 = hiveObj.sql("show tables in default") df1: org.apache.spark.sql.DataFrame = [tableName: string, isTemporary: boolean] scala> df1.show() +---------+-----------+ |tableName|isTemporary| +---------+-----------+ +---------+-----------+ scala> val df2 = hiveObj.sql("show databases") df2: org.apache.spark.sql.DataFrame = [result: string] scala> df2.show() +-------+ | result| +-------+ |default| +-------+
... View more
