[R] rhive with PAM

[Divakar Reddy]

Hi,


Can you help me on this?


Can we implement PAM authentication for rhive? If yes, Can you suggest me
if you have any documentation?


Is rhive going to use RODBC/JDBC connection to connect hiveserver2? or
requests directly going to namenode?



Here are my connection details:

library(RODBC)

library(RHive)

rhive.init(hiveHome="/usr/hdp/current/hive-client/",hadoopHome="/usr/hdp/current/hadoop-client")

rhive.connect(host="",port=1,defaultFS="hdfs://:8020",user="",password="**", hiveServer2=TRUE)


Thanks for your help.



Thanks,

Divakar

Phoenix, US

[[alternative HTML version deleted]]

__
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

[R] enabling PAM in R for RODBC connections

[Divakar Reddy]

Hi,

I'm trying to enable PAM authentication for RODBC connections in
Hadoop/hiveserver2.

I implemented required configurations in .ODBC.ini and it's working with
user ID but not working with user ID and Password.

Here are my configuration details in .odbc.ini

Description=Hortonworks Hive ODBC Driver (64-bit) DSN
Driver=/usr/lib/hive/lib/native/Linux-amd64-64/libhortonworkshiveodbc64.so
HOST=
PORT=1
Schema=default
HiveServerType=2
AuthMech=3
UID=test
PWD=***


Can you please suggest me where do I need make additional changes in-order
to work with User ID and Password.

Regards,
Divakar
Phoenix,US

[[alternative HTML version deleted]]

__
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Re: [R] R Package installation

[Divakar Reddy]

parallel is R's base package and it's already installed with base R.

 check in below location:
/usr/lib64/R/library/

Thanks,
Divakar

On Fri, Aug 12, 2016 at 3:53 AM, Dayalan, Nithya 
wrote:

> Hi Team,
>
> We are receiving the below message while updating the package. Please help.
>
> > install.packages("parallel", lib="D:/Program Files/R/R-3.2.5/library")
> Warning: unable to access index for repository https://cran.fhcrc.org/src/
> contrib:
>   cannot open URL 'https://cran.fhcrc.org/src/contrib/PACKAGES'
> Warning: unable to access index for repository
> http://www.stats.ox.ac.uk/pub/RWin/src/contrib:
>   cannot open URL 'http://www.stats.ox.ac.uk/pub/RWin/src/contrib/PACKAGES
> '
> Warning: unable to access index for repository https://cran.fhcrc.org/bin/
> windows/contrib/3.2:
>   cannot open URL 'https://cran.fhcrc.org/bin/windows/contrib/3.2/PACKAGES
> '
> Warning: unable to access index for repository
> http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/3.2:
>   cannot open URL 'http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/
> 3.2/PACKAGES'
> Warning messages:
> 1: package 'parallel' is not available (for R version 3.2.5)
> 2: package 'parallel' is a base package, and should not be updated
> >
>
>
> Thanks & Regards,
> Nithya Dayalan
> AMS MRL DPS | HCL @ Merck
> E-mail: nithya.daya...@merck.com
> Tel#+91 44 61053951| Mobile +91 8754232975
>
> Notice:  This e-mail message, together with any attachme...{{dropped:14}}
>
> __
> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/
> posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

[[alternative HTML version deleted]]

__
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

[R] help on moving data from local to HDFS using RODBC in R

[Divakar Reddy]

Hi,

I have requirement to move the data from Linux local path( ex
 /home/user/sample.txt) to hadoop HDFS using RODBC in R

I knew that we can move the data using rhive comamnds like *rhive.put*
and *rhive.get
*but looking for similar commands using RODBC as well.

I would appreciate for your inputs.

Regards,
Divakar
Phoenix, USA

[[alternative HTML version deleted]]

__
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Re: [R] Version 3.2.3: package not available error with https

[Divakar Reddy]

Hi,

I'm not sure about your OS but I fixed while installing below packages on
CentOS for RCurl

yum install curl
yum install curl-devel

Thanks,
Divakar

On Mon, Feb 29, 2016 at 6:32 AM, Loris Bennett 
wrote:

