How to fetch data from Hive Database to R Studio?

[sruthi]

Hi,
I am unable to fetch the data from Hive database.Facing the error.

[cderv]

Hi !

I would try to connect to hive like any other database, using odbc and Hive drivers. You already opened a post on this subject I think

HIVE connectivity to Rstudio?

Hi, I trying to connect HIVE to R studio to fetch the data from HIVE Instance. I am using R Studio version-3.4.2.Is there any possibility to connect?? Thanks.

Did you try ? https://db.rstudio.com/databases/hive/4 Advantage is that you could use dplyr after.

Otherwise, for this particular issue, a classpath problem is a jar not found I think. Hive may require too list all java dependencies individually. These dependencies should live in hadoop and hive installed dir on your environnement.
This SO answer may help :

Connectivity between R and Hive

Other option : You can use spark to deal with Hadoop data. Look at sparklyr You can use Hive functions from spark. You could also use dplyr with spark and even work within the cluster.

Hopes you'll find an answer or some hints in all this.

[MSK]

Hi
I too facing same error, at the same time above link is not working https://db.rstudio.com/databases/hive/4 612
Excepting your help

[cderv]

Don't know why but the link is wrong now. Things change !
The new one is : https://db.rstudio.com/databases/hive