select

Execute the specified query in the remote cache.

gfsh:/Customers>select * from /Customers

Row  Address  Name        Id
---  -------  ----        --
1    Pune     Vishal R    CUST10401
2    Tokyo    Yuki T      CUST34571
3    Oviedo   Fernando A  CUST13541
4    Delhi    V Ahmad     CUST17891
5    Karpen   Michael S   CUST96874

Class: data.Customer
Fetch size: 50, Limit: 1000
   Results: 5, Returned: 5/5
elapsed (msec): 6

gfsh:/Customers>select -show

select limit = 1000

gfsh:/Customers>select -l 3

gfsh:/Customers>select * from /Customers

Row  Address  Name        Id
---  -------  ----        --
1    Tokyo    Yuki T      CUST34571
2    Pune     Vishal R    CUST10401
3    Oviedo   Fernando A  CUST13541

Class: data.Customer
Fetch size: 50, Limit: 3
   Results: 3, Returned: 3/3
elapsed (msec): 4

Options are:

-show

Displays the select query limit value

-l

Sets the result set size limit

Using limit: The syntax is 'select ... from ... limit <limit>'. Note that gfsh automatically appends 'limit' to your select statement. Do not add your own limit clause.