Member since
10-30-2018
1
Post
1
Kudos Received
0
Solutions
12-03-2019
06:20 PM
The solution is to create your own custom CDSW engine. # Built on CDSW v8 Starting with v8 with CDSW 1.6 ``` $cat /etc/issue Ubuntu 16.04.6 LTS \n \l ``` ## Built from [mssql-docker](https://github.com/microsoft/mssql-docker/blob/master/oss-drivers/pyodbc/Dockerfile) Dockerfile: FROM docker.repository.cloudera.com/cdsw/engine:8 MAINTAINER IQVIA # apt-get and system utilities RUN apt-get update && apt-get install -y \ curl apt-utils apt-transport-https debconf-utils gcc build-essential g++-5\ && rm -rf /var/lib/apt/lists/* # adding custom MS repository RUN curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - RUN curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list # install SQL Server drivers RUN apt-get update && ACCEPT_EULA=Y apt-get install -y msodbcsql unixodbc-dev # install SQL Server tools RUN apt-get update && ACCEPT_EULA=Y apt-get install -y mssql-tools RUN echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc RUN /bin/bash -c "source ~/.bashrc" # upgrade pip RUN pip install --upgrade pip # install SQL Server Python SQL Server connector module - pyodbc RUN pip install pyodbc
... View more