PREHOOK: query: DESCRIBE FUNCTION least PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION least POSTHOOK: type: DESCFUNCTION least(v1, v2, ...) - Returns the least value in a list of values PREHOOK: query: DESCRIBE FUNCTION EXTENDED least PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION EXTENDED least POSTHOOK: type: DESCFUNCTION least(v1, v2, ...) - Returns the least value in a list of values Example: > SELECT least(2, 3, 1) FROM src LIMIT 1; 1 PREHOOK: query: EXPLAIN SELECT LEAST('a', 'b', 'c'), LEAST('C', 'a', 'B'), LEAST('AAA', 'AaA', 'AAa'), LEAST('A', 'AA', 'AAA'), LEAST('11', '13', '12'), LEAST('11', '2', '12'), LEAST('01', '03', '02'), LEAST('01', '1', '02'), LEAST(null, 'b', 'c' ), LEAST('a', null, 'c'), LEAST('a', 'b', null ), LEAST('a', null, null), LEAST(null, 'b', null), LEAST(cast(null as string), null, null) FROM src tablesample (1 rows) PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT LEAST('a', 'b', 'c'), LEAST('C', 'a', 'B'), LEAST('AAA', 'AaA', 'AAa'), LEAST('A', 'AA', 'AAA'), LEAST('11', '13', '12'), LEAST('11', '2', '12'), LEAST('01', '03', '02'), LEAST('01', '1', '02'), LEAST(null, 'b', 'c' ), LEAST('a', null, 'c'), LEAST('a', 'b', null ), LEAST('a', null, null), LEAST(null, 'b', null), LEAST(cast(null as string), null, null) 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: 'a' (type: string), 'B' (type: string), 'AAA' (type: string), 'A' (type: string), '11' (type: string), '11' (type: string), '01' (type: string), '01' (type: string), least(null,'b','c') (type: string), least('a',null,'c') (type: string), least('a','b',null) (type: string), least('a',null,null) (type: string), least(null,'b',null) (type: string), least(UDFToString(null),null,null) (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13 Statistics: Num rows: 500 Data size: 597500 Basic stats: COMPLETE Column stats: COMPLETE ListSink PREHOOK: query: SELECT LEAST('a', 'b', 'c'), LEAST('C', 'a', 'B'), LEAST('AAA', 'AaA', 'AAa'), LEAST('A', 'AA', 'AAA'), LEAST('11', '13', '12'), LEAST('11', '2', '12'), LEAST('01', '03', '02'), LEAST('01', '1', '02'), LEAST(null, 'b', 'c' ), LEAST('a', null, 'c'), LEAST('a', 'b', null ), LEAST('a', null, null), LEAST(null, 'b', null), LEAST(cast(null as string), null, null) FROM src tablesample (1 rows) PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: SELECT LEAST('a', 'b', 'c'), LEAST('C', 'a', 'B'), LEAST('AAA', 'AaA', 'AAa'), LEAST('A', 'AA', 'AAA'), LEAST('11', '13', '12'), LEAST('11', '2', '12'), LEAST('01', '03', '02'), LEAST('01', '1', '02'), LEAST(null, 'b', 'c' ), LEAST('a', null, 'c'), LEAST('a', 'b', null ), LEAST('a', null, null), LEAST(null, 'b', null), LEAST(cast(null as string), null, null) FROM src tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### a B AAA A 11 11 01 01 b a a a b NULL PREHOOK: query: SELECT LEAST(11, 13, 12), LEAST(1, 13, 2), LEAST(-11, -13, -12), LEAST(1, -13, 2), LEAST(null, 1, 2), LEAST(1, null, 2), LEAST(1, 2, null), LEAST(cast(null as int), null, null) FROM src tablesample (1 rows) PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: SELECT LEAST(11, 13, 12), LEAST(1, 13, 2), LEAST(-11, -13, -12), LEAST(1, -13, 2), LEAST(null, 1, 2), LEAST(1, null, 2), LEAST(1, 2, null), LEAST(cast(null as int), null, null) FROM src tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### 11 1 -13 -13 1 1 1 NULL PREHOOK: query: SELECT LEAST(11.4, 13.5, 12.2), LEAST(1.0, 13.2, 2.0), LEAST(-11.4, -13.1, -12.2), LEAST(1.0, -13.3, 2.2), LEAST(null, 1.1, 2.2), LEAST(1.1, null, 2.2), LEAST(1.1, 2.2, null), LEAST(cast(null as double), null, null) FROM src tablesample (1 rows) PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: SELECT LEAST(11.4, 13.5, 12.2), LEAST(1.0, 13.2, 2.0), LEAST(-11.4, -13.1, -12.2), LEAST(1.0, -13.3, 2.2), LEAST(null, 1.1, 2.2), LEAST(1.1, null, 2.2), LEAST(1.1, 2.2, null), LEAST(cast(null as double), null, null) FROM src tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### 11.4 1.0 -13.1 -13.3 1.1 1.1 1.1 NULL