RJDBC

HeavyDB supports the R language using RJDBC.
Examples
Local Host Example
1
library(RJDBC)
2
drv <- JDBC("com.heavyai.jdbc.HeavyAIDriver",
3
            "/home/heavyai/bin/heavyai-utility-6.0.jar",
4
            identifier.quote="'")
5
conn <- dbConnect(drv, "jdbc:heavyai:localhost:6274:heavyai", "admin", "HyperInteractive")
6
dbGetQuery(conn, "SELECT i1 FROM test1  LIMIT 11")
7
dbGetQuery(conn, "SELECT dep_timestamp FROM flights_2008_10k  LIMIT 11")
Copied!
Remote Host Example
1
library(RJDBC)
2
drv <- JDBC("com.heavyai.jdbc.HeavyAIDriver",
3
            "/home/heavyai/bin/heavyai-utility-6.0.jar",
4
            identifier.quote="'")
5
conn <- dbConnect(drv,
6
                  "jdbc:heavyai:colossus.heavyai.com:6274:heavyai",
7
                  "admin",
8
                  "HyperInteractive")
9
dbGetQuery(conn,
10
  paste("SELECT date_trunc(month, taxi_weather_tracts_factual.pickup_datetime)",
11
        "  as key0,",
12
        "AVG(CASE WHEN 'Hyatt' = ANY",
13
        "    taxi_weather_tracts_factual.dropoff_store_chains THEN 1 ELSE 0 END)",
14
        "  AS series_1",
15
        "FROM taxi_weather_tracts_factual",
16
        "WHERE (taxi_weather_tracts_factual.dropoff_merc_x >= -8254165.98668337",
17
        "  AND taxi_weather_tracts_factual.dropoff_merc_x < -8218688.304677745)",
18
        "AND (taxi_weather_tracts_factual.dropoff_merc_y >= 4966267.65475399",
19
        "  AND taxi_weather_tracts_factual.dropoff_merc_y < 4989291.122013792)",
20
        "AND (",
21
        "  taxi_weather_tracts_factual.pickup_datetime",
22
        "    >= TIMESTAMP(0) '2009-12-20 08:13:47'",
23
        "  AND taxi_weather_tracts_factual.pickup_datetime",
24
        "    < TIMESTAMP(0) '2015-12-31 23:59:59')",
25
        "GROUP BY key0 ORDER BY key0", sep=" "))
Copied!

Try Vega

Next - APIs and Interfaces

Python: heavyai

Last modified 1mo ago

Export as PDF

Copy link

Contents

Examples

Local Host Example

Remote Host Example