This the command I written for creating external table in Intellij
val ex_table= spark.sql("Create EXTERNAL TABLE IF NOT EXISTS userdf.ex_table(Id Int,Name String,Time Timestamp) PARTITIONED BY(Location String) STORED AS PARQUET LOCATION 'C:\\Users\\XSA1BGP\\IdeaProjects\\Spark_Bigdata'");
//ex_table.describe()
It is not showing any exceptions but the table is not displayed yet
