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.
