Parameter

Usage

SedonaSQL supports many parameters. To change their values,

1. Set it through SparkConf:

   sparkSession = SparkSession.builder().
         config("spark.serializer","org.apache.spark.serializer.KryoSerializer").
         config("spark.kryo.registrator", "org.apache.sedona.core.serde.SedonaKryoRegistrator").
         config("sedona.global.index","true")
         master("local[*]").appName("mySedonaSQLdemo").getOrCreate()
   

2. Check your current SedonaSQL configuration:

   val sedonaConf = new SedonaConf(sparkSession.sparkContext.getConf)
   println(sedonaConf)
   

Explanation

• sedona.global.index
  • Use spatial index (currently, only supports in SQL range join and SQL distance join)
  • Default: true
  • Possible values: true, false
• sedona.global.indextype
  • Spatial index type, only valid when "sedona.global.index" is true
  • Default: quadtree
  • Possible values: rtree, quadtree
• sedona.join.gridtype
  • Spatial partitioning grid type for join query
  • Default: kdbtree
  • Possible values: quadtree, kdbtree
• sedona.join.indexbuildside (Advanced users only!)
  • The side which Sedona builds spatial indices on
  • Default: left
  • Possible values: left, right
• sedona.join.numpartition (Advanced users only!)
  • Number of partitions for both sides in a join query
  • Default: -1, which means use the existing partitions
  • Possible values: any integers
• sedona.join.spatitionside (Advanced users only!)
  • The dominant side in spatial partitioning stage
  • Default: left
  • Possible values: left, right

---

Last update: August 16, 2022 08:03:14