gistfile1.txt

> show measurements;
name: measurements
name
----
"rob"
one_week.listen_count

> show retention policies;
name            duration        shardGroupDuration      replicaN        default
----            --------        ------------------      --------        -------
autogen         0s              168h0m0s                1               true
one_week        1h0m0s          1h0m0s                  1               false

> select count(*) from "\"rob\"";
name: "rob"
time    count_artist_msid       count_artist_name       count_recording_mbid    count_recording_msid    count_track_name
----    -----------------       -----------------       --------------------    --------------------    ----------------
0       4199                    4199                    2386                    4199                    4199

> select * from one_week.listen_count;
> select * from "\"one_week.listen_count\"";
> select * from "one_week"."listen_count";
> select * from "\"one_week\""."\"listen_count\"";
ERR: retention policy not found: "one_week"
> select * from one_week."\"listen_count\"";