This guide will help you set up your environment to use DeSQL for debugging SQL queries in Data-Intensive Scalable Computing (DISC) environments. Ensure all prerequisites are met before proceeding with the installation.
- Docker: Required to create and manage your debugging environment.
- Download and install Docker Desktop for your operating system from Docker Hub.
- Python 3: Required for running scripts and analysis tools.
- Install Python 3 from Python.org.
- Ensure that ports 4040 and 8080 are available on your system. These ports are used for the DeSQL UI and Vanilla Spark UI, respectively.
- The installation steps have been tested on MacOS (ProductVersion: 11.2.3, BuildVersion: 20D91).
- Docker version 20.10.22 or newer is recommended.
If you haven’t already installed Docker, follow the link provided in the Software Requirements section to download and install the latest version suitable for your operating system.
Ensure Python 3 is installed by running python3 --version in your terminal. If Python is not installed, follow the link provided above to install it.
Check if the required ports (4040 and 8080) are free on your system using the following command:
sudo lsof -i :4040 -i :8080If these ports are in use, you may need to free them or configure the software to use different ports.
Clone the DeSQL repository from GitHub to your local machine:
git clone https://github.com/SEED-VT/DeSQL.gitNavigate into the cloned directory:
cd DeSQLBefore building the Docker image, clean up any system-generated files that might interfere with Docker builds:
find . -name '.DS_Store' -type f -deleteAfter completing these installation steps, you are ready to proceed with building the Docker image and setting up the DeSQL environment as detailed in the readme.md.
It's essential to ensure that Docker is correctly configured and running on your system before attempting to build and deploy Docker containers as outlined in the readme.md.
If you encounter permission issues with Docker commands, using sudo may be necessary, or you may need to adjust your Docker settings to run without sudo in Linux environments.
For any issues related to Python packages, ensure that your Python environment is correctly set up and that all dependencies are installed as required.