Question

是否有任何人成功地将ODBC用于视听台,在MACOS Ventura(13.4)和M1 chip上使用/配置了数据碎片社区版本?

这里有与数据记录社区版本的链接:。

我在此下载了MACOS驱动力:>>>>><<<<<<<>>>>>>>>>>>>><<<<>>>>>>>>>><<<<>a>

Rstudio/Posit似乎表明,我们需要使用我在这里谈到的unixODBC;link。我尝试用土机安装“无电离层”设备,但遇到了路上的问题,并决定手工下载。

我试图根据这些参数对司机/司机进行conf;link。此外,我还包括了UID和PWD的钥匙:价值,因为社区版本不允许创建个人标志。

Rstudio repeatedly provides Error: nanodbc/nanodbc.cpp:1118: 00000: [unixODBC][Driver Manager]Data source name not found and no default driver specified

当我去找新的联系时,我只见Sea and Livy,而没有Simbapit Odbc司机。 I used unixODBC from home-brew with ODBCSYSINI=/opt/homebrew/et 链接,我至少可以看到Simba/61/6 Odbc司机在从Rstudio链接表的新链接窗口上。

我知道,我在此没有提供很多细节(即,改观),但试图了解如何使用/测试带有数据碎片的视听台,使其大于RAM数据集。在当地测试,看看能否在我的办公室环境中推广。与这些ODBC司机合作对我来说是新的。感谢你提供民间能够提供的任何资源/工具/帮助。

Answer 1

在你所分享的联系中,数据盘刚刚释放了一个新的ARM64-compatabile ODBC司机。一个主要问题是缺乏ARM的汇编,与RStudio和R资料袋一起寻找这套材料。我采取的粗略步骤是:

Install ODBC manager: brew install unixodbc
Check to ensure installation and paths for .ini files with odbcinst -j
Install the latest version of the Databricks ODBC driver. By default, it will be installed at the path /Library/simba/spark
Copy and paste the following command in your CLI:

echo "
" >> /opt/homebrew/etc/odbcinst.ini
echo "[databricks_spark_sql]" >> /opt/homebrew/etc/odbcinst.ini
echo "Driver=/Library/simba/spark/lib/libsparkodbc_sb64-universal.dylib" >> /opt/homebrew/etc/odbcinst.ini
echo "ODBCInstLib=/opt/homebrew/opt/unixodbc/lib/libodbcinst.2.dylib" >> /Library/simba/spark/lib/simba.sparkodbc.ini

这些指挥部在<代码>unixODBC司机主管使用的“联接组合文档”上添加了<代码>数据碎片。该系统还提供<条码>unixODBC公共事业,可在<条码>上查询。一旦完成,关闭了您的终点站并开放了RStudio。

Add an entry to your .Rprofile that sets an environment variable that tells R where to look for odbc s configuration files. This is where the odbcinst.ini file is stored. From within a project in RStudio, you can do this by opening your .Rprofile with the following command:

usethis::edit_r_profile(scope =  project )

然后,在......。引人注意:

Sys.setenv(ODBCSYSINI= /opt/homebrew/etc )

Restart your R Session and check that the new ODBC driver is recognized/being listed correctly:

odbc::odbcListDrivers()

通过利用文件将数据盘连接到ODBC。从<条码>dbplyr,它可研究类似情况:

db_odbc <- DBI::dbConnect(
    drv = odbc::odbc(),
    driver          =  databricks_spark_sql ,
    server          =  adb-[...].azuredatabricks.net ,
    host            =  adb-[...].azuredatabricks.net ,
    port            = 443,
    httppath        =  /sql/1.0/warehouses/01d71fe07e891bb6 ,
    catalog         =  ... ,
    schema          =  ... ,
    thrifttransport = 2,
    ssl             = 1,
    authmech        = 3,
    uid             =  token ,
    pwd             = keyring::key_get(service =  simba_connector_token )
)

Answer 2

Thank you for sharing. I tried this but i keep getting the error below: Error: nanodbc/nanodbc.cpp:1138: 00000 [Simba][ODBC] (11560) Unable to locate SQLGetPrivateProfileString function: [Simba][Support] (50483) Could not load shared library, all attempted paths (, "/opt/homebrew/opt/unixodbc/lib/libodbcinst.2.dylib") failed

我想知道是否有任何人知道如何解决这一问题? 成就

友情链接