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
