| 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 |
| Function class:org.apache.hadoop.hive.ql.udf.UDFFindInSet |
| Function type:BUILTIN |
| PREHOOK: query: EXPLAIN |
| 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: EXPLAIN |
| 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 #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: src1 |
| Select Operator |
| expressions: find_in_set(key, concat(key, ',', value)) (type: int) |
| outputColumnNames: _col0 |
| 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 |