Large differences in query execution time for similar queries

Hi, I am using Phoenix 4.14-cdh5.11, with sqlline-thin as the client. I am seeing strange patterns around SELECT query execution time: 1. Increasing the LIMIT past a certain "threshold" results in significantly slower execution time. 2. Adding just one column (BIGINT) to the SELECT results in sig

Re: Using Hint with PhoenixRDD

Thanks Thomas. I've created https://issues.apache.org/jira/browse/PHOENIX-5238 On Wed, Apr 10, 2019 at 8:39 PM Thomas D'Silva wrote: > Can you please file a JIRA for this? > > On Wed, Apr 10, 2019 at 5:53 PM William Shen > wrote: > >> Thanks for chiming in Thomas. We were trying to pass in NO_C

Re: query cell timestamp and tag

We have an open JIRA PHOENIX-4552 which has some details on the work involved. Currently there cell tags cannot be queried using Phoenix. On Thu, Apr 11, 2019 at 11:41 AM Jimmy Xiang wrote: > I have an existing HBase table. The cell timestamp

query cell timestamp and tag

I have an existing HBase table. The cell timestamp is not in the row key. I'd like to make the timestamp a Phoenix table column and query it via Phoenix. I noticed that the documentation says row_timestamp column must be one of the primary key columns. Is it possible to patch Phoenix to lift this