You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by Jimmy Xiang <jx...@apache.org> on 2019/04/11 18:41:44 UTC

query cell timestamp and tag

I have an existing HBase table. The cell timestamp is not in the row key.
I'd like to make the timestamp a Phoenix table column and query it via
Phoenix.

I noticed that the documentation says row_timestamp column must be one of
the primary key columns. Is it possible to patch Phoenix to lift this
restriction? If so, how hard is it?

How about tags? Any way to query HBase cell tags via Phoenix?

Thanks,
Jimmy

Re: query cell timestamp and tag

Posted by Thomas D'Silva <td...@salesforce.com>.

We have an open JIRA PHOENIX-4552
<https://issues.apache.org/jira/browse/PHOENIX-4552> which has some details
on the work involved. Currently there cell tags cannot be queried using
Phoenix.

On Thu, Apr 11, 2019 at 11:41 AM Jimmy Xiang <jx...@apache.org> wrote:

> I have an existing HBase table. The cell timestamp is not in the row key.
> I'd like to make the timestamp a Phoenix table column and query it via
> Phoenix.
>
> I noticed that the documentation says row_timestamp column must be one of
> the primary key columns. Is it possible to patch Phoenix to lift this
> restriction? If so, how hard is it?
>
> How about tags? Any way to query HBase cell tags via Phoenix?
>
> Thanks,
> Jimmy
>