| set hive.mapred.mode=nonstrict; |
| set hive.cbo.enable=false; |
| |
| DESCRIBE FUNCTION replicate_rows; |
| DESCRIBE FUNCTION EXTENDED replicate_rows; |
| |
| create table t_n13 (x bigint, y string, z int); |
| |
| insert into table t_n13 values (3,'2',0),(2,'3',1),(0,'2',2),(-1,'k',3); |
| |
| SELECT replicate_rows(x,y) FROM t_n13; |
| |
| SELECT replicate_rows(x,y,y) FROM t_n13; |
| |
| SELECT replicate_rows(x,y,y,y,z) FROM t_n13; |
| |
| select y,x from (SELECT replicate_rows(x,y) as (x,y) FROM t_n13)subq; |
| |
| select z,y,x from(SELECT replicate_rows(x,y,y) as (z,y,x) FROM t_n13)subq; |
| |
| SELECT replicate_rows(x,concat(y,'...'),y) FROM t_n13; |
| |
| |