spark sql 查询hive表是否存在

it2026-04-14  3

利用 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

最新回复(0)