revoscaler sqlServerdData rxImport uniqueidentifier column failed

Question

I'm trying to import data from SQL Server, but I'm having issues importing a table which consists of uniqueidentifier column type.

I'm using R Client 3.3.2.0 to query database.

Database table:

Code:

sqlConnString = "DRIVER=ODBC Driver 11 for SQL Server;SERVER=JDIMKO;DATABASE=Test;UID=sa;PWD=***;"

colClasses = c("id" = "integer", "ui" = "character")

sqlServerData <- RxSqlServerData(
    sqlQuery = "select * from tbl1",
    connectionString = sqlConnString, colClasses = colClasses)

custData = rxImport(sqlServerData)

Error:

Unhandled SQL data type!!! 
Unhandled SQL data type!!! 
Could not open data source.
Error in doTryCatch(return(expr), name, parentenv, handler) : 
  Could not open data source.

It looks like revoscaler utility is missing support for uniqueidentifier column type — Joan Dimko, Feb 13 '18 at 11:45
we can skip uniqueidentifier column by changing sqlQuery, as a workaround — Joan Dimko, Feb 13 '18 at 12:13

score 0 · Accepted Answer · answered Feb 13 '18 at 14:29

RxSqlServerData not supported UNIQUEIDENTIFIER data type. You should convert it to varchar.

sqlServerData <- RxSqlServerData(
    sqlQuery = "select id, CONVERT(VARCHAR(36), ui) ui from tbl1",
    connectionString = sqlConnString, colClasses = colClasses)

revoscaler sqlServerdData rxImport uniqueidentifier column failed

1 Answers1