elasticsearch query all

CREATE TABLE Students (course varchar), Stu_name varchar (TEN), City varchar (ten), score int INSERT into students values (' math ', ' Jack ', ' Tianjin ', ' n '), insert into students values (' math ', ' Jordan ', ' Tianjin ', 80); INSERT into students values (' math ', ' James ', ' Beijing ', ' n '), insert into students values (' English ', ' Jack ', ' Tianjin ', ' n '); insert into students values (' English ', ' Jordan ', ' Tianjin ', max), insert into students values (' English ', ' James

Create a Custom Function:1 DELIMITER $$2 3 Use ' dressv_website ' $$4 5 DROP FUNCTION IF EXISTS ' fn_queryrelation ' $$6 7CREATE definer= ' sa ' @ '% ' FUNCTION ' fn_queryrelation ' (Areaid int,relation TINYINT (1)) RETURNS VARCHAR (4000) CHARSET UTF88 BEGIN9DECLARE stemp VARCHAR (4000);TenDECLARE Stempchd VARCHAR (4000); OneSET stemp ='$'; ASET Stempchd =CAST (Areaid as CHAR); -IF relation=0 Then - While stempchd are not NULL does theSET stemp = CONCAT (Stemp,',', stempchd); -SELECT Group_conca