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:
-
CREATE RETENTION POLICY “sample” ON “prometheus” DURATION 2h REPLICATION 1 DEFAULT
-
CREATE RETENTION POLICY “a_year_f64” ON “prometheus” DURATION 52w REPLICATION 1
-
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
-
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!