spark sql 查询hive表是否存在

• 利用 show tables in DBname like ‘TABLEname’ 语句

var userid = "test"
var datasetid1 = "dm_op_log"
var datasetid2 = "bb"

var s = spark.sql(s"show tables in $userid like '$datasetid1'  ")
s.show()

println("@@@@", s.count())

var s2 = spark.sql(s"show tables in $userid like '$datasetid2' ")

s2.show()

println("!!!!", s2.count())

print(s.count()==0, "~~~~~~~~~", s2.count()==0)

结果：

参考链接：https://www.thinbug.com/q/21194677