/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/udf_find_in_set.q

# · text · 23 lines · 19 code · 4 blank · 0 comment · 0 complexity · e79a9381626b612710d69d98c370535b MD5 · raw file 

    

  1. DESCRIBE FUNCTION find_in_set;
    2. 

  2. DESCRIBE FUNCTION EXTENDED find_in_set; 
    3. 

  3. 

  4. EXPLAIN
    5. 

  5. FROM src1 SELECT find_in_set(src1.key,concat(src1.key,',',src1.value));
    6. 

  6. 

  7. FROM src1 SELECT find_in_set(src1.key,concat(src1.key,',',src1.value));
    8. 

  8. 

  9. SELECT find_in_set('ab','ab,abc,abcde') FROM src1 LIMIT 1;
    10. 

  10. SELECT find_in_set('ab','abc,ab,bbb') FROM src1 LIMIT 1;
    11. 

  11. SELECT find_in_set('ab','def,abc,ab') FROM src1 LIMIT 1;
    12. 

  12. SELECT find_in_set('ab','abc,abd,abf') FROM src1 LIMIT 1;
    13. 

  13. SELECT find_in_set(null,'a,b,c') FROM src1 LIMIT 1;
    14. 

  14. SELECT find_in_set('a',null) FROM src1 LIMIT 1;
    15. 

  15. SELECT find_in_set('', '') FROM src1 LIMIT 1;
    16. 

  16. SELECT find_in_set('',',') FROM src1 LIMIT 1;
    17. 

  17. SELECT find_in_set('','a,,b') FROM src1 LIMIT 1;
    18. 

  18. SELECT find_in_set('','a,b,') FROM src1 LIMIT 1;
    19. 

  19. SELECT find_in_set(',','a,b,d,') FROM src1 LIMIT 1;
    20. 

  20. SELECT find_in_set('a','') FROM src1 LIMIT 1;
    21. 

  21. SELECT find_in_set('a,','a,b,c,d') FROM src1 LIMIT 1;
    22. 

  22. 

  23. SELECT * FROM src1 WHERE NOT find_in_set(key,'311,128,345,2,956')=0;
    24.