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), round(1.0/0.0, 0), round(power(-1.0,0.5), 0) FROM src tablesample (1 rows) PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: SELECT round(null), round(null, 0), round(125, null), round(1.0/0.0, 0), round(power(-1.0,0.5), 0) FROM src tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### NULL NULL NULL NULL NaN 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 tablesample (1 rows) PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### 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 tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### 55555 55555 55555 55555 55555 55560 55600 56000 60000 100000 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 tablesample (1 rows) PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### 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 tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### 125.0 125.0 125.3 125.32 125.315 125.315 130.0 100.0 0.0 0.0 -125.0 -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 tablesample (1 rows) PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### 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 tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### 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), round(1809242.3151111344BD, 9), round(-1809242.3151111344BD, 9) FROM src tablesample (1 rows) PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: SELECT round(1809242.3151111344, 9), round(-1809242.3151111344, 9), round(1809242.3151111344BD, 9), round(-1809242.3151111344BD, 9) FROM src tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### 1809242.315111134 -1809242.315111134 1809242.315111134 -1809242.315111134