1. Home
  2. Previous Releases
  3. Latest Release
  4. Guides
  5. Concepts
  6. Tools
  7. References
    1. Apache Spark
    2. Built-in Functions
    3. Incorta Component SDK
    4. Incorta Connector SDK
    5. Connectors
    6. Public API
    7. Security
    8. 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. Visualizations
    10. Other
  8. Integrations
  9. Data applications
  10. Releases

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:IncortaNode/sparkX/conf/spark-env.sh

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