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] https://phoenix.apache.org/language/functions.html#regexp_substr On Fri, Jun 23, 2017 at 4:29 AM, Nan Xu <nanxu1...@gmail.com> 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 >
