Show retention policies issue

#1

show retention policies on 787f6b59f6584addab3bc7e1be7fb0f9;
ERR: error parsing query: found 787f6b59f6584addab3bc7e1be7fb0f9, expected identifier at line 1, char 28

show retention policies on MY_TEST_ORCH_UUID11;
name duration shardGroupDuration replicaN default


autogen 0s 168h0m0s 1 true

am I doing anything wrong ?

#2

Hi @aditya ,

the command expects a database to start with a non numeric character ,
if you place quotes around it it will work …

> show retention policies on 787f6b59f6584addab3bc7e1be7fb0f9
ERR: error parsing query: found 787f6b59f6584addab3bc7e1be7fb0f9, expected identifier at line 1, char 28
>
> show retention policies on "787f6b59f6584addab3bc7e1be7fb0f9"
ERR: database not found: 787f6b59f6584addab3bc7e1be7fb0f9
>
#3

@MarcV Thanks… It worked.