MapD.jl

A julia library for conveniently inserting data to MapD
Popularity
1 Star
Updated Last
2 Years Ago
Started In
March 2018

MapD

This Julia package is an unofficial interface to MapD/OmniSci and makes use of the mapdql and StreamImporter tools. It was developed to let people conveniently send DataFrames into MapD for visualization.

I have only bundled the Linux binaries so if you wish to use this wrapper on Windows or OSX, please use their native tools instead. You shouldn't be downloading binaries from untrusted git repos anyway.

Currently the following data-types are supported:

Julia Type MapD type
String TEXT
Int16 SMALLINT
Int32 INTEGER
Int64 BIGINT
Bool BOOLEAN
Float32 FLOAT
Float64 DOUBLE
DateTime TIMESTAMP

Example use

mapdwrite() will return a UInt16 error code which you can check. If the returned value is 0 then you're in good shape. You can also truncate the table before inserting new data. If the table doesn't exist, it will be created. If the types do not match, you will get a warning.

julia> using MapD, DataFrames

julia> con = MapDcon()
MapD.MapDcon("localhost", 9091, "mapd", "HyperInteractive", "mapd")

julia> err = mapdwrite(con, dataframe, "specialtable", truncate=true)