> Duncan Murdoch  writes:
>
> > On 29/02/2016 6:09 AM, Loris Bennett wrote:
> >> Hi,
> >>
> >> I recently installed version 3.2.3.  When I call
> >>
> >> install.packages("RCurl")
> >>
> >> I get a pop-up menu labelled "HTTPS CRAN Mirror" with a shortish list of
> >> mirrors.  However, I don't seem to be able to reach any of these
> >> mirrors, and always get an error like the following
> >>
> >> Error in download.file(url, destfile = f, quiet = TRUE) :
> >>unsupported URL scheme
> >> Warning: unable to access index for repository
> https://cran.uni-muenster.de/src/contrib:
> >>unsupported URL scheme
> >
> > That error message suggests the problem is in your build, e.g. possibly
> an out
> > of date or missing libcurl.  What does capabilities("libcurl") say?
>
> FALSE
>
> It seems that R needs libcurl 7.28.0, but my platform (Scientific Linux
> 6.7) only provides version 7.19.7.
>
> Thanks for the pointer.
>
> Loris
>
> > Duncan Murdoch
> >
> >
> >> Warning message:
> >> package ‘RCurl’ is not available (for R version 3.2.3)
> >>
> >> If I choose the menu entry "(HTTP mirrors)" I get the list of HTTP
> >> mirrors with which I am familiar from previous versions of R.  These
> >> mirrors I can reach.
> >>
> >> I assume I have some local, probably firewall-related problem, but can
> >> someone confirm that the HTTPS mirrors do indeed work?
> >>
> >> Cheers,
> >>
> >> Loris
> >>
>
> --
> Dr. Loris Bennett (Mr.)
> ZEDAT, Freie Universität Berlin Email loris.benn...@fu-berlin.de
>
> __
> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

[[alternative HTML version deleted]]

__
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

[R] sqldf --Warning message:

[Divakar Reddy]

Dear R users,

I'm getting Waring message while trying to load "sqldf" package in R3.2.3
and assuming that we can ignore this as it's WARNING Message and not an
error message.
Can you guide me if my assumption is wrong?


> library(sqldf);
Loading required package: gsubfn
Loading required package: proto
Loading required package: RSQLite
Loading required package: DBI
Warning message:
no DISPLAY variable so Tk is not available

> version   _
platform   x86_64-redhat-linux-gnu
version.string R version 3.2.3 (2015-12-10)
>

Thanks,
Divakar
Phoenix,USA

[[alternative HTML version deleted]]

__
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

[R] 'tcltk' in R2.3.3

[Divakar Reddy]

Dear R users,

I would to install 'tcltk' in R2.3.3 but getting below error when I tried
to install.
Can you please suggest me?


> install.packages("tcltk", repos = "http://cran.cnr.Berkeley.edu/;);
Installing package into ‘/usr/lib64/R/library’
(as ‘lib’ is unspecified)
Warning message:
package ‘tcltk’ is not available (for R version 3.2.3)
> capabilities("tcltk")
tcltk
 TRUE
>


Thanks,
Divakar
Phoenix,USA

[[alternative HTML version deleted]]

__
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Re: [R] package ‘xlsx’ is not available (for R version 3.2.3)

[Divakar Reddy]

I installed 'xlsx' using below repo and din't see any issues.
install.packages("xlsx", repos = "http://cran.cnr.Berkeley.edu/;)

> version
   _
platform   x86_64-redhat-linux-gnu
arch   x86_64
os linux-gnu
system x86_64, linux-gnu
status
major  3
minor  2.3
year   2015
month  12
day10
svn rev69752
language   R
version.string R version 3.2.3 (2015-12-10)
nickname   Wooden Christmas-Tree

> packageVersion("xlsx")
[1] ‘0.5.7’
>

Thanks,
Divakar


On Sat, Feb 13, 2016 at 10:42 AM, papa legba  wrote:

> Hi,
> Does anyone have any idea how to work around this ?
> package ‘xlsx’ is not available (for R version 3.2.3)
>
> To make xlsx work for 3.2.3 ?
>
> Thanks
>
> [[alternative HTML version deleted]]
>
> __
> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.

[[alternative HTML version deleted]]

__
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

[R] help on Rprofile.site

[Divakar Reddy]

Hi All,


Issue:
we are running issues with RStudio like crash and packages not found.

Root Cause:
Sharing a home directory between two servers( we installed RStudio on two
servers and both are sharing same home directory).

Our Solution:
Create separate home directories on both RStudio servers and ensure that
both are not sharing same profile files like .rstudio/Rhistory
Current Home directories location: /home/user/
Proposed Home directory: /home/user/Ser1 & /home/user/Ser17 for both servers

In-order to achieve this I'm trying to set new home directory on both
servers to store .rstudio files separately.

[abc@xyz etc]$ pwd
/usr/lib64/R/etc
[abc@xyz etc]$ cat Rprofile.site
.First <- function() cat("n Welcome to R!nn")
# get the System USER variable and set it to the R variable u
u <- Sys.getenv("USER")
# use file.path() to set the file path using the USER variable
u.path <- file.path("/home", u, "Ser17")
# change the working directory to the set file path
#setwd(u.path)
.Last <- function() cat("n Goodbye!nn")

Here I don't want to change the Working directory and looking to change
only home directory to store profile files which are used while starting R.

Could you please suggest me on this?

Thanks,
Divakar
Hadoop Administrator,
Phoenix,USA

[[alternative HTML version deleted]]

__
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.