1. Home
  2. Latest Release Docs
  3. Guides
  4. Concepts
  5. Tools
  6. References
    1. Apache Spark
    2. Built-in Functions
    3. Incorta Component SDK
    4. Incorta Connector SDK
    5. Connectors
    6. Data Studio
    7. Public API
    8. Security
    9. SQL Interface
      1. SQL Interface
      2. Configure Spark with SQLi
      3. Advanced SQL Interface
        1. Setup and Configuration
        2. SparkX Metastore Sync
        3. Discovery of Non-Optimized Tables
        4. SparkX Access to Cloud Storage
        5. Data Extraction via Advanced SQLi and Public API
        6. Scalability Modes
        7. Advanced SQLi Ports
        8. Custom SparkX Sizes
        9. Notebook for Business Users
        10. Advanced SQLi and Null Handling
    10. Visualizations
    11. Other
  7. Integrations
  8. Data applications
  9. Release Notes
  10. Incorta Premium

References → Advanced SQLi Ports

For on-prem installations, you must be aware of the following ports that the advanced SQLi uses.

Kyuubi

Configuration file is located at: IncortaNode/kyuubi/services/{}/conf/kyuubi-defaults.sh

NamePortComment
kyuubi.zookeeper.embedded.port 21810
kyuubi.frontend.thrift.http.bind.port 10010Can be configured, default 10010
kyuubi.frontend.thrift.binary.bind.port 10009Can be configured, default 10009
kyuubi.incorta.auth.service.port 50051Kyuubi uses this port to communicate with the analytics service
spark.sql.incorta.port5003Kyuubi uses this port to communicate with the analytics service
spark.driver.port 5558Kyuubi uses this port to communicate with custom Spark (SparkX)
spark.ui.port 4040Default value allocated by Kyuubi

SparkX

Config location on 2024.1.x clusters: IncortaNode/sparkX/conf/spark-env.sh

Note

Starting 2024.7.x and with the introduction of the unified Spark instance, you won't need to specify these Spark ports.

NamePort
SPARK_MASTER_PORT 5055
SPARK_MASTER_WEBUI_PORT 5051
SPARK_WORKER_PORT5058
SPARK_WORKER_WEBUI_PORT 5052

gRPC

NamePort
incorta.grpc.server.port50051

Arrow Flight

NamePort
flight.result.data.port8090
flight.meta.data.port5003
flight.ddm.data.port5002