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: 500 Data size: 5312 Basic stats: COMPLETE 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: 500 Data size: 395500 Basic stats: COMPLETE 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