Re: AbstractMethodError

Hi Thomas, You are right. Somehow, the packaged libs were of 1.1 Hbase. Thanks for testing this out,Sumit From: Thomas D'Silva To: user@phoenix.apache.org; Sumit Nigam Sent: Tuesday, September 22, 2015 3:38 AM Subject: Re: AbstractMethodError Sumit, I tested out HBase 0.98.6 and th

default values in CREATE statements

I'm wondering about support for DEFAULT statements in Phoenix when you specify column types. I noticed that there's a ticket for it: https://issues.apache.org/jira/browse/PHOENIX-476 Did this ever go anywhere? The suggestion at the end for supporting DEFAULT NEXT VALUE FOR would also be a h

Re: Is there a Pentaho connector for Phoenix

Hi James Thank you! I have also found now a way to connect Pentaho PDI (aka Kettle) to Phoenix. I used steps from this blog http://talat.uyarer.com/post/121179803796/how-to-connect-hbase-using-apache-phoenix-from It works with generic Phoenix drivers, the use case is to create an ETL transformat

REG: Query not working correctly

Hi Team, I have a column with unsigned_int as the data type. when i try to use not in clause with limit, it is not working. The outer query is fetching the records that satisfy the query in not in condition. Can any one suggest if this is bug? I am using cloudera and Phoenix 4.5.1 version. When

Re: REG: Query not working correctly

Hi Satya, It sounds like a bug from your description, but we'll need more information to fix it. How about a standalone test where you anonymize the column names? Thanks, James On Tuesday, September 22, 2015, Ns G wrote: > Hi Team, > > I have a column with unsigned_int as the data type. > when i

Re: Is there a Pentaho connector for Phoenix

The phoenix drivers do let *Pentaho to connect to Phoenix via a Generic Database pure JDBC* connection as described in http://talat.uyarer.com/post/121179803796/how-to-connect-hbase-using-apache-phoenix-from I can see mappings, fields from both sides, source and target! But I can't do an UPSERT i

Number of regions in SYSTEM.SEQUENCE

Hi By default SYSTEM.SEQUENCE is installed with 256 regions. In an environment where you don’t have a large number of tables and regions (yet), the end result of this seems to be that with hbase balance_switch=true, you end up with a lot of region servers with nothing but empty SYSTEM.SEQUENCE

Re: Number of regions in SYSTEM.SEQUENCE

Since Phoenix 4.5.x default has been changed for phoenix.sequence.saltBuckets to not split sequence table. See this

Re: Number of regions in SYSTEM.SEQUENCE

Mujtaba Thanks for this information. Seeing as I am using Phoenix 4.2, what is the safe and approved sequence of steps to drop this table and recreate it as you mention? Additionally, how do we ensure we don’t lose sequence data? Michael McAllister Staff Data Warehouse Engineer | Decision Syste

Re: Number of regions in SYSTEM.SEQUENCE

If no one else will be hitting the table while you complete the operation, and if you don't mind about missing a few sequence values (i.e., having a gap), you should just need the following. SELECT NEXT VALUE FOR sequencename FROM sometable; That will tell you the next value the sequence w

Re: Number of regions in SYSTEM.SEQUENCE

OK - so the traditional methods of recreating sequences, that makes sense. Interestingly btw, at least from within Phoenix I can’t see the content of SYSTEM.SEQUENCE. I get the following error:- 0: jdbc:phoenix:redacted,> select count(*) from system.sequence; Error: ERROR 604 (42P00): Syntax err

Re: Number of regions in SYSTEM.SEQUENCE

I don't think it's trying to stop you looking inside the table. I think it's complaining that SEQUENCE is a keyword, and shouldn't be appearing there. You could try quoting it. James On 22/09/15 21:11, Michael McAllister wrote: OK - so the traditional methods of recreating sequences, that mak

Re: Number of regions in SYSTEM.SEQUENCE

More failed attempts ... 0: jdbc:phoenix:redacted,> select count(*) from system."sequence"; Error: ERROR 1012 (42M03): Table undefined. tableName=SYSTEM.sequence (state=42M03,code=1012) 0: jdbc:phoenix:redacted,> select count(*) from "system.sequence"; Error: ERROR 1012 (42M03): Table undefined.

Re: Number of regions in SYSTEM.SEQUENCE

Try the one you missed: SYSTEM."SEQUENCE" i.e., quote the bits separately (but SYSTEM doesn't need quoting), and put it in caps. James On 22/09/15 21:18, Michael McAllister wrote: More failed attempts ... 0: jdbc:phoenix:redacted,> select count(*) from system."sequence"; Error: ERROR 1

Re: Number of regions in SYSTEM.SEQUENCE

Thanks, that one worked :-) On Sep 22, 2015, at 3:28 PM, James Heather mailto:james.heat...@mendeley.com>> wrote: Try the one you missed: SYSTEM."SEQUENCE" i.e., quote the bits separately (but SYSTEM doesn't need quoting), and put it in caps. James On 22/09/15 21:18, Michael McAllister

Spark Plugin Exception - java.lang.ClassCastException: org.apache.spark.sql.catalyst.expressions.GenericMutableRow cannot be cast to org.apache.spark.sql.Row

Hi, I am trying to run the spark plugin DataFrame sample code available here ( https://phoenix.apache.org/phoenix_spark.html) and getting following exception. I am running the code against hbase-1.1.1, spark 1.5.0 and phoenix 4.5.2. HBase is running in standalone mode, locally on OS X. Any idea

Re: default values in CREATE statements

Hi James, We've gotten as far as figuring *how* to do it, but the implementation hasn't been done. I'd be happy to provide guidance if someone would like to volunteer to pursue it. Thanks, James On Tue, Sep 22, 2015 at 3:37 AM, James Heather wrote: > I'm wondering about support for DEFAULT state

Re: Using Phoenix from Python or Go

Hi Bipin, Take a look at this thread for a way to use Python to talk to Phoenix: http://search-hadoop.com/m/9UY0h2bzSGk2gyXOb/Python&subj=Python+client+for+the+query+server Thanks, James On Mon, Sep 21, 2015 at 8:58 PM, Bipin Nag wrote: > Hi everyone, > > Can Phoenix be used from language that