Querying Hive from R via SparkR

Hello everyone, We are running a Hive Cluster in a Kerberos environment, that we usually access via ssh from our local machines on windows. I would like to be able to query Hive directly from R on those same windows machines by using the SparkR p

RE: HIVE CLI does not escape \t ?

ve.apache.org Cc : Thomas Achache Objet : Re: HIVE CLI does not escape \t ? > I¹m exporting a table with Hive CLI using hive ­f query.hql > file.tsv > Use ^A as a separator ... > Maybe using an alternative SerDe could solve that? Have you tried using the actual SerDe instead of t

HIVE CLI does not escape \t ?

Hi all, I’m exporting a table with Hive CLI using hive –f query.hql > file.tsv. The resulting tab separated file won’t read in R because it seems that some of my fields contain the \t separator and that Hive CLI is neither escaping those characters nor putting the chr fields within quotes. The

Loop if table is not empty

Hi everyone, I am running a series of queries in a file named rgm.hql. At the end of the execution, if a specific table is not empty, I'd like to run rgm.hql all over again (and again if it the table is not empty). By design it won't be an infinite loop because the table will be empty eventuall