CCA175: Configuration param "spark.sql.shuffel.partitions"

Just wanted to know, do we have to manually set partition using below query or it will be already set on given cluster.

sqlContext.sql("set spark.sql.shuffel.partitions=10")

parameter is spark.sql.shuffle.partitions

If you do not set this parameter it will take 200 tasks in each stage of spark sql.