How to get Spark SQL configuration

Question

I want to know on what configuration is my Spark SQL running. What command should I use to know the configuration of Spark SQL?

Answer 1

First create a Spark session like this:

val sqlContext=new SQLContext(sparkContext);
val spark=sqlContext.sparkSession

And then use the below command to get the SQL configurations:

spark.sql("SET -v").show(numRows = 200, truncate = false)