My use case is to query time series data ingested into HBase table containing a web page name or url as row key and related properties as column qualifiers. The properties for the web page are dynamic ie, the columns qualifiers are dynamic for a given timestamp.
I would like to create a Hive managed HBase table to query this time series data for properties of the web page at a given timestamp. Can anyone clarify: * How to create a Hive table in this case and what to provide as "hbase.columns.mapping" property as the columns themselves are dynamic? * How to modify the HBase or Hive table schema to be able to query for given timestamp since it doesn't seem to be supported based on the HBase integration wiki: "there is currently no way to access the HBase timestamp attribute, and queries always access data with the latest timestamp." Thanks!