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)
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, ...)
|
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 |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.