The pymapd client interface provides a python DB API 2.0-compliant OmniSci interface (formerly MapD). In addition, it provides methods to get results in the Apache Arrow -based GDF format for efficient data interchange.
>>> from pymapd import connect
>>> con = connect(user="mapd", password="HyperInteractive", host="localhost",
... dbname="mapd")
>>> query = "SELECT depdelay, arrdelay FROM flights_2008_10k limit 100"
>>> df = con.select_ipc_gpu("SELECT depdelay, arrdelay "
... "FROM flights_2008_10k "
... "LIMIT 100")
>>> df.head()
depdelay arrdelay
0 -2 -13
1 -1 -13
2 -3 1
3 4 -3
4 12 7
install usage api contributing
genindex
modindex
search