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]<javascript:>
> > 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] <javascript:>>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] <javascript:>.
>>> To post to this group, send email to
>>> [email protected]<javascript:>
>>> .
>>> 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.
