Re: Phoenix on Amazon EMR

2014-09-08 Thread Tulasi Paradarami
Yes, a blog post will be of great help especially considering its not clear when Amazon will upgrade their default version to 3.x or 4.x On Sep 8, 2014, at 9:07 PM, James Taylor jamestay...@apache.org wrote: Thanks, Puneet. That's super helpful. Was (2) difficult to do? That might make an

Re: add a snapshotted phoenix table

2015-03-11 Thread Tulasi Paradarami
How big is the table? I think, its taking so long to create the table because phoenix creates a new column _0 for each row with null values. So, when it failed the upserts were only partially complete but table is available for querying. Since, view doesnt perform this upsert, its faster to create

Timeline consistency using PQS

2017-01-19 Thread Tulasi Paradarami
Hi, Does PQS support HBase's timeline consistency (HBASE-10070)? Looking at the connection properties implementation within Avatica, I see that following are defined: ["transactionIsolation", "schema", "readOnly", "dirty", "autoCommit", "catalog"] but there's isn't a property defined for setting

Re: Timeline consistency using PQS

2017-01-19 Thread Tulasi Paradarami
LT_CONSISTENCY_LEVEL)); On Thu, Jan 19, 2017 at 2:35 PM, Tulasi Paradarami < tulasi.krishn...@gmail.com> wrote: > Hi, > > Does PQS support HBase's timeline consistency (HBASE-10070)? > > Looking at the connection properties implementation within Avatica, I see > that following a

Re: ArrayIndexOutOfBoundsException in PQS

2017-01-05 Thread Tulasi Paradarami
gt; closeStatement call (either from multiple callers) or the automatic-closing > logic inside of PQS itself (by default, PQS will close statements that > haven't been used for 10mins, IIRC). > > Any more information on the context in which you see this would be very > helpful. > > Tu

Re: ArrayIndexOutOfBoundsException in PQS

2017-01-05 Thread Tulasi Paradarami
avatica.connectioncache.expiryunit avatica.statementcache.concurrency avatica.statementcache.initialcapacity avatica.statementcache.maxcapacity avatica.statementcache.expiryduration avatica.statementcache.expiryunit On Thu, Jan 5, 2017 at 10:04 AM, Tulasi Paradarami < tulasi.krishn...@gmail.com>

Re: ArrayIndexOutOfBoundsException in PQS

2017-01-05 Thread Tulasi Paradarami
t; you want to do). > > You can try setting org.apache.calcite.avatica.jdbc.JdbcMeta=DEBUG in the > $PHOENIX_HOME/bin/log4j.properties file. That will print some messages > when a statement or connection is automatically evicted from the respective > cache. > > Finally, no st

Re: ArrayIndexOutOfBoundsException in PQS

2017-01-05 Thread Tulasi Paradarami
tatement, both trying to close the ResultSet. > > This is sounding more and more like an Avatica bug to me. Any chance you > can share more of the TRACE logging that you've turned on and maybe open up > a JIRA issue under the CALCITE project (and ping me), please? > > I real

ArrayIndexOutOfBoundsException in PQS

2017-01-04 Thread Tulasi Paradarami
We noticed that PQS started raising ArrayIndexOutOfBoundsException in our production cluster. This exception is raised sporadically and goes away when PQS is restarted. Does anyone know what might be causing this exception? Are there any configuration (PQS and/or Avatica) parameters that we can

Null array elements with joins

2018-06-19 Thread Tulasi Paradarami
Hi, I'm running few tests against Phoenix array and running into this bug where array elements return null values when a join is involved. Is this a known issue/limitation of arrays? create table array_test_1 (id integer not null primary key, arr tinyint[5]); upsert into array_test_1 values

Re: Null array elements with joins

2018-06-27 Thread Tulasi Paradarami
e initialized in KeyValyColumnExpression for ARRAY elements during tuple projection. That is, when projecting array elements, it should perhaps be initialized with "_v, ", instead of "default cf, actual column qualifier"? It'll be helpful to hear from the Phoenix experts on thi

Re: Null array elements with joins

2018-06-20 Thread Tulasi Paradarami
Tested on 4.7, 4.11 & 4.14. https://issues.apache.org/jira/browse/PHOENIX-4791 On Tue, Jun 19, 2018 at 8:10 PM Jaanai Zhang wrote: > what's your Phoenix's version? > > > >Yun Zhang >Best regards! > > > 2018-06-20 1