Hi Josh,
Thanks for reporting this and providing details on how to reproduce. I will
jump on it immediately.
- Doug
On Wed, Aug 27, 2008 at 6:16 PM, Joshua Taylor <[EMAIL PROTECTED]>wrote:
> Also, this problem seems to happen intermittently even if the table is
> created without MAX_VERSIONS, but when MAX_VERSIONS is used by the scanner.
> If I load a bunch of cells several times, erase them, and insert them again,
> only a few show up in a subsequent MAX_VERSIONS=1 scan. If I erase and
> insert again, nothing shows up in the next MAX_VERSIONS=1 scan.
>
> Josh
>
>
>
> On Wed, Aug 27, 2008 at 6:06 PM, Joshua Taylor <[EMAIL PROTECTED]>wrote:
>
>> I'm seeing some strange behavior when setting and deleting cells in
>> Hypertable. When using MAX_VERSIONS, if I set and delete a cell a few times
>> I don't seem to be able to set it again. I was assuming that MAX_VERSIONS=K
>> would keep up to the latest K versions of cell in the table. In my case,
>> I'm only interested in keeping the latest version of each cell
>> (MAX_VERSIONS=1), but I want to be able to rewrite the cell as many times as
>> I'd like. Am I misinterpreting the parameter?
>>
>> Here's an example on Hypertable 0.9.0.10a with Hadoop 0.17.2 on a cluster
>> of 15 machines. The hypertable client process is running on a separate
>> machine outside the cluster.
>>
>> hypertable> CREATE TABLE bug ( F MAX_VERSIONS=1 );
>> hypertable> SELECT * FROM bug;
>> hypertable> INSERT INTO bug VALUES ('R','F:Q','V1');
>> hypertable> SELECT * FROM bug;
>> R F:Q V1
>> hypertable> DELETE 'F:Q' FROM bug WHERE ROW = 'R';
>> hypertable> SELECT * FROM bug;
>> hypertable> INSERT INTO bug VALUES ('R','F:Q','V2');
>> hypertable> SELECT * FROM bug;
>> R F:Q V2
>> hypertable> DELETE 'F:Q' FROM bug WHERE ROW = 'R';
>> hypertable> SELECT * FROM bug;
>> hypertable> INSERT INTO bug VALUES ('R','F:Q','V3');
>> hypertable> SELECT * FROM bug;
>> hypertable> DELETE 'F:Q' FROM bug WHERE ROW = 'R';
>> hypertable> SELECT * FROM bug;
>> hypertable> INSERT INTO bug VALUES ('R','F:Q','V4');
>> hypertable> SELECT * FROM bug;
>> hypertable> DELETE 'F:Q' FROM bug WHERE ROW = 'R';
>> hypertable> SELECT * FROM bug;
>> hypertable> INSERT INTO bug VALUES ('R','F:Q','V5');
>> hypertable> SELECT * FROM bug;
>> hypertable> DELETE 'F:Q' FROM bug WHERE ROW = 'R';
>> hypertable> SELECT * FROM bug;
>> hypertable> INSERT INTO bug VALUES ('R','F:Q','V6');
>> hypertable> SELECT * FROM bug;
>> hypertable> DROP TABLE bug;
>> hypertable>
>>
>> hypertable> CREATE TABLE bug ( F MAX_VERSIONS=2 );
>> hypertable> SELECT * FROM bug;
>> hypertable> INSERT INTO bug VALUES ('R','F:Q','V1');
>> hypertable> SELECT * FROM bug;
>> R F:Q V1
>> hypertable> DELETE 'F:Q' FROM bug WHERE ROW = 'R';
>> hypertable> SELECT * FROM bug;
>> hypertable> INSERT INTO bug VALUES ('R','F:Q','V2');
>> hypertable> SELECT * FROM bug;
>> R F:Q V2
>> hypertable> DELETE 'F:Q' FROM bug WHERE ROW = 'R';
>> hypertable> SELECT * FROM bug;
>> hypertable> INSERT INTO bug VALUES ('R','F:Q','V3');
>> hypertable> SELECT * FROM bug;
>> R F:Q V3
>> hypertable> DELETE 'F:Q' FROM bug WHERE ROW = 'R';
>> hypertable> SELECT * FROM bug;
>> hypertable> INSERT INTO bug VALUES ('R','F:Q','V4');
>> hypertable> SELECT * FROM bug;
>> hypertable> DELETE 'F:Q' FROM bug WHERE ROW = 'R';
>> hypertable> SELECT * FROM bug;
>> hypertable> INSERT INTO bug VALUES ('R','F:Q','V5');
>> hypertable> SELECT * FROM bug;
>> hypertable> DELETE 'F:Q' FROM bug WHERE ROW = 'R';
>> hypertable> SELECT * FROM bug;
>> hypertable> INSERT INTO bug VALUES ('R','F:Q','V6');
>> hypertable> SELECT * FROM bug;
>> hypertable> DROP TABLE bug;
>> hypertable>
>>
>>
>>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
