Re: JOIN returning incomplete result

2016-05-12 Thread pierre lacave
> Hi Pierre, > > Thank you very much for reporting this issue! Can you create a JIRA with > all the information you've attached above along with the table DDL info? > I'll take a look at it. > > > Thanks, > Maryann > > On Thu, May 12, 2016 at 6:18 AM, pierre lacave &l

JOIN returning incomplete result

2016-05-12 Thread pierre lacave
Hi I am seeing weird result with joins where the output seems to be incomplete I tried to summarise the problem with the queries bellow. in query 1, I do a join over a period for which I would have expected to return a dozen of rows, but only one is returned for a time T1, in query 2, I do the

Re: Spark Phoenix Plugin

2016-02-08 Thread pierre lacave
atanode151.pdc1i.gradientx.com): > java.lang.IllegalStateException: unread block data > > It happens when I do: > > df.show() > > Getting closer… > > Thanks, > Ben > > > > On Feb 8, 2016, at 2:57 PM, pierre lacave <pie...@lacave.me> wrote: > >

Re: Spark Phoenix Plugin

2016-02-08 Thread pierre lacave
gt; >> The version of HBase is the one in CDH5.4.8, which is 1.0.0-cdh5.4.8. >> >> When I get to the line: >> >> val df = sqlContext.load("org.apache.phoenix.spark", Map("table" -> >> “TEST.MY_TEST", "zkUrl" -> “zk1,zk2,z

Re: Spark Phoenix Plugin

2016-02-05 Thread pierre lacave
This was addressed in Phoenix 4.7 (currently in RC) https://issues.apache.org/jira/browse/PHOENIX-2503 *Pierre Lacave* 171 Skellig House, Custom House, Lower Mayor street, Dublin 1, Ireland Phone : +353879128708 On Fri, Feb 5, 2016 at 6:17 PM, Benjamin Kim <bbuil...@gmail.com>

Re: Spark Phoenix Plugin

2016-02-05 Thread pierre lacave
I don't know when the full release will be, RC1 just got pulled out, and expecting RC2 soon you can find them here https://dist.apache.org/repos/dist/dev/phoenix/ there is a new phoenix-4.7.0-HBase-1.1-client-spark.jar that is all you need to have in spark classpath *Pierre Lacave* 171

Re: Configure Hbase Client when using Phoenix Datasource in Spark?

2016-01-24 Thread pierre lacave
case I cannot anticipate apart from parsing a SQL query. *Pierre Lacave* 171 Skellig House, Custom House, Lower Mayor street, Dublin 1, Ireland Phone : +353879128708 On Sun, Jan 24, 2016 at 6:14 PM, Josh Mahonin <jmaho...@gmail.com> wrote: > Hi Pierre, > > You have a few

Configure Hbase Client when using Phoenix Datasource in Spark?

2016-01-23 Thread pierre lacave
00 hbase.rpc.timeout 120 phoenix.query.keepAliveMs 24 Thanks *Pierre Lacave*

Re: Row timestamp support in 4.6

2015-12-04 Thread pierre lacave
Thanks Samarth, It does work with BIGINT, which is fine for my use case. I raised https://issues.apache.org/jira/browse/PHOENIX-2493 for the UNSIGNED_LONG issue *Pierre Lacave* 171 Skellig House, Custom House, Lower Mayor street, Dublin 1, Ireland Phone : +353879128708 On Fri, Dec 4