Using R to display configuration of Spark SQL

Question

I am learning Data Science using R language. I am using R and Apache Spark in combination and need some help with it. There is Spark SQL running and there are some configurations that are already set. For some task, I need to set the configuration to a particular setting. Instead of changing all the configuration, I want to change only those that are different from what I need. Can someone help me with how I can display the SQL configurations?

Answer 1

Try the below-mentioned code.

sparkR.session()
properties <- sql("SET -v")
showDF(properties, numRows = 200, truncate = FALSE)

It should print the configurations