No result after Downsampling

Hello Influxdata Community,

I tried downsampling in our new Influxdb instance wherein data are being written by prometheus . However when I execute a select query which involves the new RP, I cannot see any output.

Here’s the list of commands that I executed:

  1. CREATE RETENTION POLICY “sample” ON “prometheus” DURATION 2h REPLICATION 1 DEFAULT

  2. CREATE RETENTION POLICY “a_year_f64” ON “prometheus” DURATION 52w REPLICATION 1

  3. CREATE CONTINUOUS QUERY “cq_30m_f64” ON “prometheus” BEGIN SELECT mean(“f64”) AS “mean_f64” INTO “a_year_f64”.“downsampled_orders” FROM “sample”."_" GROUP BY time(30m), * END

show field keys
name: _
fieldKey fieldType


f64 float

show tag keys
name: _
tagKey


name
alertname
alertstate
asg
az
branch
cadvisorRevision
cadvisorVersion
cluster_identifier
code
collector
container_label_build_date
container_label_com_amazonaws_ecs_cluster
container_label_com_amazonaws_ecs_container_name
container_label_com_amazonaws_ecs_task_arn
container_label_com_amazonaws_ecs_task_definition_family
container_label_com_amazonaws_ecs_task_definition_version
container_label_license
container_label_name
container_label_vendor
cpu
dbinstance_identifier
device
dns
dockerVersion
domain
domainname
env
exported_job
exported_name
fstype
goversion
groupname
handler
hostname
id
image
instance
instance_id
interface
job
kernelVersion
load_balancer
machine
memtype
method
mode
mountpoint
name
nodename
osVersion
plugin_id
private_ip
quantile
release
revision
role
scope
service
severity
state
subnet_id
sysname
system
tag
target_group
tcp_state
type
udp_state
version
vpc_id

  1. select * from “sample”."" limit 1
    {
    “results”: [
    {
    “series”: [
    {
    “name”: "
    ",
    “columns”: [
    “time”,
    name”,
    “alertname”,
    “alertstate”,
    “asg”,
    “az”,
    “branch”,
    “cadvisorRevision”,
    “cadvisorVersion”,
    “cluster_identifier”,
    “code”,
    “collector”,
    “container_label_build_date”,
    “container_label_com_amazonaws_ecs_cluster”,
    “container_label_com_amazonaws_ecs_container_name”,
    “container_label_com_amazonaws_ecs_task_arn”,
    “container_label_com_amazonaws_ecs_task_definition_family”,
    “container_label_com_amazonaws_ecs_task_definition_version”,
    “container_label_license”,
    “container_label_name”,
    “container_label_vendor”,
    “cpu”,
    “datid”,
    “datname”,
    “dbinstance_identifier”,
    “device”,
    “dns”,
    “dockerVersion”,
    “domain”,
    “domainname”,
    “env”,
    “exported_job”,
    “exported_name”,
    “f64”,
    “filename”,
    “fstype”,
    “goversion”,
    “groupname”,
    “handler”,
    “hashsum”,
    “hostname”,
    “id”,
    “image”,
    “instance”,
    “instance_id”,
    “interface”,
    “job”,
    “kernelVersion”,
    “load_balancer”,
    “machine”,
    “memtype”,
    “method”,
    “mode”,
    “mountpoint”,
    “name”,
    “nodename”,
    “osVersion”,
    “plugin_id”,
    “private_ip”,
    “quantile”,
    “release”,
    “relname”,
    “revision”,
    “role”,
    “schemaname”,
    “scope”,
    “service”,
    “severity”,
    “short_version”,
    “state”,
    “subnet_id”,
    “sysname”,
    “system”,
    “tag”,
    “target_group”,
    “tcp_state”,
    “type”,
    “udp_state”,
    “version”,
    “vpc_id”
    ],
    “values”: [
    [
    I REMOVED THE VALUES
    ]
    ]
    }
    ]
    }
    ]
    }

select * from “a_year_f64”.“downsampled_orders” limit 1
{
“results”: [
{}
]
}

Please help me with this one. Thank you in Advance for the help!

SHould I use tag keys or field keys?