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]>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]. > 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.
