10class.mql 879 B

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  1. create class if not exists /test() with namespace="test"
  2. ;
  3. delete from /test/double with version
  4. /**
  5. onerror(continue,`not exist`,`not find`,`not found`)
  6. **/
  7. ;
  8. drop class if exists /test/double
  9. ;
  10. create class if not exists /test/double (
  11. vid bigint,
  12. vd0 double,
  13. vd1 double,
  14. vd2 double,
  15. vd3 double,
  16. vd4 double,
  17. vd5 double,
  18. vd6 double,
  19. vd7 double,
  20. vd8 double,
  21. vd9 double,
  22. xd0 double,
  23. xd1 double,
  24. xd2 double,
  25. xd3 double,
  26. xd4 double,
  27. xd5 double,
  28. xd6 double,
  29. xd7 double,
  30. xd8 double,
  31. xd9 double,
  32. indexes(vd0, vd1, vd2, vd3, vd4, vd5, vd6, vd7, vd8, vd9),
  33. keys(vid)
  34. ) with core=cassandraonly;
  35. cql: select * from field where namespace='test' and name in ('vd1','xd1','vd9','xd9')
  36. /**
  37. match("name", "vd1", "isindex", 1)
  38. match("name", "xd1", "isindex", 0)
  39. match("name", "vd9", "isindex", 1)
  40. match("name", "xd9", "isindex", 0)
  41. **/
  42. ;