Great, thank you. Would you be willing to run an instrumented version of Hypertable? It would help pin down exactly where the error is occurring.
- Doug On Sun, Dec 8, 2013 at 7:37 PM, <[email protected]> wrote: > > > 在 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. > -- 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.
