Audit Vertica tables in Spark!

[sarvesh]

I am trying to use Audit from Vertica in spark and getting correct table size from it, but the minimum size Audit function can find is bytes, but we are getting data in bits even smaller than bytes.

val size = f"select audit('table_name');"

[Hubert-Dudek]

Rather everything will be in bytes. Spak sql have built in methods to get table size but also in bytes:

spark.sql("ANALYZE TABLE df COMPUTE STATISTICS NOSCAN")

spark.sql("DESCRIBE EXTENDED df ").filter(col("col_name") === "Statistics").show(false)