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

# · text · 26 lines · 18 code · 8 blank · 0 comment · 0 complexity · 69a17a4df4dcb4726db3d146de778bb8 MD5 · raw file

  1. desc function str_to_map;
  2. desc function extended str_to_map;
  3. explain select str_to_map('a=1,b=2,c=3',',','=')['a'] from src limit 3;
  4. select str_to_map('a=1,b=2,c=3',',','=')['a'] from src limit 3;
  5. explain select str_to_map('a:1,b:2,c:3') from src limit 3;
  6. select str_to_map('a:1,b:2,c:3') from src limit 3;
  7. explain select str_to_map('a:1,b:2,c:3',',',':') from src limit 3;
  8. select str_to_map('a:1,b:2,c:3',',',':') from src limit 3;
  9. explain select str_to_map(t.ss,',',':')['a']
  10. from (select transform('a:1,b:2,c:3') using 'cat' as (ss) from src) t
  11. limit 3;
  12. select str_to_map(t.ss,',',':')['a']
  13. from (select transform('a:1,b:2,c:3') using 'cat' as (ss) from src) t
  14. limit 3;
  15. drop table tbl_s2m;
  16. create table tbl_s2m as select 'ABC=CC_333=444' as t from src limit 3;
  17. select str_to_map(t,'_','=')['333'] from tbl_s2m;
  18. drop table tbl_s2m;