Thanks Christoph i will try. but first, can you look my table's structure. is it any problem?
hypertable> show create table sozluk; CREATE TABLE sozluk ( guid, ACCESS GROUP default (guid) ) Elapsed time: 0.00 s hypertable> describe table sozluk; <Schema> <AccessGroup name="default"> <ColumnFamily> <Name>guid</Name> <Counter>false</Counter> <deleted>false</deleted> </ColumnFamily> </AccessGroup> </Schema> Elapsed time: 0.00 s ________________________________ 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.
