Thank you Christoph...
________________________________ From: Christoph Rupp <[email protected]> To: [email protected] Sent: Wednesday, October 17, 2012 4:46 PM Subject: Re: [hypertable-dev] is it delete problem? Hi Mali, you write: > i saw that sometimes step5 is working 2 times in my python code. > > for example; > > hypertable> select * from sozluk return_deletes; > aime guid:b 0c9702aa-ea09-4c77-9e59- > 7caaa3a726c7 > aime guid:b 0c9702aa-ea09-4c77-9e59-7caaa3a726c7 That's right. You can insert the same cell multiple times, and the cell will be created with a newer timestamp. If you run the SELECT query with DISPLAY_TIMESTAMPS then you will see that there are two versions. If you want to avoid that then you can change your query: select * from sozluk return_deletes MAX_VERSIONS 1; or change the column family: create table t (guid MAX_VERSIONS 1); bye Christoph 2012/10/17 Mehmet Ali Cetinkaya <[email protected]> Hi Christoph, > >i tried your suggestion. it worked succesfully. > >but i'm using "delete 'guid:b' from sozluk where row="herbier";" hql for >delete in my project. >i tried it too. i didn't get any error. > >anyway, this is steps of my work. maybe you can find any mistake. > >step1: insert into sozluk values ("aime", "guid:a", >"0a2431a5-22b3-4461-9ac7-3bf67c1e2061"); >step2: delete 'guid:a' from sozluk where row="aime"; >step3: insert into sozluk values ("aime", "guid:crawi_172_16_16_16", >"0a2431a5-22b3-4461-9ac7-3bf67c1e2061"); >step4: delete 'guid:crawi_172_16_16_16' from sozluk where row="aime"; >step5: insert into sozluk values ("aime", "guid:b", >"0a2431a5-22b3-4461-9ac7-3bf67c1e2061"); > >i saw that sometimes step5 is working 2 times in my python code. > >for example; > >hypertable> select * from sozluk return_deletes; >aime guid:b 0c9702aa-ea09-4c77-9e59-7caaa3a726c7 >aime guid:b 0c9702aa-ea09-4c77-9e59-7caaa3a726c7 > > Elapsed time: 0.00 s >Avg value size: 18.00 bytes > Avg key size: 10.20 bytes > Throughput: 314732.14 bytes/s > Total cells: 2 > Throughput: 11160.71 cells/s > >hypertable> delete 'guid:b' from sozluk where row="aime"; > > Elapsed time: 2.62 s > Total cells: 1 > Throughput: 0.38 cells/s > Resends: 0 > >hypertable> select * from sozluk return_deletes; > >aime guid:b DELETE CELL > > Elapsed time: 0.00 s >Avg value size: 9.00 bytes > Avg key size: 10.75 bytes > Throughput: 165618.45 bytes/s > Total cells: 4 > Throughput: 8385.74 cells/s > >thanks, >mali > > > >________________________________ > From: Christoph Rupp <[email protected]> >To: [email protected] >Sent: Tuesday, October 16, 2012 4:57 PM > >Subject: Re: [hypertable-dev] is it delete problem? > > > >This could be a bug in the scanner implementation, maybe it's not handling the >deleted cells correctly. I tried to reproduce this. I created a table, >inserted a couple of values, but everything worked as expected. > >hypertable> create table sozluk(guid); >hypertable> insert into sozluk values ("aime", "guid:b", >"0a2431a5-22b3-4461-9ac7-3bf67c1e2061"); >hypertable> insert into sozluk values ("aime_pas", "guid:b", >"1d1b7f35-a14f-4e24-9e98-c2f626f66c21"); >hypertable> insert into sozluk values ("herbier", "guid:b", >"0c9702aa-ea09-4c77-9e59-7caaa3a726c7"); > >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 > >hypertable> select guid:b from sozluk where row="herbier"; >herbier guid:b 0c9702aa-ea09-4c77-9e59-7caaa3a726c7 > >hypertable> delete guid from sozluk where row="herbier"; > >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 > >Are you able to recreate the problem with a series of HQL commands? > > >2012/10/16 Mehmet Ali Cetinkaya <[email protected]> > >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. >> >-- >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.
