[R-sig-DB] Using RJDBC with HBASE 98.1 with Phoenix-4.1 JDBC driver

[Jon Beach]

Hi

I am trying to connect to HBASE (HADOOP 2.3) with Phoenix 4.1 JDBC Driver
from R 3.1.1 via RJDBC using the following code:

Has anyone tried this and been successful?

> library(rJava)
> library(RJDBC)
Loading required package: DBI
> drv <-
JDBC("org.apache.phoenix.jdbc.PhoenixDriver","~/phoenix-4.1.0-bin/hadoop2/phoenix-4.1.0-client-hadoop2.jar",identifier.quote="'")
> conn <-dbConnect(drv,"jdbc:phoenix:hdmaster:2181")
log4j:WARN No appenders could be found for logger
(org.apache.hadoop.conf.Configuration.deprecation).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for
more info.
> dbListTables(conn)
[1] "CATALOG"             "SEQUENCE"            "PERFORMANCE_1000000"
[4] "STOCK_SYMBOL"
> dbGetQuery(conn,"select * from STOCK_SYMBOL")
Error in .jcall(rp, "I", "fetch", stride) :
  java.sql.SQLFeatureNotSupportedException

rJava, DBI and RJDBC are all the latest versions and I am using Java 1.8
from Oracle on Ubuntu 12.04

Thanks

Jon

	[[alternative HTML version deleted]]