检查pyspark sparksession中的Hive中是否存在表

from pyspark.sql import SparkSession

spark = SparkSession.builder \
    .appName("HiveTableCheck") \
    .enableHiveSupport() \
    .getOrCreate()

database_name = "your_database_name"
table_name = "your_table_name"

if spark.catalog.tableExists(f"{database_name}.{table_name}"):
    print(f"The table {database_name}.{table_name} exists in Hive.")
else:
    print(f"The table {database_name}.{table_name} does not exist in Hive.")

database_name = "your_database_name"
table_name = "your_table_name"

table = spark.catalog.getTable(f"{database_name}.{table_name}")
print(f"Table Name: {table.name}")
print(f"Table Type: {table.tableType}")
print(f"Table Schema: {table.schema}")
print(f"Table Properties: {table.properties}")