HiveSQL for Python developers
Use the following code to connect to HiveSQL using Python:
import pypyodbc
connection = pypyodbc.connect('Driver={ODBC Driver 13 for SQL Server};'
'Server=vip.hivesql.io;'
'Database=DBHive;'
'uid=[your_hivesql_account];'
'pwd=[your_hivesql_password]')
cursor = connection.cursor()
SQLCommand = ("YOUR SQL QUERY”)
cursor.execute(SQLCommand)
# do whatever you want with the retrieved data
connection.close()
Remember you need to have ODBC drivers installed on your computer.
How to install the Microsoft ODBC Driver for SQL Server on Linux and macOS
On Debian 9
sudo curl https://ift.tt/2OlWDWn > /etc/apt/sources.list.d/mssql-release.list
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install msodbcsql17
Optional for bcp and sqlcmd
sudo ACCEPT_EULA=Y apt-get install mssql-tools
echo ‘export PATH=”$PATH:/opt/mssql-tools/bin”‘ >> ~/.bash_profile
echo ‘export PATH=”$PATH:/opt/mssql-tools/bin”‘ >> ~/.bashrc
source ~/.bashrc
Optional for unixODBC development headers
sudo apt-get install unixodbc-dev
For more details on how to install Microsoft SQL ODBC drivers, you can read this post published by @geekgirl