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