OHDSI Home | Forums | Wiki | Github

DatabaseConnector query error

Developers
#1

Hi team,
I wanted to use databaseconnector to pull data. Below are two scripts I tried and both generated an error message. But the same script ran well during the past days. Can anyone help me fix it? thanks!
conn ← DatabaseConnector::connect(connectionDetails)
dbGetQuery(conn, “select * FROM xxx LIMIT 4”)
querySql(conn,“select * FROM xxxt LIMIT 4”)

Error in .createErrorReport():
! Error executing SQL:
java.sql.SQLException: [Databricks]DatabricksJDBCDriver Error caught in BackgroundFetcher. Foreground thread ID: 1. Background thread ID: 35. Error caught: Could not initialize class com.databricks.client.jdbc42.internal.apache.arrow.memory.util.MemoryUtil.

#2

The dbGetQuery() function will automatically use SqlRender to translate OHDSISql to whatever the SQL dialect is of your database platform. There is no LIMIT command in OHDSISql. Instead, please use SELECT TOP 4 * FROM xxx;. Or else use translate = FALSE when calling dbGetQuery().

t