使用许多特殊字符将R连接到HANA数据库的问题 [英] Issues connecting R to HANA db with many special characters

问题描述

我在将HANA数据读入R时遇到问题.

I am having issues with reading HANA data into R.

我已通过

ch <- odbcConnect("HANA",uid="USER",pwd="PW")

并确认我通过

sqlTables(ch)

将拉出我的表列表.

在我要提取的所需表上进行过滤后，全名显示为"ccf-edw.self-service.MDM :: Q_CA_R_CUSTOMER_REPORTS"

Filtering on my desired table I am trying to pull reveals the full name to be "ccf-edw.self-service.MDM::Q_CA_R_CUSTOMER_REPORTS"

从我所看到的其他帖子中，这些期间似乎存在问题.

From other posts I have seen, there appear to be issues surrounding the periods.

尝试

sqlQuery(ch, 'SELECT TOP 10 FROM "_SYS_BIC"."ccf-edw"."self-service"."MDM::Q_CA_R_CUSTOMER_REPORTS"')

返回错误

[1] "42000 257 [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 sql syntax error: incorrect syntax near \"FROM\": line 1 col 15 (at pos 15)"
[2] "[RODBC] ERROR: Could not SQLExecDirect 'SELECT TOP 10 FROM \"_SYS_BIC\".\"ccf-edw\".\"self-service\".\"MDM::Q_CA_R_CUSTOMER_REPORTS\"'" 

我不确定在何处加上其他双引号.

I am unsure exactly where to stick additional double quotes.

推荐答案

您可以尝试以下方法吗?

Can you try this instead:

sqlQuery(ch, 'SELECT TOP 10 FROM "_SYS_BIC"."ccf-edw.self-service.MDM::Q_CA_R_CUSTOMER_REPORTS"')

这篇关于使用许多特殊字符将R连接到HANA数据库的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！