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 <kashirin.a...@gmail.com>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, <wuxin6...@gmail.com> 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, <wuxin6...@gmail.com> 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 hypertable-de...@googlegroups.com. >>>>> To post to this group, send email to hyperta...@googlegroups.com. >>>>> >>>>> 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 hypertable-de...@googlegroups.com. >>> To post to this group, send email to hyperta...@googlegroups.com. >>> 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 hypertable-dev+unsubscr...@googlegroups.com. > To post to this group, send email to hypertable-dev@googlegroups.com. > 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 hypertable-dev+unsubscr...@googlegroups.com. To post to this group, send email to hypertable-dev@googlegroups.com. Visit this group at http://groups.google.com/group/hypertable-dev. For more options, visit https://groups.google.com/groups/opt_out.
