Re: Problem in finding the largest value of an indexed column

2015-07-13 Thread Yufan Liu
GMT-07:00 James Taylor jamestay...@apache.org: Sounds like something else is going wrong. Can you adapt your test by setting the MAX_FILESIZE very low for your table (so that it splits after 4 or 5 rows are added) and package it up as a unit test? On Thu, Jul 9, 2015 at 1:44 PM, Yufan Liu yli

Re: Problem in finding the largest value of an indexed column

2015-07-09 Thread Yufan Liu
/language/index.html#alter_index On Thu, Jul 2, 2015 at 5:26 PM, Yufan Liu yli...@kent.edu wrote: The query on test dataset is returning the expected result with the patch. But on the original dataset (10million rows, 6 regions), it still return the same unexpected result, I will dig more

Re: Problem in finding the largest value of an indexed column

2015-07-02 Thread Yufan Liu
The query on test dataset is returning the expected result with the patch. But on the original dataset (10million rows, 6 regions), it still return the same unexpected result, I will dig more into this. Thank you, James! 2015-07-02 9:58 GMT-07:00 Yufan Liu yli...@kent.edu: Sure, let me have

Re: Problem in finding the largest value of an indexed column

2015-07-02 Thread Yufan Liu
I'm using 4.4.0-HBase-0.98 2015-07-01 22:31 GMT-07:00 James Taylor jamestay...@apache.org: Yufan, What version of Phoenix are you using? Thanks, James On Wed, Jul 1, 2015 at 2:34 PM, Yufan Liu yli...@kent.edu wrote: When I made more tests, I find that this problem happens after table got

Re: Problem in finding the largest value of an indexed column

2015-07-01 Thread Yufan Liu
when possible. Make you use NULLS LAST in your ORDER BY as rows are ordered with nulls first. On Tue, Jun 30, 2015 at 5:25 PM, Yufan Liu yli...@kent.edu wrote: I used the HBase reverse scan to find the last row on the index table. It returned the expected result. I would like to know

Re: Problem in finding the largest value of an indexed column

2015-07-01 Thread Yufan Liu
), it returns 143024961. Let know if you find anything. Thanks! 2015-07-01 11:27 GMT-07:00 James Taylor jamestay...@apache.org: If you could put a complete test (including your DDL and upsert of data), that would be much appreciated. Thanks, James On Wed, Jul 1, 2015 at 11:20 AM, Yufan Liu yli

Re: Problem in finding the largest value of an indexed column

2015-06-26 Thread Yufan Liu
in error, please notify the sender immediately by reply e-mail and promptly destroy all electronic and printed copies of this communication and any attachment. *From:* Yufan Liu [mailto:yli...@kent.edu] *Sent:* Friday, June 26, 2015 6:31 PM *To:* user@phoenix.apache.org *Subject:* Problem

Re: Problem in finding the largest value of an indexed column

2015-06-26 Thread Yufan Liu
weekend! Mike *From:* Yufan Liu [mailto:yli...@kent.edu] *Sent:* Friday, June 26, 2015 7:19 PM *To:* user@phoenix.apache.org *Subject:* Re: Problem in finding the largest value of an indexed column Hi Michael, Thanks for the advice, for the first one, it's CLIENT 67-CHUNK PARALLEL

Problem in finding the largest value of an indexed column

2015-06-26 Thread Yufan Liu
Hi, We have created a table (eg, t1), and a global index of one numeric column of t1 (eg, timestamp). Now we want to find the largest value of timestamp, we have tried two approaches: 1. select max(timestamp) from t1; This query takes forever to finish, so I think it maybe doing a full table

Re: table alias

2015-06-16 Thread Yufan Liu
Hi James, I have tried the queries you guys are using above (select fact.c1 from (select k as k1, col1 as c1 from t1) as fact), it works. But in the result set, it displays the original column name (col1) instead of alias name (c1). Is that expected behavior? 2015-06-16 13:39 GMT-07:00 James