praveenhalian commented on issue #5993:
URL: https://github.com/apache/superset/issues/5993#issuecomment-2655693930
Fixed the issue
`Enable Asynchronous Query Execution:
Go to the Database Connection page in Superset.
Navigate to the Advanced tab.
Click on the Performance tab.
Enable the Asynchronous Query Execution option.
Install Required Dependencies:
Install the cx_Oracle Python package:
bash
Copy
pip install cx_Oracle
Install the libaio1 library (required for Oracle Instant Client):
bash
Copy
sudo apt install libaio1
Create Persistent Volumes (PV) and Persistent Volume Claims (PVC):
Create the necessary PV and PVC for Oracle client and wallet storage.
Edit Superset and Superset Worker YAML Files:
Add the following environment variables and volume mounts to both the
superset and superset-worker YAML files:
yaml
Copy
env:
- name: SUPERSET_PORT
value: "8088"
- name: LD_LIBRARY_PATH
value: /opt/oracle/instantclient
- name: ORACLE_HOME
value: /opt/oracle/instantclient
- name: TNS_ADMIN
value: /opt/oracle/instantclient/network/admin
volumeMounts:
- mountPath: /app/pythonpath
name: superset-config
readOnly: true
- mountPath: /opt/oracle/instantclient
name: oracle-client
- mountPath: /opt/wallet
name: oracle-wallet
- mountPath: /opt/oracle/instantclient/network/admin
name: tnsnames-config
volumes:
- name: superset-config
secret:
defaultMode: 420
secretName: superset-config
- name: oracle-client
persistentVolumeClaim:
claimName: oracle-client-pvc
- name: oracle-wallet
secret:
defaultMode: 420
secretName: oracle-wallet
- name: tnsnames-config
configMap:
defaultMode: 420
name: tnsnames-config
Deploy the Changes:
Apply the updated YAML files to your Kubernetes cluster to deploy the
changes.
Explanation of Key Steps:
Asynchronous Query Execution: Improves performance by allowing queries to
run asynchronously.
cx_Oracle and libaio1: Required for Oracle database connectivity.
PV and PVC: Ensures persistent storage for Oracle client and wallet files.
Environment Variables and Volume Mounts: Configures the necessary paths and
settings for Oracle connectivity in Superset.
`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
