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