11data.mql 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117
  1. insert into /test/bucketlog (id, bklog['file1.log']) values ('linux:wecise', [
  2. "1-1--DEBUG [CompactionExecutor:584] 2020-06-25 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  3. 1-2--DEBUG [CompactionExecutor:583] 2020-06-25 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  4. 1-3--DEBUG [CompactionExecutor:584] 2020-06-25 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  5. 1-4--DEBUG [CompactionExecutor:583] 2020-06-25 00:49:59,666 TimeWindowCompactionStrategy.java:117 - TWCS expired check sufficiently far in the past, checking for fully expired SSTables
  6. 1-5--DEBUG [CompactionExecutor:583] 2020-06-25 00:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  7. 1-6--DEBUG [CompactionExecutor:583] 2020-06-25 00:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  8. 1-7--WARN [Native-Transport-Requests-1] 2020-06-25 00:50:01,043 SelectStatement.java:429 - Aggregation query used without partition key
  9. 1-8--WARN [Native-Transport-Requests-1] 2020-06-25 00:50:04,072 SelectStatement.java:429 - Aggregation query used without partition key
  10. 1-9--INFO [Thread-3] 2020-06-25 00:50:08,837 IndexMatrixSchema.java:143 - [object] No need to add fields
  11. 1-10--INFO [Thread-8] 2020-06-25 00:50:08,840 IndexMatrixSchema.java:143 - [vobject] No need to add fields"])
  12. ;
  13. insert into /test/bucketlog2 (id, bklog2['file1.log']) values ('linux:wecise2', [
  14. "1-1--DEBUG [CompactionExecutor:584] 2020-06-25 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  15. 1-2--DEBUG [CompactionExecutor:583] 2020-06-25 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  16. 1-3--DEBUG [CompactionExecutor:584] 2020-06-25 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  17. 1-4--DEBUG [CompactionExecutor:583] 2020-06-25 00:49:59,666 TimeWindowCompactionStrategy.java:117 - TWCS expired check sufficiently far in the past, checking for fully expired SSTables
  18. 1-5--DEBUG [CompactionExecutor:583] 2020-06-25 00:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  19. 1-6--DEBUG [CompactionExecutor:583] 2020-06-25 00:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  20. 1-7--WARN [Native-Transport-Requests-1] 2020-06-25 00:50:01,043 SelectStatement.java:429 - Aggregation query used without partition key
  21. 1-8--WARN [Native-Transport-Requests-1] 2020-06-25 00:50:04,072 SelectStatement.java:429 - Aggregation query used without partition key
  22. 1-9--INFO [Thread-3] 2020-06-25 00:50:08,837 IndexMatrixSchema.java:143 - [object] No need to add fields
  23. 1-10--INFO [Thread-8] 2020-06-25 00:50:08,840 IndexMatrixSchema.java:143 - [vobject] No need to add fields"])
  24. ;
  25. insert into /test/bucketlog (id, bklog['file1.log']) values ('linux:wecise', ["1-1--DEBUG [CompactionExecutor:584] 2020-07-25 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables", "1-2--DEBUG [CompactionExecutor:583] 2020-07-25 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables", "1-3--DEBUG [CompactionExecutor:584] 2020-07-25 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables", "1-4--DEBUG [CompactionExecutor:583] 2020-07-25 00:49:59,666 TimeWindowCompactionStrategy.java:117 - TWCS expired check sufficiently far in the past, checking for fully expired SSTables", "1-5--DEBUG [CompactionExecutor:583] 2020-07-25 00:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables", "1-6--DEBUG [CompactionExecutor:583] 2020-07-25 00:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables", "1-7--WARN [Native-Transport-Requests-1] 2020-07-25 00:50:01,043 SelectStatement.java:429 - Aggregation query used without partition key", "1-8--WARN [Native-Transport-Requests-1] 2020-07-25 00:50:04,072 SelectStatement.java:429 - Aggregation query used without partition key", "1-9--INFO [Thread-3] 2020-07-25 00:50:08,837 IndexMatrixSchema.java:143 - [object] No need to add fields", "1-10--INFO [Thread-8] 2020-07-25 00:50:08,840 IndexMatrixSchema.java:143 - [vobject] No need to add fields"])
  26. ;
  27. insert into /test/bucketlog (id, bklog[?]) values (?, ?)
  28. /**
  29. params("file1.log", "linux:wecise", ["1-1--DEBUG [CompactionExecutor:584] 2020-09-25 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables", "1-2--DEBUG [CompactionExecutor:583] 2020-09-25 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables", "1-3--DEBUG [CompactionExecutor:584] 2020-09-25 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables", "1-4--DEBUG [CompactionExecutor:583] 2020-09-25 00:49:59,666 TimeWindowCompactionStrategy.java:117 - TWCS expired check sufficiently far in the past, checking for fully expired SSTables", "1-5--DEBUG [CompactionExecutor:583] 2020-09-25 00:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables", "1-6--DEBUG [CompactionExecutor:583] 2020-09-25 00:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables", "1-7--WARN [Native-Transport-Requests-1] 2020-09-25 00:50:01,043 SelectStatement.java:429 - Aggregation query used without partition key", "1-8--WARN [Native-Transport-Requests-1] 2020-09-25 00:50:04,072 SelectStatement.java:429 - Aggregation query used without partition key", "1-9--INFO [Thread-3] 2020-09-25 00:50:08,837 IndexMatrixSchema.java:143 - [object] No need to add fields", "1-10--INFO [Thread-8] 2020-09-25 00:50:08,840 IndexMatrixSchema.java:143 - [vobject] No need to add fields"])
  30. **/
  31. ;
  32. insert into /test/bucketlog (id, bklog[?]) values (?, ?)
  33. /**
  34. params("file1.log", "linux:wecise",
  35. `1-1--DEBUG [CompactionExecutor:584] 2020-11-25 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  36. 1-2--DEBUG [CompactionExecutor:583] 2020-11-25 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  37. 1-3--DEBUG [CompactionExecutor:584] 2020-11-25 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  38. 1-4--DEBUG [CompactionExecutor:583] 2020-11-25 00:49:59,666 TimeWindowCompactionStrategy.java:117 - TWCS expired check sufficiently far in the past, checking for fully expired SSTables
  39. 1-5--DEBUG [CompactionExecutor:583] 2020-11-25 00:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  40. 1-6--DEBUG [CompactionExecutor:583] 2020-11-25 00:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  41. 1-7--WARN [Native-Transport-Requests-1] 2020-11-25 00:50:01,043 SelectStatement.java:429 - Aggregation query used without partition key
  42. 1-8--WARN [Native-Transport-Requests-1] 2020-11-25 00:50:04,072 SelectStatement.java:429 - Aggregation query used without partition key
  43. 1-9--INFO [Thread-3] 2020-11-25 00:50:08,837 IndexMatrixSchema.java:143 - [object] No need to add fields
  44. 1-10--INFO [Thread-8] 2020-11-25 00:50:08,840 IndexMatrixSchema.java:143 - [vobject] No need to add fields`
  45. )
  46. **/
  47. ;
  48. insert into /test/bucketlog (id, bklog['file1.log','file1.log','file1.log']) values ('linux:wecise', [["1-1--DEBUG [CompactionExecutor:584] 2020-06-25 01:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  49. 1-2--DEBUG [CompactionExecutor:583] 2020-06-25 01:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  50. 1-3--DEBUG [CompactionExecutor:584] 2020-06-25 01:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  51. 1-4--DEBUG [CompactionExecutor:583] 2020-06-25 01:49:59,666 TimeWindowCompactionStrategy.java:117 - TWCS expired check sufficiently far in the past, checking for fully expired SSTables
  52. 1-5--DEBUG [CompactionExecutor:583] 2020-06-25 01:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  53. 1-6--DEBUG [CompactionExecutor:583] 2020-06-25 01:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  54. 1-7--WARN [Native-Transport-Requests-1] 2020-06-25 01:50:01,043 SelectStatement.java:429 - Aggregation query used without partition key
  55. 1-8--WARN [Native-Transport-Requests-1] 2020-06-25 01:50:04,072 SelectStatement.java:429 - Aggregation query used without partition key
  56. 1-9--INFO [Thread-3] 2020-06-25 01:50:08,837 IndexMatrixSchema.java:143 - [object] No need to add fields
  57. 1-10--INFO [Thread-8] 2020-06-25 01:50:08,840 IndexMatrixSchema.java:143 - [vobject] No need to add fields"], ["1-1--DEBUG [CompactionExecutor:584] 2020-06-25 02:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  58. 1-2--DEBUG [CompactionExecutor:583] 2020-06-25 02:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  59. 1-3--DEBUG [CompactionExecutor:584] 2020-06-25 02:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  60. 1-4--DEBUG [CompactionExecutor:583] 2020-06-25 02:49:59,666 TimeWindowCompactionStrategy.java:117 - TWCS expired check sufficiently far in the past, checking for fully expired SSTables
  61. 1-5--DEBUG [CompactionExecutor:583] 2020-06-25 02:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  62. 1-6--DEBUG [CompactionExecutor:583] 2020-06-25 02:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  63. 1-7--WARN [Native-Transport-Requests-1] 2020-06-25 02:50:01,043 SelectStatement.java:429 - Aggregation query used without partition key
  64. 1-8--WARN [Native-Transport-Requests-1] 2020-06-25 02:50:04,072 SelectStatement.java:429 - Aggregation query used without partition key
  65. 1-9--INFO [Thread-3] 2020-06-25 02:50:08,837 IndexMatrixSchema.java:143 - [object] No need to add fields
  66. 1-10--INFO [Thread-8] 2020-06-25 02:50:08,840 IndexMatrixSchema.java:143 - [vobject] No need to add fields"], ["1-1--DEBUG [CompactionExecutor:584] 2020-06-25 03:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  67. 1-2--DEBUG [CompactionExecutor:583] 2020-06-25 03:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  68. 1-3--DEBUG [CompactionExecutor:584] 2020-06-25 03:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  69. 1-4--DEBUG [CompactionExecutor:583] 2020-06-25 03:49:59,666 TimeWindowCompactionStrategy.java:117 - TWCS expired check sufficiently far in the past, checking for fully expired SSTables
  70. 1-5--DEBUG [CompactionExecutor:583] 2020-06-25 03:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  71. 1-6--DEBUG [CompactionExecutor:583] 2020-06-25 03:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  72. 1-7--WARN [Native-Transport-Requests-1] 2020-06-25 03:50:01,043 SelectStatement.java:429 - Aggregation query used without partition key
  73. 1-8--WARN [Native-Transport-Requests-1] 2020-06-25 03:50:04,072 SelectStatement.java:429 - Aggregation query used without partition key
  74. 1-9--INFO [Thread-3] 2020-06-25 03:50:08,837 IndexMatrixSchema.java:143 - [object] No need to add fields
  75. 1-10--INFO [Thread-8] 2020-06-25 03:50:08,840 IndexMatrixSchema.java:143 - [vobject] No need to add fields"]])
  76. ;
  77. insert into /test/bucketlog (id, bklog['file1.log','file1.log','file1.log']) values ('linux:wecise', [["1-1--DEBUG [CompactionExecutor:584] 2020-06-26 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  78. 1-2--DEBUG [CompactionExecutor:583] 2020-06-26 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  79. 1-3--DEBUG [CompactionExecutor:584] 2020-06-26 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  80. 1-4--DEBUG [CompactionExecutor:583] 2020-06-26 00:49:59,666 TimeWindowCompactionStrategy.java:117 - TWCS expired check sufficiently far in the past, checking for fully expired SSTables
  81. 1-5--DEBUG [CompactionExecutor:583] 2020-06-26 00:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  82. 1-6--DEBUG [CompactionExecutor:583] 2020-06-26 00:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  83. 1-7--WARN [Native-Transport-Requests-1] 2020-06-26 00:50:01,043 SelectStatement.java:429 - Aggregation query used without partition key
  84. 1-8--WARN [Native-Transport-Requests-1] 2020-06-26 00:50:04,072 SelectStatement.java:429 - Aggregation query used without partition key
  85. 1-9--INFO [Thread-3] 2020-06-26 00:50:08,837 IndexMatrixSchema.java:143 - [object] No need to add fields
  86. 1-10--INFO [Thread-8] 2020-06-26 00:50:08,840 IndexMatrixSchema.java:143 - [vobject] No need to add fields"], ["1-1--DEBUG [CompactionExecutor:584] 2020-06-27 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  87. 1-2--DEBUG [CompactionExecutor:583] 2020-06-27 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  88. 1-3--DEBUG [CompactionExecutor:584] 2020-06-27 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  89. 1-4--DEBUG [CompactionExecutor:583] 2020-06-27 00:49:59,666 TimeWindowCompactionStrategy.java:117 - TWCS expired check sufficiently far in the past, checking for fully expired SSTables
  90. 1-5--DEBUG [CompactionExecutor:583] 2020-06-27 00:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  91. 1-6--DEBUG [CompactionExecutor:583] 2020-06-27 00:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  92. 1-7--WARN [Native-Transport-Requests-1] 2020-06-27 00:50:01,043 SelectStatement.java:429 - Aggregation query used without partition key
  93. 1-8--WARN [Native-Transport-Requests-1] 2020-06-27 00:50:04,072 SelectStatement.java:429 - Aggregation query used without partition key
  94. 1-9--INFO [Thread-3] 2020-06-27 00:50:08,837 IndexMatrixSchema.java:143 - [object] No need to add fields
  95. 1-10--INFO [Thread-8] 2020-06-27 00:50:08,840 IndexMatrixSchema.java:143 - [vobject] No need to add fields"],["1-1--DEBUG [CompactionExecutor:584] 2020-06-28 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  96. 1-2--DEBUG [CompactionExecutor:583] 2020-06-28 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  97. 1-3--DEBUG [CompactionExecutor:584] 2020-06-28 00:49:59,666 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  98. 1-4--DEBUG [CompactionExecutor:583] 2020-06-28 00:49:59,666 TimeWindowCompactionStrategy.java:117 - TWCS expired check sufficiently far in the past, checking for fully expired SSTables
  99. 1-5--DEBUG [CompactionExecutor:583] 2020-06-28 00:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  100. 1-6--DEBUG [CompactionExecutor:583] 2020-06-28 00:49:59,667 TimeWindowCompactionStrategy.java:124 - TWCS skipping check for fully expired SSTables
  101. 1-7--WARN [Native-Transport-Requests-1] 2020-06-28 00:50:01,043 SelectStatement.java:429 - Aggregation query used without partition key
  102. 1-8--WARN [Native-Transport-Requests-1] 2020-06-28 00:50:04,072 SelectStatement.java:429 - Aggregation query used without partition key
  103. 1-9--INFO [Thread-3] 2020-06-28 00:50:08,837 IndexMatrixSchema.java:143 - [object] No need to add fields
  104. 1-10--INFO [Thread-8] 2020-06-28 00:50:08,840 IndexMatrixSchema.java:143 - [vobject] No need to add fields"]])
  105. ;
  106. /**
  107. sleep(1s)
  108. **/
  109. ;