Hi Christoph, hypertable> select guid:b from sozluk where guid="0c9702aa-ea09-4c77-9e59-7caaa3a726c7" RETURN_DELETES CELL_LIMIT 5; herbier guid:b 0c9702aa-ea09-4c77-9e59-7caaa3a726c7 herbier guid:b 0c9702aa-ea09-4c77-9e59-7caaa3a726c7 aaa_auto_transport guid:a DELETE CELL aaa_auto_transport guid:i172_16_200_34i DELETE CELL aaa_car guid:a DELETE CELL
Elapsed time: 0.01 s Avg value size: 14.40 bytes Avg key size: 16.60 bytes Throughput: 11003.83 bytes/s Total cells: 5 Throughput: 354.96 cells/s hypertable> select guid:b from sozluk where row="herbier" RETURN_DELETES; herbier guid DELETE COLUMN FAMILY Elapsed time: 0.00 s Avg key size: 8.00 bytes Total cells: 1 Throughput: 1338.69 cells/s mali ________________________________ From: Christoph Rupp <[email protected]> To: [email protected] Sent: Tuesday, October 16, 2012 11:54 AM Subject: Re: [hypertable-dev] is it delete problem? 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. -- 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.
