Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is there a way to connecto Spark-Sql with sqlalchemy

Is there a way to connect Spark-Sql with sqlalchemy I have legacy code that uses sqlalchemy How could i make it use spark-sql ,can i make sqlalchemy as the translation layer to spark-sql ?

like image 549
sami Avatar asked Apr 25 '17 16:04

sami


People also ask

What SQL does SQLAlchemy use?

Supported Databases. SQLAlchemy includes dialects for SQLite, Postgresql, MySQL, Oracle, MS-SQL, Firebird, Sybase and others, most of which support multiple DBAPIs.


1 Answers

yes , look at this project https://github.com/dropbox/PyHive

There are some adjustments you will need to do , fortunately SQLAlchemy is build for that

like image 160
sami Avatar answered Sep 27 '22 20:09

sami