Start a 12.1 server, create a user with bin/cli.sh user create user -p user -g deployer Download schema.proto, cache.json and script.sh to a folder and run the script. It will register the schema, create the cache, and populate it with sample data Query with http://localhost:11222/rest/v2/caches/players-shots?action=search&query=select%20COUNT(userId)%20FROM%20com.redhat.Shot%20s%20WHERE%20s.shotType%20=%20%27MISS%27

It is possible to obtain the right count by executing the query without the COUNT, using maxResults=1:   http://localhost:11222/rest/v2/caches/players-shots?action=search&query=select%20userId%20FROM%20com.redhat.Shot%20s%20WHERE%20s.shotType%20=%20%27MISS%27&max_results=1