the actual results might/should be consider as correct, when you approach to it as: per SELECT rule 1 result and the "AND" structure as to "select as well" --> while, the actual "AND" is not possible as "and rule", as to at no-point the same row prefix can be 1- and 2- !
as to selecting with CELL_LIMIT 2, that will return 2 results per AND rule Thanks, Kashirin Alex On Saturday, December 28, 2013 2:32:06 AM UTC+2, Doug Judd wrote: > > Well, it seems like the query you supplied should return a single cell > since you also supplied cell_limit 1. Is that what you would like to see? > > - Doug > > > On Thu, Dec 26, 2013 at 6:28 AM, Alex Kashirin > <[email protected]<javascript:> > > wrote: > >> Doug, >> Will be great to know what you think about the last comment on the issue! >> >> http://code.google.com/p/hypertable/issues/detail?id=1175#c5 >> >> Thanks, >> Kashirin Alex >> >> On Friday, December 6, 2013 5:41:58 AM UTC+2, Doug Judd 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. >>> >> -- >> 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. > -- 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.
