I'm trying to write/create a table with column types specified by the field.types argument in HANA database. For some reason this isn't working, and by default it's creating all my fields as varchar(255), which is too short. I want it to assume as BLOB and integer for 2 columns(mycol1 & mycol2). And also, how can I set the default data type for remaining columns.
dbWriteTable(con$getConnection()$getConnection(), '\"a\".\"b::c\"', df, field.types = c(mycol1 = 'blob', mycol2='integer'), row.names = FALSE, overwrite=TRUE)
Looking for help!!!
Thanks in advance!!!