ConvertToHANADataFrame

ConvertToHANADataFrame is to convert the R data.frame into a HANA DataFrame.

ConvertToHANADataFrame(
  connection.context,
  data,
  table,
  schema = NULL,
  force = FALSE,
  native = TRUE,
  col.types = NULL,
  ...
)

Arguments

connection.context

ConnectionContext
SAP HANA Database connection object.

data

R data.frame
The R data.frame.

table

character
The name of SAP HANA table (does not contain schema name) to store the data from R data.frame.

schema

character, optional
The name of database schema.
Defaults to the schema of connection.context.

force

logical, optional
If the table with same name exists:

• TRUE: the existing table will be replaced.

• FALSE: error message pops up.

Defaults to FALSE.

native

logical, optional

• TRUE: use JDBC/ODBC methods to write the table.

• FALSE: insert the table row by row.

Defaults to FALSE.

col.types

named vector of character, optional
Specifies what types should be stored for the set of columns in data after transferring into HANA database.
If not specified for a column, the corresponding type will be inferred directly from the original type in R.
Defaults to NULL, i.e. stored types of all columns should be inferred.

...

Value

DataFrame
Returns a HANA Dataframe including data from the R data.frame.