PREHOOK: query: DESCRIBE FUNCTION round
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION round
POSTHOOK: type: DESCFUNCTION
round(x[, d]) - round x to d decimal places
PREHOOK: query: DESCRIBE FUNCTION EXTENDED round
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED round
POSTHOOK: type: DESCFUNCTION
round(x[, d]) - round x to d decimal places
Example:
  > SELECT round(12.3456, 1) FROM src LIMIT 1;
  12.3'
PREHOOK: query: SELECT round(null), round(null, 0), round(125, null)
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1736987523/10000
POSTHOOK: query: SELECT round(null), round(null, 0), round(125, null)
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1736987523/10000
NULL	NULL	NULL
PREHOOK: query: SELECT
  round(55555), round(55555, 0), round(55555, 1), round(55555, 2), round(55555, 3),
  round(55555, -1), round(55555, -2), round(55555, -3), round(55555, -4),
  round(55555, -5), round(55555, -6), round(55555, -7), round(55555, -8)
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1549949974/10000
POSTHOOK: query: SELECT
  round(55555), round(55555, 0), round(55555, 1), round(55555, 2), round(55555, 3),
  round(55555, -1), round(55555, -2), round(55555, -3), round(55555, -4),
  round(55555, -5), round(55555, -6), round(55555, -7), round(55555, -8)
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1549949974/10000
55555	55555.0	55555.0	55555.0	55555.0	55560.0	55600.0	56000.0	60000.0	100000.0	0.0	0.0	0.0
PREHOOK: query: SELECT
  round(125.315), round(125.315, 0),
  round(125.315, 1), round(125.315, 2), round(125.315, 3), round(125.315, 4),
  round(125.315, -1), round(125.315, -2), round(125.315, -3), round(125.315, -4),
  round(-125.315), round(-125.315, 0),
  round(-125.315, 1), round(-125.315, 2), round(-125.315, 3), round(-125.315, 4),
  round(-125.315, -1), round(-125.315, -2), round(-125.315, -3), round(-125.315, -4)
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/148858111/10000
POSTHOOK: query: SELECT
  round(125.315), round(125.315, 0),
  round(125.315, 1), round(125.315, 2), round(125.315, 3), round(125.315, 4),
  round(125.315, -1), round(125.315, -2), round(125.315, -3), round(125.315, -4),
  round(-125.315), round(-125.315, 0),
  round(-125.315, 1), round(-125.315, 2), round(-125.315, 3), round(-125.315, 4),
  round(-125.315, -1), round(-125.315, -2), round(-125.315, -3), round(-125.315, -4)
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/148858111/10000
125	125.0	125.3	125.32	125.315	125.315	130.0	100.0	0.0	0.0	-125	-125.0	-125.3	-125.32	-125.315	-125.315	-130.0	-100.0	0.0	0.0
PREHOOK: query: SELECT
  round(3.141592653589793, -15), round(3.141592653589793, -16),
  round(3.141592653589793, -13), round(3.141592653589793, -14),
  round(3.141592653589793, -11), round(3.141592653589793, -12),
  round(3.141592653589793, -9), round(3.141592653589793, -10),
  round(3.141592653589793, -7), round(3.141592653589793, -8),
  round(3.141592653589793, -5), round(3.141592653589793, -6),
  round(3.141592653589793, -3), round(3.141592653589793, -4),
  round(3.141592653589793, -1), round(3.141592653589793, -2),
  round(3.141592653589793, 0), round(3.141592653589793, 1),
  round(3.141592653589793, 2), round(3.141592653589793, 3),
  round(3.141592653589793, 4), round(3.141592653589793, 5),
  round(3.141592653589793, 6), round(3.141592653589793, 7),
  round(3.141592653589793, 8), round(3.141592653589793, 9),
  round(3.141592653589793, 10), round(3.141592653589793, 11),
  round(3.141592653589793, 12), round(3.141592653589793, 13),
  round(3.141592653589793, 13), round(3.141592653589793, 14),
  round(3.141592653589793, 15), round(3.141592653589793, 16)
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/624837434/10000
POSTHOOK: query: SELECT
  round(3.141592653589793, -15), round(3.141592653589793, -16),
  round(3.141592653589793, -13), round(3.141592653589793, -14),
  round(3.141592653589793, -11), round(3.141592653589793, -12),
  round(3.141592653589793, -9), round(3.141592653589793, -10),
  round(3.141592653589793, -7), round(3.141592653589793, -8),
  round(3.141592653589793, -5), round(3.141592653589793, -6),
  round(3.141592653589793, -3), round(3.141592653589793, -4),
  round(3.141592653589793, -1), round(3.141592653589793, -2),
  round(3.141592653589793, 0), round(3.141592653589793, 1),
  round(3.141592653589793, 2), round(3.141592653589793, 3),
  round(3.141592653589793, 4), round(3.141592653589793, 5),
  round(3.141592653589793, 6), round(3.141592653589793, 7),
  round(3.141592653589793, 8), round(3.141592653589793, 9),
  round(3.141592653589793, 10), round(3.141592653589793, 11),
  round(3.141592653589793, 12), round(3.141592653589793, 13),
  round(3.141592653589793, 13), round(3.141592653589793, 14),
  round(3.141592653589793, 15), round(3.141592653589793, 16)
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/624837434/10000
0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	3.0	3.1	3.14	3.142	3.1416	3.14159	3.141593	3.1415927	3.14159265	3.141592654	3.1415926536	3.14159265359	3.14159265359	3.1415926535898	3.1415926535898	3.14159265358979	3.141592653589793	3.141592653589793
PREHOOK: query: SELECT round(1809242.3151111344, 9), round(-1809242.3151111344, 9)
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/599098185/10000
POSTHOOK: query: SELECT round(1809242.3151111344, 9), round(-1809242.3151111344, 9)
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/599098185/10000
1809242.315111134	-1809242.315111134