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

# · text · 18 lines · 13 code · 5 blank · 0 comment · 0 complexity · 4b64782d61da2f4464e3e41811bb70bf MD5 · raw file 

    

  1. DESCRIBE FUNCTION concat_ws;
    2. 

  2. DESCRIBE FUNCTION EXTENDED concat_ws;
    3. 

  3. 

  4. CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING);
    5. 

  5. 

  6. FROM src INSERT OVERWRITE TABLE dest1 SELECT 'abc', 'xyz', '8675309'  WHERE src.key = 86;
    7. 

  7. 

  8. EXPLAIN
    9. 

  9. SELECT concat_ws(dest1.c1, dest1.c2, dest1.c3),
    10. 

  10.        concat_ws(',', dest1.c1, dest1.c2, dest1.c3),
    11. 

  11.        concat_ws(NULL, dest1.c1, dest1.c2, dest1.c3),
    12. 

  12.        concat_ws('**', dest1.c1, NULL, dest1.c3) FROM dest1;
    13. 

  13. 

  14. SELECT concat_ws(dest1.c1, dest1.c2, dest1.c3),
    15. 

  15.        concat_ws(',', dest1.c1, dest1.c2, dest1.c3),
    16. 

  16.        concat_ws(NULL, dest1.c1, dest1.c2, dest1.c3),
    17. 

  17.        concat_ws('**', dest1.c1, NULL, dest1.c3) FROM dest1;
    18.