phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nan Xu <>
Subject Re: phoenix query modtime
Date Fri, 23 Jun 2017 14:35:09 GMT
sorry, maybe I did not make it clear, I have a hbase table, already
formatted with phoenix format and has composite key, I can query all the
columns I want, but I can not query the hbase modtime in phoenix query, any
way to do this?


On Fri, Jun 23, 2017 at 1:23 AM, Ankit Singhal <>

> If you have composite columns in your row key of HBase table and they are
> not formed through Phoenix then you can't access an individual column of
> primary key by Phoenix SQL too.
> Try composing the whole PK and use them in a filter or may check if you
> can use regex functions[1] or LIKE operator.
> [1]
> On Fri, Jun 23, 2017 at 4:29 AM, Nan Xu <> wrote:
>> I have a phoenix table created on existing hbase table, and want to query
>> something like
>> select * from mytable where modtime>'2010-01-01',
>> how do I query phoenix like this? seems it doesn't have a modtime column
>> if I don't do the modtime mapping, which I can not do because it has to be
>> part of the primary key.
>> Thanks,
>> Nan

View raw message