PREHOOK: query: DESCRIBE FUNCTION find_in_set
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION find_in_set
POSTHOOK: type: DESCFUNCTION
find_in_set(str,str_array) - Returns the first occurrence  of str in str_array where str_array is a comma-delimited string. Returns null if either argument is null. Returns 0 if the first argument has any commas.
PREHOOK: query: DESCRIBE FUNCTION EXTENDED find_in_set
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED find_in_set
POSTHOOK: type: DESCFUNCTION
find_in_set(str,str_array) - Returns the first occurrence  of str in str_array where str_array is a comma-delimited string. Returns null if either argument is null. Returns 0 if the first argument has any commas.
Example:
  > SELECT find_in_set('ab','abc,b,ab,c,def') FROM src LIMIT 1;
  3
  > SELECT * FROM src1 WHERE NOT find_in_set(key,'311,128,345,956')=0;
  311  val_311
  128
PREHOOK: query: EXPLAIN
FROM src1 SELECT find_in_set(src1.key,concat(src1.key,',',src1.value))
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
FROM src1 SELECT find_in_set(src1.key,concat(src1.key,',',src1.value))
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
  Stage-0 is a root stage

STAGE PLANS:
  Stage: Stage-0
    Fetch Operator
      limit: -1
      Processor Tree:
        TableScan
          alias: src1
          Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
          Select Operator
            expressions: find_in_set(key, concat(key, ',', value)) (type: int)
            outputColumnNames: _col0
            Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
            ListSink

PREHOOK: query: FROM src1 SELECT find_in_set(src1.key,concat(src1.key,',',src1.value))
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
#### A masked pattern was here ####
POSTHOOK: query: FROM src1 SELECT find_in_set(src1.key,concat(src1.key,',',src1.value))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
PREHOOK: query: SELECT find_in_set('ab','ab,abc,abcde') FROM src1 tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
#### A masked pattern was here ####
POSTHOOK: query: SELECT find_in_set('ab','ab,abc,abcde') FROM src1 tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
1
PREHOOK: query: SELECT find_in_set('ab','abc,ab,bbb') FROM src1 tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
#### A masked pattern was here ####
POSTHOOK: query: SELECT find_in_set('ab','abc,ab,bbb') FROM src1 tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
2
PREHOOK: query: SELECT find_in_set('ab','def,abc,ab') FROM src1 tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
#### A masked pattern was here ####
POSTHOOK: query: SELECT find_in_set('ab','def,abc,ab') FROM src1 tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
3
PREHOOK: query: SELECT find_in_set('ab','abc,abd,abf') FROM src1 tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
#### A masked pattern was here ####
POSTHOOK: query: SELECT find_in_set('ab','abc,abd,abf') FROM src1 tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
0
PREHOOK: query: SELECT find_in_set(null,'a,b,c') FROM src1 tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
#### A masked pattern was here ####
POSTHOOK: query: SELECT find_in_set(null,'a,b,c') FROM src1 tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
NULL
PREHOOK: query: SELECT find_in_set('a',null) FROM src1 tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
#### A masked pattern was here ####
POSTHOOK: query: SELECT find_in_set('a',null) FROM src1 tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
NULL
PREHOOK: query: SELECT find_in_set('', '') FROM src1 tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
#### A masked pattern was here ####
POSTHOOK: query: SELECT find_in_set('', '') FROM src1 tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
1
PREHOOK: query: SELECT find_in_set('',',') FROM src1 tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
#### A masked pattern was here ####
POSTHOOK: query: SELECT find_in_set('',',') FROM src1 tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
1
PREHOOK: query: SELECT find_in_set('','a,,b') FROM src1 tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
#### A masked pattern was here ####
POSTHOOK: query: SELECT find_in_set('','a,,b') FROM src1 tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
2
PREHOOK: query: SELECT find_in_set('','a,b,') FROM src1 tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
#### A masked pattern was here ####
POSTHOOK: query: SELECT find_in_set('','a,b,') FROM src1 tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
3
PREHOOK: query: SELECT find_in_set(',','a,b,d,') FROM src1 tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
#### A masked pattern was here ####
POSTHOOK: query: SELECT find_in_set(',','a,b,d,') FROM src1 tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
0
PREHOOK: query: SELECT find_in_set('a','') FROM src1 tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
#### A masked pattern was here ####
POSTHOOK: query: SELECT find_in_set('a','') FROM src1 tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
0
PREHOOK: query: SELECT find_in_set('a,','a,b,c,d') FROM src1 tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
#### A masked pattern was here ####
POSTHOOK: query: SELECT find_in_set('a,','a,b,c,d') FROM src1 tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
0
PREHOOK: query: SELECT * FROM src1 WHERE NOT find_in_set(key,'311,128,345,2,956')=0
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM src1 WHERE NOT find_in_set(key,'311,128,345,2,956')=0
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
311	val_311
128