连接R和Impala [英] Connect R and Impala

问题描述

我当然知道可复制的示例和一段代码，但是对于这个问题，我必须(否则不能)模糊.

I know of course about reproducible example and piece of code but for this question I have to be (I can't be otherwise) obscure.

我正在尝试连接R和 Impala .抛开这些问题(正式"来说，我无法在此PC上安装软件...但是我已经使用了R和RStudio的便携式版本)

I am trying to connect R and Impala. Putting aside the problems ("officially", I cannot install software on this PC... but I have used portable versions of R and RStudio)

我已经尝试过 RImpala 包.

rimpala.connect(IP = myip,
              port = the port where Impala sees,
              principal = maybe this is not clear)

我很确定问题的原因是principal参数，文档对我来说也不是很清楚.无论如何，我已经尝试过将文档说应该放在这里的内容的几种组合.

I am pretty sure that the causes of my problems is the principal argument, the documentation is not clear to me. Anyway, I've tried several combinations of what the documentations says it should be placed there.

无论如何我都会遇到相同的错误:

In any case I get the same error:

.jcall("RJavaTools"，"Ljava/lang/Object;"，"invokeMethod"，cl，中的错误: java.lang.IllegalArgumentException:Kerberos主体应包含3个部分:10.60.10.22:8888/impala/@tempuser

Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.lang.IllegalArgumentException: Kerberos principal should have 3 parts: 10.60.10.22:8888/impala/@tempuser

我在网上搜索了此错误，它似乎与某些Java问题有关，但是我对该语言的了解为零.

I've searched online for this error and it seems to be related to some java things, but I have zero knowledge of that language.

了解我无权访问我的PC(例如，我无法安装任何软件或做仅管理员可以做的事情)可能会很有用.

It can be useful to know that I have no access to my PC, say, I cannot install any software or do a thing that only an administrator can do.

我知道问题写得不好，但是正如我这次说的那样，不可能复制一个例子.

I know the question is not well written but as I've said for this time a reproducible example is impossible.

现在我正在考虑这个问题，我在IP参数中填充了在浏览器的导航栏中看到的地址以连接到Hue.我猜是一样的，但是也许我在这一点上也做错了，因为我已经说过，我很确定错误不是由于这个原因造成的.

Now that I am thinking about it, I filled the IP argument with the address I saw in the navigation bar of my browser to connect to Hue. I guessed it was the same but maybe I did wrong on this point too anyway as I've said I am pretty sure the error is not due to that.

推荐答案

R包 implyr (在 CRAN 和 GitHub )提供了 dplyr 后端"，使用ODBC或JDBC驱动程序进行连接.有关说明，请参见自述文件.

The R package implyr (on CRAN and GitHub) provides a dplyr backend for Impala, using either the ODBC or JDBC driver to connect. See the README for instructions.

这篇关于连接R和Impala的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！