| set hive.fetch.task.conversion=more; | |
| DESCRIBE FUNCTION array; | |
| DESCRIBE FUNCTION EXTENDED array; | |
| EXPLAIN SELECT array(), array()[1], array(1, 2, 3), array(1, 2, 3)[2], array(1,"a", 2, 3), array(1,"a", 2, 3)[2], | |
| array(array(1), array(2), array(3), array(4))[1][0] FROM src tablesample (1 rows); | |
| SELECT array(), array()[1], array(1, 2, 3), array(1, 2, 3)[2], array(1,"a", 2, 3), array(1,"a", 2, 3)[2], | |
| array(array(1), array(2), array(3), array(4))[1][0] FROM src tablesample (1 rows); |