常用查询场景

带分区键和排序键的查询(注意字符串类型需要用单引号)

  1. SELECT * from t_rpa_run_report
  2. WHERE pk = 1
  3. AND sk >= '1653407796054'
  4. AND sk <= '1653407808560'

全局二级索引的查询(表名和索引名要用双引号)

  • taskStartTime-taskId-index 全局二级索引
  • taskStartTime 分区键
  • taskId 排序键
  1. SELECT *
  2. FROM "t_rpa_run_report"."taskStartTime-taskId-index"
  3. WHERE taskStartTime >= 1653407796054
  4. AND taskStartTime <= 1653407808369
  5. AND taskId = 1;