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: Java Query timeout

Thanks Brian. I have added HBASE_CONF_DIR and it’s still timing out. Any help? From: Brian Jeltema [mailto:bdjelt...@gmail.com] Sent: Thursday, August 04, 2016 15:08 To: user@phoenix.apache.org Subject: Re: Java Query timeout Regarding your second question, try export HBASE_CONF_DIR= before

RE: Java Query timeout

Any pointers? From: Ramanathan, Kannan: R&A (NYK) Sent: Wednesday, August 03, 2016 15:08 To: user@phoenix.apache.org Subject: RE: Java Query timeout Can someone please take a look? From: Ramanathan, Kannan: IT (NYK) Sent: Tuesday, August 02, 2016 15:59 To: user@phoenix.apache.org

RE: Java Query timeout

Can someone please take a look? From: Ramanathan, Kannan: IT (NYK) Sent: Tuesday, August 02, 2016 15:59 To: user@phoenix.apache.org Subject: Java Query timeout Hello All, We're using Phoenix 4.7 with CDH 5.7.1. The query from Java client is timing out with this error: Caused by: java.net.Socke

Java Query timeout

Hello All, We're using Phoenix 4.7 with CDH 5.7.1. The query from Java client is timing out with this error: Caused by: java.net.SocketTimeoutException: callTimeout=6, callDuration=60306: row '' on table 'PHOENIX_TABLE' at region= PHOENIX_TABLE,,1462867135721.5bc05e2b5485f3fd550e9f93a795a1

RE: Flashback queries support in select statement

Any help? From: Ramanathan, Kannan: IT (NYK) Sent: Wednesday, April 13, 2016 15:19 To: user@phoenix.apache.org Subject: Flashback queries support in select statement Hi, Is flashback query (queries to look at the state of a record in the past) supported in select statement? I understand it can

Flashback queries support in select statement

Hi, Is flashback query (queries to look at the state of a record in the past) supported in select statement? I understand it can be done during JDBC connection creation. I am checking something like this is available: select 'as-of:2016-04-13' * from TABLE; Also, is there any maximum limit on

RE: Multiple versions for single row key

Thanks Thomas. Do we have rough estimate of when PHOENIX-590 will be done? -Original Message- From: Thomas D'Silva [mailto:tdsi...@salesforce.com] Sent: Monday, February 22, 2016 14:59 To: user@phoenix.apache.org Subject: Re: Multiple versions for single row key You need to set the versi

RE: Multiple versions for single row key

Hi James, I don’t quite get it to work or I didn’t understand how it’s supposed to work. I have created a simple table to test this. Create table statement with support for 5 versions: create table MULTI_ROW_KEYS (ID VARCHAR PRIMARY KEY, PRICE DOUBLE) VERSIONS=5 Sample java code snippet to get

RE: Multiple versions for single row key

Thanks a lot James, I’ll try this. From: James Taylor [mailto:jamestay...@apache.org] Sent: Thursday, February 11, 2016 12:43 To: user@phoenix.apache.org Subject: Re: Multiple versions for single row key Hi Kannan, Yes, you can keep 3 versions of a cell in Phoenix (just add VERSIONS=3 to your D

RE: Multiple versions for single row key

Any suggestions? From: Ramanathan, Kannan: IT (NYK) Sent: Wednesday, February 10, 2016 12:03 To: user@phoenix.apache.org Subject: Multiple versions for single row key Hello, HBase tables support multiple versions (default is 3) for single row key. I am trying to see how efficiently this can be

Multiple versions for single row key

Hello, HBase tables support multiple versions (default is 3) for single row key. I am trying to see how efficiently this can be achieved in Phoenix (don't want to create view on existing HBase table, just want to go with new Phoenix table). Is it better to create a separate secondary key column

RE: Phoenix Query exception on few tables

Thanks Ankit, trying your suggestions. From: Ankit Singhal [mailto:ankitsingha...@gmail.com] Sent: Friday, January 29, 2016 10:43 To: user@phoenix.apache.org Subject: Re: Phoenix Query exception on few tables can you check HBase master page and see if some regions are in transition or failing in

RE: Phoenix Query exception on few tables

Can someone please help? It's very sporadic and not sure where to start looking into this issue. Many thanks. From: Ramanathan, Kannan: IT (NYK) Sent: Thursday, January 28, 2016 14:04 To: user@phoenix.apache.org Subject: Phoenix Query exception on few tables We have started seeing PhoenixIOExcep

Phoenix Query exception on few tables

We have started seeing PhoenixIOException exception from select query on few of our tables. The same query worked before. The query is simple select query and the exception is below: org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException: The system can

strange behavior with DATE columns

Hello, I am having a DATE column in Phoenix DB. Through SQuirreL SQL client or JDBC, when I do an upsert date as string, the resultant date is always one day less. For ex all the below statements (with any date format in TO_DATE function) yield the same result (i.e., instead of 15th it's 14th o

RE: Alter table - can't add column to table which has PK column type is VARBINARY

Thanks James. While doing some testing on this, I have accidentally ended up with two columns having same name/type but different column sizes. Please see below (table with column name “ID” repeating twice): [cid:image001.png@01D13C03.D9189390] From: James Taylor [mailto:jamestay...@apache.or

RE: Alter table - can't add column to table which has PK column type is VARBINARY

Strangely, if the primary key column is of type BINARY (instead of VARBINARY), columns can be added using alter table. From: Ramanathan, Kannan: IT (NYK) Sent: Monday, December 21, 2015 11:38 To: user@phoenix.apache.org Subject: Alter table - can't add column to table which has PK column type is

Alter table - can't add column to table which has PK column type is VARBINARY

Hello all, I am trying to alter table (adding new column) to a table which has a primary key column of type VARBINARY. I am getting the following error: Error: ERROR 1015 (42J04): Cannot add column to table when the last PK column is of type VARBINARY or ARRAY. columnName=ID SQLState: 42J04 Er

Phoenix JDBC connection pool

Hi, Should we pool the Phoenix JDBC connection like any other JDBC connection (probably using DBCP or similar)? If not: 1. What's the reason behind not to pool? 2. What should be the access pattern? a. Create the connection once and use the cached connection till the proces