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?
Nan On Fri, Jun 23, 2017 at 1:23 AM, Ankit Singhal <ankitsingha...@gmail.com> wrote: > 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 >> > >
