Hello, can you try this query, select * from TAB_CDR_EVENT where row =^ '8795741' and row regexp "^8795741...\-........B..$" limit 1
with this Query, does it still have the count of results issue? there is another, issue of the row comparison select, have filled it on the current issue (will be great you could confirm) Thanks, Kashirin Alex On Monday, December 9, 2013 5:34:53 AM UTC+2, [email protected] wrote: > > Hi Dong, > > Sorry for reply so later. Here is the result: > > > > hypertable> select * from TAB_CDR_EVENT where > -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.
