phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <>
Subject Re: phoenix query modtime
Date Sat, 24 Jun 2017 13:52:56 GMT
It's a reasonable request IMHO - please file a JIRA so we can discuss how
this could be supported.

On Sat, Jun 24, 2017 at 4:27 PM Ankit Singhal <>

> Yes, and also to avoid returning an incomplete row for the same primary
> key because of different timestamp for the column's cell.
> On Sat, Jun 24, 2017 at 4:20 AM, Randy Hu <> wrote:
>> First HBase does not have a concept of "row timestamp". Timestamp is part
>> of each cell. The closest to row timestamp is probably the latest
>> timestamp
>> from all cells with same row key.
>> The reason that timestamp column need to be part of primary key is that
>> there could be multiple values with different timestamps but same row key,
>> family. and qualifier. The SQL result data model does not support such two
>> dimension structure well. The best Phoenix can do in the SQL model is to
>> return list of values in array, but then the cell timestamp need to be
>> returned in another array with same length under different column name.
>> You
>> can imagine the mess and awkwardness it could be if going to that
>> direction. It's much straightforward to make time stamp part of primary
>> key, so the two dimension structure could be represented by multiple rows
>> naturally in SQL result.
>> Randy
>> --
>> View this message in context:
>> Sent from the Apache Phoenix User List mailing list archive at

View raw message