常用查询场景
带分区键和排序键的查询(注意字符串类型需要用单引号)
SELECT * from t_rpa_run_report
WHERE pk = 1
AND sk >= '1653407796054'
AND sk <= '1653407808560'
全局二级索引的查询(表名和索引名要用双引号)
- taskStartTime-taskId-index 全局二级索引
- taskStartTime 分区键
- taskId 排序键
SELECT *
FROM "t_rpa_run_report"."taskStartTime-taskId-index"
WHERE taskStartTime >= 1653407796054
AND taskStartTime <= 1653407808369
AND taskId = 1;