cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Different results between API Request and User sessions query web page

simeon
Newcomer

Hello,

I get different results executing the following query using REST API and User Session Query web page .

Here is the query:

  SELECT name, AVG(duration), COUNT(*), HOUR(startTime), DAY(starttime)
FROM useraction
WHERE startTime >   "10.07.2020" AND name="loading of page /orange.jsf"
GROUP BY name, HOUR(startTime), DAY(starttime)
ORDER BY DAY(starttime) ASC, HOUR(startTime) ASC
LIMIT 5000



Here is the result from REST API:

{
  "extrapolationLevel": 1,
  "columnNames": [
    "name",
    "avg(duration)",
    "count(*)",
    "hour(startTime)",
    "day(starttime)"
  ],
  "values": [
    [
      "loading of page /orange.jsf",
      2631.002283105023,
      438,
      10,
      17
    ],
    [
      "loading of page /orange.jsf",
      2644.2456896551726,
      232,
      11,
      17
    ]
  ]
}



Here is the result from User Session Query web page:



Results from User Session Query page are my the ones i expect to get from REST API.

However REST API returns only two records.


Any idea why ?

1 REPLY 1

ChadTurner
DynaMight Guru
DynaMight Guru

@Simeon V. are you still noticing this issue? What cluster version are you on? If you are on the latest Cluster Version and are still seeing a difference in data, then I would recommend tossing in a support ticket as this is a very odd behavior.

-Chad