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.
