Re: TableNotFoundException, tableName=SYSTEM.CATALOG with phoenix-spark

When you choose to include Phoenix in the EMR deployment it puts Amazon's build of all the jars and bin scripts under /usr/lib/phoenix/ Using sqlline, psql, etc on the EMR master server work fine. But, the Spark cluster I'm trying to connect to HBase from is not part of that EMR deployment. It is

Re: Problems with Phoenix bulk loader when using row_timestamp feature

0: jdbc:phoenix:localhost:2181> explain select count(*) from historian.data; +--+ | PLAN | +--+ | CLIENT 1-CHUNK PARALLEL 1-WAY FULL SCAN OVER HISTORIAN.DATA | | ROW TIMESTAM

Re: TableNotFoundException, tableName=SYSTEM.CATALOG with phoenix-spark

Hi Nathan, That could very well be the issue, I suspect they're running a local fork if it's on top of HBase 1.2. I'm not familiar with the EMR environment, when you use sqlline.py is it using their own Phoenix JARs or your own? If it's theirs, perhaps the phoenix-client-spark JAR might be availa

Re: Delete large data set

Thanks James, this helps On 9 Aug 2016 22:58, "James Taylor" wrote: > Make sure to set autoCommit on before issuing the DELETE. Otherwise the > client needs to hold onto all the row keys of the rows being deleted. > > On Tuesday, August 9, 2016, Sanooj Padmakumar wrote: > >> Hi All, >> >> What

RE: Java Query timeout

Increasing scanner timeout period with the below properties helped, thanks for your help. From: Ankit Singhal [mailto:ankitsingha...@gmail.com] Sent: Tuesday, August 09, 2016 3:29 To: user@phoenix.apache.org Subject: Re: Java Query timeout bq. 1) From the exceptions, it looks like timeout is set

Re: phoenix 4.7.0 on EMR 5

Hi Kim, Probably best to ask the EMR folks. That's not something we have. Thanks, James On Wed, Aug 10, 2016 at 4:36 AM, Dong-iL, Kim wrote: > Hi. > I use phoenix on amazon EMR 5. > but there is no repository of version 4.7.0-HBase-1.2. > how can I build my application with maven? > thanks. >

Re: TableNotFoundException, tableName=SYSTEM.CATALOG with phoenix-spark

Thanks Josh, I tried that out (adding just the phoenix-client-spark jar to CP) and got the same error result. I wonder if the issue is that I'm running on EMR 5 with HBase 1.2. The jars I'm using are copied over from the HBase master because there is no 4.7.0-HBase-1.2 set in MVN. Is the phoenix-s

phoenix 4.7.0 on EMR 5

Hi. I use phoenix on amazon EMR 5. but there is no repository of version 4.7.0-HBase-1.2. how can I build my application with maven? thanks.