Re: MutationState size is bigger than maximum allowed number of bytes

2018-09-19 Thread Jaanai Zhang
Are you configuring these on the server side? Your “UPSERT SELECT” grammar will be executed on the server side. Jaanai Zhang Best regards! Batyrshin Alexander <0x62...@gmail.com> 于2018年9月20日周四 上午7:48写道: > I've tried to copy one table to other vi

Re: Encountering IllegalStateException while querying Phoenix

2018-09-19 Thread Jaanai Zhang
Are you sure you had restarted RS process? you can check "phoenix-server.jar" whether exists in the classpath of HBase by "jinfo" command Jaanai Zhang Best regards! William Shen 于2018年9月20日周四 上午6:01写道: > For anyone else interested: we ended up i

MutationState size is bigger than maximum allowed number of bytes

2018-09-19 Thread Batyrshin Alexander
I've tried to copy one table to other via UPSERT SELECT construction and got this errors: Phoenix-4.14-hbase-1.4 0: jdbc:phoenix:> !autocommit on Autocommit status: true 0: jdbc:phoenix:> 0: jdbc:phoenix:> UPSERT INTO TABLE_V2 ("c", "id", "gt") . . . . . . . . > SELECT "c", "id", "gt" FROM TABLE

Re: IllegalStateException: Phoenix driver closed because server is shutting down

2018-09-19 Thread Batyrshin Alexander
Indeed. I see that this exception was thrown somewhere near docker restart time. Thank you for response. > On 20 Sep 2018, at 02:34, Sergey Soldatov wrote: > > That might be a misleading message. Actually, that means that JVM shutdown > has been triggered (so runtime has executed the shutdown

Re: IllegalStateException: Phoenix driver closed because server is shutting down

2018-09-19 Thread Sergey Soldatov
That might be a misleading message. Actually, that means that JVM shutdown has been triggered (so runtime has executed the shutdown hook for the driver and that's the only place where we set this message) and after that, another thread was trying to create a new connection. Thanks, Sergey On Wed,

Re: Encountering IllegalStateException while querying Phoenix

2018-09-19 Thread William Shen
For anyone else interested: we ended up identifying one of the RS actually failed to load the UngroupedAggregateRegionObserver because of a strange XML parsing issue that was not occurring prior to this incident and not happening on the any other RS. Failed to load coprocessor org.apache.phoenix.c

Encountering IllegalStateException while querying Phoenix

2018-09-19 Thread William Shen
Hi there, I have encountered the following exception while trying to query from Phoenix (was able to generate the exception doing a simple SELECT count(1)). I have verified (MD5) that each region server has the correct phoenix jars. Would appreciate any guidance on how to proceed further in troubl

Re: IllegalStateException: Phoenix driver closed because server is shutting down

2018-09-19 Thread Batyrshin Alexander
Version: Phoenix-4.14.0-HBase-1.4 Full trace is: java.lang.IllegalStateException: Phoenix driver closed because server is shutting down at org.apache.phoenix.jdbc.PhoenixDriver.throwDriverClosedException(PhoenixDriver.java:290) at org.apache.phoenix.jdbc.PhoenixDriver.checkClo

Re: IllegalStateException: Phoenix driver closed because server is shutting down

2018-09-19 Thread Josh Elser
What version of Phoenix are you using? Is this the full stack trace you see that touches Phoenix (or HBase) classes? On 9/19/18 12:42 PM, Batyrshin Alexander wrote: Is there any reason for this exception? Which exactly server is shutting down if we use quorum of zookepers? java.lang.IllegalSt

IllegalStateException: Phoenix driver closed because server is shutting down

2018-09-19 Thread Batyrshin Alexander
Is there any reason for this exception? Which exactly server is shutting down if we use quorum of zookepers? java.lang.IllegalStateException: Phoenix driver closed because server is shutting down at org.apache.phoenix.jdbc.PhoenixDriver.throwDriverClosedException(PhoenixDriver.java:290)

Re: Missing content in phoenix after writing from Spark

2018-09-19 Thread Saif Addin
Thanks. We topped with the next problem, we do need to do appending. But current support documentation says only Overwrite mode is available right? In this case we'll have to resort back to RDD writing, correct? On Mon, Sep 17, 2018 at 8:45 PM Josh Elser wrote: > As I said earlier, the expectati