Re: [hypertable-dev] limit problem

wuxin6279545 Sun, 08 Dec 2013 19:37:35 -0800


在 2013年12月9日星期一UTC+8上午11时34分53秒，[email protected]写道：
>
> Hi Dong, 
>
> Sorry for reply so later. Here is the result:
>
>  
>
> hypertable> select * from TAB_CDR_EVENT where 
> '8795741566-51015A61BHE'<ROW<='D0000000000000000000zH ' and row regexp 
> "B..$" limit 1 RETURN_DELETES;  
>
>   Elapsed time:  3.89 s
> hypertable> 
> hypertable> 
> hypertable> select * from TAB_CDR_EVENT where 
> '8795741566-51015A61BHE'<ROW<='D0000000000000000000zH ' and row regexp 
> "B..$" limit 2 RETURN_DELETES; 
> 8795741618-51015A93BHE  CALLED_NUMBER   1167645056-51015A93
> 8795741618-51015A93BHE  IMSI    46002795741340451015A93
> 8795741618-51015A93BHE  IMEI    352739032789967851015A93
> 8795741618-51015A93BHE  CDR_RESULT      25551015A93
> 8795741618-51015A93BHE  TMSI    1819090051015A93
> 8795741618-51015A93BHE  F1:F1   
> 18795741618\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\n%\0\0\0\n%\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\00\0f0\0\t\0f0\0]0\0\0XP
>  cXP0-\0\0\0
> 8795741618-51015A93BHE  F2:F2   
> H0\0\0\0\0\0\0\0\0\0XP\0\0XP 
> c\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\t\0\0\0\0\0\0\00\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\00\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0/\0\0\0M\0\0\0
> 8795741715-51015AD0BHE  CALLED_NUMBER   1167645056-51015AD0
> 8795741715-51015AD0BHE  IMSI    46002795741693651015AD0
> 8795741715-51015AD0BHE  IMEI    865780000385677851015AD0
> 8795741715-51015AD0BHE  CDR_RESULT      25551015AD0
> 8795741715-51015AD0BHE  TMSI    164538176751015AD0
> 8795741715-51015AD0BHE  F1:F1   
> 18795741715\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\n%E\n\0\0\0\0\n%
>  
> 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\00\0f0\0\t\0f0\0\0\0\0)0'\0\0\0
> 8795741715-51015AD0BHE  F2:F2   
> \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\n\0\0\0\0\0\0\0 
> \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\00\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0,\0\0\0;\0\0\0
>
>   Elapsed time:  4.05 s
> Avg value size:  58.00 bytes
>   Avg key size:  23.57 bytes
>     Throughput:  281.75 bytes/s
>    Total cells:  14
>     Throughput:  3.45 cells/s
> hypertable> 
>
> Because the metadata is large, please check the attach file meta.txt. 
>
> Thanks
>
>
> 在 2013年12月7日星期六UTC+8上午12时06分45秒，Doug Judd写道：
>>
>> If you're still having this problem, can you post the output of the 
>> following commands:
>>
>> select * from TAB_CDR_EVENT where 
>> '8795741566-51015A61BHE'<ROW<='D0000000000000000000zH ' and row regexp 
>> "B..$" limit 1 RETURN_DELETES;
>>
>> select * from TAB_CDR_EVENT where 
>> '8795741566-51015A61BHE'<ROW<='D0000000000000000000zH ' and row regexp 
>> "B..$" limit 2  RETURN_DELETES;
>>
>> use /sys;
>> select * from METADATA MAX_VERSIONS 1;
>>
>> Thanks,
>> Doug
>>
>>
>> On Thu, Dec 5, 2013 at 7:41 PM, Doug Judd <[email protected]> wrote:
>>
>>> Ok, I've filed an issue on this (
>>> https://code.google.com/p/hypertable/issues/detail?id=1175).  If you 
>>> have a way to easily reproduce this, please let us know.
>>>
>>> - Doug
>>>
>>>
>>> On Thu, Dec 5, 2013 at 6:50 PM, <[email protected]> wrote:
>>>
>>>> Hi Doug,
>>>> I have done testing in Master Version: 0.9.7.13 (v0.9.7.13-0-gea48c75). 
>>>> It seems that the problem doesn't be resolve. 
>>>>  
>>>> hypertable> select * from TAB_CDR_EVENT where 
>>>> '8795741566-51015A61BHE'<ROW<='D0000000000000000000zH ' and row regexp 
>>>> "B..$" limit 1;
>>>>   Elapsed time:  3.90 s
>>>> hypertable> select * from TAB_CDR_EVENT where 
>>>> '8795741566-51015A61BHE'<ROW<='D0000000000000000000zH ' and row regexp 
>>>> "B..$" limit 2;
>>>> 8795741618-51015A93BHE  CALLED_NUMBER   1167645056-51015A93
>>>> 8795741618-51015A93BHE  IMSI    46002795741340451015A93
>>>> 8795741618-51015A93BHE  IMEI    352739032789967851015A93
>>>> 8795741618-51015A93BHE  CDR_RESULT      25551015A93
>>>> 8795741618-51015A93BHE  TMSI    1819090051015A93
>>>> 8795741618-51015A93BHE  F1:F1   
>>>> 18795741618\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\n%\0\0\0\n%\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\00\0f0\0\t\0f0\0]0\0\0XP
>>>>  
>>>> cXP0-\0\0\0
>>>> 8795741618-51015A93BHE  F2:F2   H0\0\0\0\0\0\0\0\0\0XP\0\0XP 
>>>> c\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\t\0\0\0\0\0\0\00\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\00\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0/\0\0\0M\0\0\0
>>>> 8795741715-51015AD0BHE  CALLED_NUMBER   1167645056-51015AD0
>>>> 8795741715-51015AD0BHE  IMSI    46002795741693651015AD0
>>>> 8795741715-51015AD0BHE  IMEI    865780000385677851015AD0
>>>> 8795741715-51015AD0BHE  CDR_RESULT      25551015AD0
>>>> 8795741715-51015AD0BHE  TMSI    164538176751015AD0
>>>> 8795741715-51015AD0BHE  F1:F1   
>>>> 18795741715\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\n%E\n\0\0\0\0\n%
>>>>  
>>>> 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\00\0f0\0\t\0f0\0\0\0\0)0'\0\0\0
>>>> 8795741715-51015AD0BHE  F2:F2   
>>>> \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\n\0\0\0\0\0\0\0 
>>>> \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\00\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0,\0\0\0;\0\0\0
>>>>   Elapsed time:  3.97 s
>>>> Avg value size:  58.00 bytes
>>>>
>>>>   Avg key size:  23.57 bytes
>>>>     Throughput:  287.71 bytes/s
>>>>    Total cells:  14
>>>>     Throughput:  3.53 cells/s
>>>>
>>>> On Thursday, November 21, 2013 9:19:30 AM UTC+8, Doug Judd wrote:
>>>>
>>>>> I believe this problem was resolved in 0.9.7.9.  Try upgrading to the 
>>>>> latest version (0.9.7.13).  If it doesn't resolve the problem, please let 
>>>>> us know.
>>>>>
>>>>> - Doug
>>>>>  
>>>>>
>>>>> On Wed, Nov 20, 2013 at 5:16 PM, <[email protected]> wrote:
>>>>>
>>>>>>  same query condition except limit, the limit 1 have no result.
>>>>>>  
>>>>>> Hypertable version : Master Version: 0.9.7.7 
>>>>>> (v0.9.7.7-0-g015012b-dirty)
>>>>>>  
>>>>>>
>>>>>> hypertable> select * from TAB_CDR_EVENT where 
>>>>>> '1595101716351B5FF56BHz'<ROW<='1595165952051B823C4BCz' and row 
>>>>>> regexp 'B..$' keys_only limit 2;
>>>>>> 1595101716351B60D69BHz
>>>>>> 1595101716351B60D69BHz
>>>>>> 1595101716351B60D69BHz
>>>>>> 1595101716351B60D69BHz
>>>>>> 1595101716351B60D69BHz
>>>>>> 1595101716351B60D69BHz
>>>>>> 1595101716351B60D69BHz
>>>>>> 1595101716351B61B7CBHz
>>>>>> 1595101716351B61B7CBHz
>>>>>> 1595101716351B61B7CBHz
>>>>>> 1595101716351B61B7CBHz
>>>>>> 1595101716351B61B7CBHz
>>>>>> 1595101716351B61B7CBHz
>>>>>> 1595101716351B61B7CBHz
>>>>>>
>>>>>>   Elapsed time:  0.00 s
>>>>>>   Avg key size:  23.57 bytes
>>>>>>    Total cells:  14
>>>>>>     Throughput:  4549.89 cells/s
>>>>>> hypertable> select * from TAB_CDR_EVENT where 
>>>>>> '1595101716351B5FF56BHz'<ROW<='1595165952051B823C4BCz' and row 
>>>>>> regexp 'B..$' keys_only limit 1;
>>>>>>
>>>>>>   Elapsed time:  0.00 s
>>>>>>  
>>>>>> -- 
>>>>>> You received this message because you are subscribed to the Google 
>>>>>> Groups "Hypertable Development" group.
>>>>>> To unsubscribe from this group and stop receiving emails from it, 
>>>>>> send an email to [email protected].
>>>>>> To post to this group, send email to [email protected].
>>>>>>
>>>>>> Visit this group at http://groups.google.com/group/hypertable-dev.
>>>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> -- 
>>>>> Doug Judd
>>>>> CEO, Hypertable Inc.
>>>>>  
>>>>  -- 
>>>> You received this message because you are subscribed to the Google 
>>>> Groups "Hypertable Development" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send 
>>>> an email to [email protected].
>>>> To post to this group, send email to [email protected].
>>>> Visit this group at http://groups.google.com/group/hypertable-dev.
>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>
>>>
>>>
>>>
>>> -- 
>>> Doug Judd
>>> CEO, Hypertable Inc.
>>>  
>>
>>
>>
>> -- 
>> Doug Judd
>> CEO, Hypertable Inc.
>>  
>


-- 
You received this message because you are subscribed to the Google Groups 
"Hypertable Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/hypertable-dev.
For more options, visit https://groups.google.com/groups/opt_out.

meta.rar
Description: application/rar

Re: [hypertable-dev] limit problem

Reply via email to