How to fetch data from Hive Database to R Studio?

rstudio
#1

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

1 Like

#2

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

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 :

Other option : You can use spark to deal with Hadoop data. Look at sparklyr :package: 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.

1 Like

#3

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

0 Likes

#4

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

0 Likes

closed #5

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.

0 Likes