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.
