Hi, can you run the SELECTs again with RETURN_DELETES?
Thanks Christoph 2012/10/16 Mehmet Ali Cetinkaya <[email protected]> > hello again; > > my last mail is wrong. because i mixed up all queries. sorry for this > mistake. > > anyway, > > step 1: when i select first three (cell_limit 3) "guid:b" cells from > sozluk table results are; > > hypertable> select guid:b from sozluk cell_limit 3 display_timestamps; > > 2012-10-05 19:53:08.307870001 aime guid:b > 0a2431a5-22b3-4461-9ac7-3bf67c1e2061 > 2012-10-05 19:53:08.290855001 aime_pas guid:b > 1d1b7f35-a14f-4e24-9e98-c2f626f66c21 > 2012-10-08 17:20:00.197097001 herbier guid:b > 0c9702aa-ea09-4c77-9e59-7caaa3a726c7 > > > Elapsed time: 0.01 s > Avg value size: 36.00 bytes > Avg key size: 9.33 bytes > Throughput: 10813.39 bytes/s > Total cells: 3 > Throughput: 238.53 cells/s > > step 2: i'm using another select query. but i don't get any result. > > hypertable> select guid:b from sozluk where row="herbier"; > > Elapsed time: 0.00 s > > step 3: i wanna delete cell; > > hypertable> delete guid from sozluk where row="herbier"; > > > Elapsed time: 0.00 s > Total cells: 1 > Throughput: 744.60 cells/s > Resends: 0 > > step 4: i'm trying same select queries. and everything is same. > > hypertable> select guid:b from sozluk cell_limit 3; > > aime guid:b 0a2431a5-22b3-4461-9ac7-3bf67c1e2061 > aime_pas guid:b 1d1b7f35-a14f-4e24-9e98-c2f626f66c21 > herbier guid:b 0c9702aa-ea09-4c77-9e59-7caaa3a726c7 > > > Elapsed time: 0.01 s > Avg value size: 36.00 bytes > Avg key size: 9.33 bytes > Throughput: 11675.82 bytes/s > Total cells: 3 > Throughput: 257.55 cells/s > hypertable> select guid:b from sozluk where row="herbier"; > > Elapsed time: 0.00 s > > > step 5: when i selected same cell from guid; > > hypertable> select guid:b from sozluk where > guid="0c9702aa-ea09-4c77-9e59-7caaa3a726c7"; > herbier guid:b 0c9702aa-ea09-4c77-9e59-7caaa3a726c7 > herbier guid:b 0c9702aa-ea09-4c77-9e59-7caaa3a726c7 > > Elapsed time: 1.57 s > > Avg value size: 36.00 bytes > Avg key size: 10.00 bytes > Throughput: 58.62 bytes/s > Total cells: 2 > Throughput: 1.27 cells/s > > hypertable> select guid:b from sozluk where guid=^"0c9702aa-ea0" > display_timestamps; > 2012-10-08 17:20:00.197097001 herbier guid:b > 0c9702aa-ea09-4c77-9e59-7caaa3a726c7 > 2012-10-08 17:20:00.197041001 herbier guid:b > 0c9702aa-ea09-4c77-9e59-7caaa3a726c7 > > Elapsed time: 1.57 s > > Avg value size: 36.00 bytes > Avg key size: 10.00 bytes > Throughput: 58.69 bytes/s > Total cells: 2 > Throughput: 1.28 cells/s > > > how can i solve this issue? > > thanx, > mali > > ------------------------------ > *From:* Mehmet Ali Cetinkaya <[email protected]> > *To:* "[email protected]" <[email protected]> > *Sent:* Tuesday, October 16, 2012 11:26 AM > *Subject:* [hypertable-dev] is it delete problem? > > Hello, > > i wanna delete guid that it's row must have "aime" from sozluk table. like > this; > > delete guid from sozluk where row="aime"; > > Elapsed time: 0.00 s > Total cells: 1 > Throughput: 323.42 cells/s > Resends: 0 > > ht said "i deleted 1 row". it's cool for me. but sometimes when i use > select query i can find deleted row. i don't know why. > this is my all select querys after then deleted the row. > > how can i solve this issue? > thanx > mali > > select guid:b from sozluk cell_limit 2; > aime guid:b 0a2431a5-22b3-4461-9ac7-3bf67c1e2061 > aime_pas guid:b 1d1b7f35-a14f-4e24-9e98-c2f626f66c21 > > Elapsed time: 0.01 s > Avg value size: 36.00 bytes > Avg key size: 9.00 bytes > Throughput: 7102.27 bytes/s > Total cells: 2 > Throughput: 157.83 cells/s > > select guid:b from sozluk cell_limit 2 display_timestamps; > 2012-10-05 19:53:08.307870001 aime guid:b > 0a2431a5-22b3-4461-9ac7-3bf67c1e2061 > 2012-10-05 19:53:08.290855001 aime_pas guid:b > 1d1b7f35-a14f-4e24-9e98-c2f626f66c21 > > Elapsed time: 0.01 s > Avg value size: 36.00 bytes > Avg key size: 9.00 bytes > Throughput: 7747.27 bytes/s > Total cells: 2 > Throughput: 172.16 cells/s > > select guid:b from sozluk where > guid="0a2431a5-22b3-4461-9ac7-3bf67c1e2061" display_timestamps; > 2012-10-05 19:53:08.307870001 aime guid:b > 0a2431a5-22b3-4461-9ac7-3bf67c1e2061 > > Elapsed time: 1.58 s > Avg value size: 36.00 bytes > Avg key size: 7.00 bytes > Throughput: 27.19 bytes/s > Total cells: 1 > Throughput: 0.63 cells/s > > select guid:b from sozluk where > guid="1d1b7f35-a14f-4e24-9e98-c2f626f66c21" display_timestamps; > 2012-10-05 19:53:08.290855001 aime_pas guid:b > 1d1b7f35-a14f-4e24-9e98-c2f626f66c21 > > Elapsed time: 1.59 s > Avg value size: 36.00 bytes > Avg key size: 11.00 bytes > Throughput: 29.62 bytes/s > Total cells: 1 > Throughput: 0.63 cells/s > > > ---- > > select guid:b from sozluk where row=^"aime_"; > > Elapsed time: 0.00 s > > select * from sozluk where row=^"aime_"; > > Elapsed time: 0.00 s > > select * from sozluk where row=^"aime_" cell_limit 1; > > Elapsed time: 0.00 s > > ---- > > select * from sozluk where row="aime" cell_limit 1 display_timestamps; > 2012-10-04 18:43:00.608148001 aime guid:b > d7e9c5cb-d647-4ba2-8ec1-3f505ced376b > > Elapsed time: 0.00 s > Avg value size: 36.00 bytes > Avg key size: 6.00 bytes > Throughput: 44025.16 bytes/s > Total cells: 1 > Throughput: 1048.22 cells/s > > select guid:b from sozluk where row="aime"; > aime guid:b d7e9c5cb-d647-4ba2-8ec1-3f505ced376b > > Elapsed time: 0.00 s > Avg value size: 36.00 bytes > Avg key size: 6.00 bytes > Throughput: 46357.62 bytes/s > Total cells: 1 > Throughput: 1103.75 cells/s > > select guid:b from sozluk where row=^"aime" cell_limit 5; > aime guid:b d7e9c5cb-d647-4ba2-8ec1-3f505ced376b > aimed guid:b 08864475-9914-4a6f-b86a-0ca9c6c21014 > aimee guid:b f96c9014-8e9f-40b5-9057-6a379c7a682b > aimee_myers_dolich guid:b 2d1042e1-325c-4de9-9ae6-89eeaa3f9308 > aimee_sweet guid:b 1ab3307e-67d7-4bca-95b5-48c93fbb970e > > Elapsed time: 0.00 s > Avg value size: 36.00 bytes > Avg key size: 10.60 bytes > Throughput: 193843.59 bytes/s > Total cells: 5 > Throughput: 4159.73 cells/s > > -- > You received this message because you are subscribed to the Google Groups > "Hypertable Development" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/hypertable-dev?hl=en. > > > -- > You received this message because you are subscribed to the Google Groups > "Hypertable Development" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/hypertable-dev?hl=en. > -- You received this message because you are subscribed to the Google Groups "Hypertable Development" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/hypertable-dev?hl=en.
