That is missing the point of row prefix cells reduction possibilities for regexp, (but that option is of an issue of accumulated results per OR/AND rule) That should be more precise
Kashirin Alex On Sunday, December 15, 2013 1:53:53 PM UTC+2, Alex Kashirin wrote: > > to review that query you can use - http://www.rubular.com/r/tu0ReHWjuv > > > > On Sunday, December 15, 2013 1:51:51 PM UTC+2, Alex Kashirin wrote: >> >> more correct, query for you, it is: >> >> select * from TAB_CDR_EVENT where row regexp >> '^(([8-8][7-9][9-9][5-9][7-9][4-9][1-9][5-9][6-9][6-9])|([8-8][7-9][9-9][5-9][7-9][4-9][1-9][5-9][7-9][0-9])|([8-8][7-9][9-9][5-9][7-9][4-9][1-9][6-9][0-9][0-9])|([8-8][7-9][9-9][5-9][7-9][4-9][2-9][0-9][0-9][0-9])|([8-8][7-9][9-9][5-9][7-9][3-9][0-9][0-9][0-9][0-9])|([8-8][7-9][9-9][5-9][8-9][0-9][0-9][0-9][0-9][0-9])|([8-8][7-9][9-9][6-9][0-9][0-9][0-9][0-9][0-9][0-9])|([8-8][8-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9])|([8-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]))\-(([5-5][1-9][0-9][1-9][5-9].[6-9][1-9])|([5-5][1-9][0-9][1-9][5-9].[7-9][0-9])|([5-5][1-9][0-9][1-9][6-9].[0-9][0-9])|([5-5][1-9][0-9][2-9][0-9].[0-9][0-9])|([5-5][1-9][1-9][0-9][0-9].[0-9][0-9])|([5-5][2-9][0-9][0-9][0-9].[0-9][0-9])|([6-9][0-9][0-9][0-9][0-9].[0-9][0-9]))(B..)$' >> >> limit 1; >> >> Have a try of it, the previous is missing every higher than the prefix! >> >> Let me know , what is the different of Elapsed time for the results. >> >> THE REGEXP rule , is all about your floor to end (floor<9) OR ceiling >> (0) to floor end (9>floor) :) >> >> >> Thanks, >> Kashirin Alex >> >> >> >> On Saturday, December 14, 2013 5:46:54 PM UTC+2, Alex Kashirin wrote: >>> >>> 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.
