PREHOOK: query: DESCRIBE FUNCTION elt PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION elt POSTHOOK: type: DESCFUNCTION elt(n, str1, str2, ...) - returns the n-th string PREHOOK: query: DESCRIBE FUNCTION EXTENDED elt PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION EXTENDED elt POSTHOOK: type: DESCFUNCTION elt(n, str1, str2, ...) - returns the n-th string Example: > SELECT elt(1, 'face', 'book') FROM src LIMIT 1; 'face' PREHOOK: query: EXPLAIN SELECT elt(2, 'abc', 'defg'), elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'), elt('1', 'abc', 'defg'), elt(2, 'aa', CAST('2' AS TINYINT)), elt(2, 'aa', CAST('12345' AS SMALLINT)), elt(2, 'aa', CAST('123456789012' AS BIGINT)), elt(2, 'aa', CAST(1.25 AS FLOAT)), elt(2, 'aa', CAST(16.0 AS DOUBLE)), elt(null, 'abc', 'defg'), elt(0, 'abc', 'defg'), elt(3, 'abc', 'defg') FROM src tablesample (1 rows) PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT elt(2, 'abc', 'defg'), elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'), elt('1', 'abc', 'defg'), elt(2, 'aa', CAST('2' AS TINYINT)), elt(2, 'aa', CAST('12345' AS SMALLINT)), elt(2, 'aa', CAST('123456789012' AS BIGINT)), elt(2, 'aa', CAST(1.25 AS FLOAT)), elt(2, 'aa', CAST(16.0 AS DOUBLE)), elt(null, 'abc', 'defg'), elt(0, 'abc', 'defg'), elt(3, 'abc', 'defg') FROM src tablesample (1 rows) POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-0 is a root stage STAGE PLANS: Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: TableScan alias: src Row Limit Per Split: 1 Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE Select Operator expressions: 'defg' (type: string), 'cc' (type: string), 'abc' (type: string), '2' (type: string), '12345' (type: string), '123456789012' (type: string), '1.25' (type: string), '16.0' (type: string), elt(null, 'abc', 'defg') (type: string), null (type: void), null (type: void) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10 Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE ListSink PREHOOK: query: SELECT elt(2, 'abc', 'defg'), elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'), elt('1', 'abc', 'defg'), elt(2, 'aa', CAST('2' AS TINYINT)), elt(2, 'aa', CAST('12345' AS SMALLINT)), elt(2, 'aa', CAST('123456789012' AS BIGINT)), elt(2, 'aa', CAST(1.25 AS FLOAT)), elt(2, 'aa', CAST(16.0 AS DOUBLE)), elt(null, 'abc', 'defg'), elt(0, 'abc', 'defg'), elt(3, 'abc', 'defg') FROM src tablesample (1 rows) PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: SELECT elt(2, 'abc', 'defg'), elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'), elt('1', 'abc', 'defg'), elt(2, 'aa', CAST('2' AS TINYINT)), elt(2, 'aa', CAST('12345' AS SMALLINT)), elt(2, 'aa', CAST('123456789012' AS BIGINT)), elt(2, 'aa', CAST(1.25 AS FLOAT)), elt(2, 'aa', CAST(16.0 AS DOUBLE)), elt(null, 'abc', 'defg'), elt(0, 'abc', 'defg'), elt(3, 'abc', 'defg') FROM src tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### defg cc abc 2 12345 123456789012 1.25 16.0 NULL NULL NULL