Hive必会SQL语法Explode 和 Lateral View
复制hive (default)> select explode(array(A,B,C)); OK A B C Time taken: 4.188 seconds, Fetched: 3 row(s) hive (default)> select explode(map(a, 1, b, 2, c, 3)); OK key value a 1 b 2 c 3 1.2.3.4.5.6.7.8.9.10.11.12.13.
复制hive (default)> select explode(array(A,B,C)); OK A B C Time taken: 4.188 seconds, Fetched: 3 row(s) hive (default)> select explode(map(a, 1, b, 2, c, 3)); OK key value a 1 b 2 c 3 1.2.3.4.5.6.7.8.9.10.11.12.13.