Filtering for Data within a Time Range

The Simba HBase ODBC Driver allows you to filter for data that falls within a specific time range. The connector provides the following SQLCHAR statement properties for specifying the start and end of the time range:

  • HB_ATTR_STARTTIME_STR, which has an identifier of 40001, is used to specify the start of the time range.
  • HB_ATTR_ENDTIME_STR, which has an identifier of 40002, is used to specify the end of the time range.

By default, both attributes are set to NULL, so the connector does not limit the returned data based on a time range.

Set these attributes to NULL-terminated strings that can be converted to 64-bit integers representing timestamps in Unix time (the number of milliseconds since January 1st, 1970 UTC). When you query the database, data that falls outside the specified range is not returned.

Note:

For information about how to set statement attributes, see "SQLSetStmtAttr Function" in the ODBC API Reference: https://msdn.microsoft.com/en-us/library/ms712631(v=vs.85).aspx.