HiveS2Connection-class: function HiveS2 copied from RJDBC creates HiveS2Driver dbObj

Description Usage Arguments

Description

function HiveS2 copied from RJDBC creates HiveS2Driver dbObj

dbWriteTable writtes table into local temporary dile and than it is laded into Hive with 'LOAD DATA' statment Sceleton of the fuction adapted from RJDBC packade

when specifying schema all queries that follow will be executed on that schema (warning message)

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
HiveS2(driverClass = "", classPath = "", identifier.quote = "`")

## S4 method for signature 'HiveS2Connection,character'
dbQuoteIdentifier(conn, x, ...)

## S4 method for signature 'HiveS2Connection,SQL'
dbQuoteIdentifier(conn, x, ...)

## S4 method for signature 'HiveS2Connection'
dbGetInfo(dbObj, ...)

## S4 method for signature 'HiveS2Connection'
show(object)

## S4 method for signature 'HiveS2Connection'
dbDisconnect(conn, ...)

## S4 method for signature 'HiveS2Connection,ANY'
dbWriteTable(
  conn,
  name,
  value,
  overwrite = FALSE,
  append = FALSE,
  force = FALSE,
  ...
)

## S4 method for signature 'HiveS2Driver'
dbConnect(drv, host, port, schema = NULL, user = "", password = "", ...)

## S4 method for signature 'HiveS2Connection'
dbListTables(conn, pattern = NULL, schema = NULL, ...)

Arguments

overwrite

allows to specify weather existing table with the same name should be removed

drv

HiveS2Driver object

schema

- database which tables will be listed from

pattern

- specify pattern for SQL 'SHOW TABLES LIKE' statment


stud-th/RHiveS2 documentation built on Feb. 1, 2021, 1:02 p.m.