>>> I have tried to use query "SELECT timestamp FROM t1 ORDER BY
>>>>>>>>>>> timestamp DESC NULLS LAST LIMIT 1". But it still returns the same
>>>>>>>>>>> unexpected result. There seems to be some internal problems related.
ST LIMIT 1". But it still returns the same
>>>>>>>>>> unexpected result. There seems to be some internal problems related.
>>>>>>>>>>
>>>>>>>>>> 2015-06-30 18:03 GMT-07:00 James Taylor :
>
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
>>>>>>>>>> wr
ix.apache.org
>>>>>>>>>>>> *Subject:* Re: Problem in finding the largest value of an
>>>>>>>>>>>> indexed column
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>
sed the HBase reverse scan to find the last row on the index
>>>>>>>>> table. It returned the expected result. I would like to know is
>>>>>>>>> Phoenix's
>>>>>>>>> "ORDER BY"
>>>>>>>>&
IRST KEY
>>>>>>>>>> ONLY; SERVER AGGREGATE INTO SINGLE ROW" which is as expected. For the
>>>>>>>>>> second one, it's "CLIENT 67-CHUNK SERIAL 1-WAY REVERSE FULL SCAN OVER
>>>>>>>>>> TIMESTA
t;ORDER BY"
>>>>>>> and "DESC" implemented based on HBase reverse scan?
>>>>>>>
>>>>>>> 2015-06-26 17:25 GMT-07:00 Yufan Liu :
>>>>>>>
>>>>>>>> Thank you anyway, Michael!
>
t; 2015-06-26 17:25 GMT-07:00 Yufan Liu :
>>>>>>
>>>>>>> Thank you anyway, Michael!
>>>>>>>
>>>>>>> 2015-06-26 17:21 GMT-07:00 Michael McAllister <
>>>>>>> mmcallis...@homeaway.com>:
>>
GMT-07:00 Michael McAllister <
>>>>>>> mmcallis...@homeaway.com>:
>>>>>>>
>>>>>>> Yufan
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Have you tried using the EXPLAIN
, I’m a Phoenix newbie, so that was the extent of the advice I
>>>>>> could give you. There are people here far more experienced than I am who
>>>>>> should be able to give you deeper advice. Have a great weekend!
>>>>>>
>>>>>>
>&g
gt;>>> OK, I’m a Phoenix newbie, so that was the extent of the advice I
>>>>> could give you. There are people here far more experienced than I am who
>>>>> should be able to give you deeper advice. Have a great weekend!
>>>>>
>>>>
ngineer | Decision Systems
>>>>
>>>> mmcallis...@homeaway.com | C: 512.423.7447 | skype:
>>>> michael.mcallister.ha | webex:
>>>> https://h.a/mikewebex
>>>>
>>>> [image: Description: Description: cid:3410354473_30269081]
>&
>>
>>>
>>>
>>> *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
>>>
>>>
>>
;>
>>
>>
>> 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
>&
;
>
>
> 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 a
@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 1-WAY
FULL SCAN OVER TIMESTAMP_INDEX; SERVER FILTER BY FIRST KEY ONLY; SERVER
AGGREGATE INTO SINGLE ROW&qu
...@kent.edu]
> *Sent:* Friday, June 26, 2015 6:31 PM
> *To:* user@phoenix.apache.org
> *Subject:* Problem in finding the largest value of an indexed column
>
>
>
> Hi,
>
> We have created a table (eg, t1), and a global index of one numeric column
> of t1 (eg, times
From: Yufan Liu [mailto:yli...@kent.edu]
Sent: Friday, June 26, 2015 6:31 PM
To: user@phoenix.apache.org
Subject: Problem in finding the largest value of an indexed column
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
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 scan
19 matches
Mail list logo
