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.
