I'm trying to design the Phoenix/HBase table schema in order to answer these questions:
* Does the given user have attribute X with value Y? and at given time t1. * Get list of users who had attribute X with value Y between timestamps t1 and t2? * Get all the attributes of user at or around a given time t1. Is there a way to design the schema (or multiple table schema) to answer these questions and if there are any restrictions on querying using Phoenix? Please let me know. Thanks!
