Database Reference
In-Depth Information
| 0 | 0 |
| 1 | 1395214708049 |
| 5 | 1395214754874 |
| 3 | 1395214731135 |
+-------+---------------+
The value 0 refers to the table's oldest available version. Table history is
retained for 7 days so this version is that old unless the table was created
more recently.
$
bq head ch11.time_lapse@0
+-------+--------+
| index | millis |
+-------+--------+
| 0 | 0 |
+-------+--------+
The previous examples refer to the table as it existed at a particular point
in time. You can also reference the set of changes that occurred in a specific
time interval. For example, to see all the rows added, you could use:
$
bq head ch11.time_lapse@$((${START_TIME} + 6 * 10 *
1000))
-
+-------+---------------+
| index | millis |
+-------+---------------+
| 8 | 1395214790355 |
| 9 | 1395214802060 |
| 7 | 1395214778642 |
| 10 | 1395214814200 |
+-------+---------------+
The trailing hyphen indicates that the upper bound for the time interval
should be the current time. Again, adding a leading hyphen causes the value
to be treated as an offset with respect to the current time.
$
date +%s; bq head ch11.time_lapse@-850000
-
1395215622
+-------+---------------+
