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.
