Server version: 8.0.16 MySQL Community Server - GPL                                                                                  

| customerid  | num_doc     | fecha_eeff | patrimonio   | primer_valor | segundo_valor | patrimonio_avg      |
+-------------+-------------+------------+--------------+--------------+---------------+---------------------+
| -2147483648 | -2147483648 |   20081231 |            0 |            0 |             0 |                   0 |
| -2147483648 | -2147483648 |   20091231 |            0 |            0 |             0 |                   0 |
| -2147483648 | -2147483648 |   20101231 | -26.71346658 |            0 |  -26.71346658 |        -13.35673329 |
| -2147483648 | -2147483648 |   20111231 |  25.20101545 | -26.71346658 |   25.20101545 | -0.7562255649999994 |
| -2147483648 | -2147483648 |   20121231 |            0 |  25.20101545 |             0 |        12.600507725 |
| -2147483648 | -2147483648 |   20131231 |            0 |            0 |             0 |                   0 |
| -2147483648 | -2147483648 |   20141231 |            0 |            0 |             0 |                   0 |
| -2147483648 | -2147483648 |   20151231 |  640.7372572 |            0 |   640.7372572 |         320.3686286 |
| -2147483648 | -2147483648 |   20160630 | -725.6532577 |  640.7372572 |  -725.6532577 |        -42.45800025 |
| -2147483648 | -2147483648 |   20160930 | -618.0659668 | -725.6532577 |  -618.0659668 |       -671.85961225 |
| -2147483648 | -2147483648 |   20161231 | -736.5709632 | -618.0659668 |  -736.5709632 |  -677.3184650000001 |
| -2147483648 | -2147483648 |   20170630 |  89.46417653 | -736.5709632 |   89.46417653 |      -323.553393335 |
| -2147483648 | -2147483648 |   20171231 |            0 |  89.46417653 |             0 |        44.732088265 |
| -2147483648 | -2147483648 |   20180630 |            0 |            0 |             0 |                   0 |
| -2147483648 | -2147483648 |   20180930 |            0 |            0 |             0 |                   0 |
| -2147483648 | -2147483648 |   20181231 |            0 |            0 |             0 |                   0 |
+-------------+-------------+------------+--------------+--------------+---------------+---------------------+                                                                            

psql (9.3.24)

 customerid  |   num_doc   | fecha_eeff |  patrimonio  | primer_valor | segundo_valor |   patrimonio_avg
-------------+-------------+------------+--------------+--------------+---------------+--------------------
 -2147483648 | -2147483648 |   20091231 |              |              |               |
 -2147483648 | -2147483648 |   20101231 | -26.71346658 |              |  -26.71346658 |       -26.71346658
 -2147483648 | -2147483648 |   20111231 |  25.20101545 | -26.71346658 |   25.20101545 | -0.756225564999999
 -2147483648 | -2147483648 |   20121231 |     Infinity |  25.20101545 |      Infinity |           Infinity
 -2147483648 | -2147483648 |   20131231 |          NaN |     Infinity |           NaN |                NaN
 -2147483648 | -2147483648 |   20141231 |    -Infinity |          NaN |     -Infinity |                NaN
 -2147483648 | -2147483648 |   20151231 |  640.7372572 |    -Infinity |   640.7372572 |          -Infinity
 -2147483648 | -2147483648 |   20160630 | -725.6532577 |  640.7372572 |  -725.6532577 |       -42.45800025
 -2147483648 | -2147483648 |   20160930 | -618.0659668 | -725.6532577 |  -618.0659668 |      -671.85961225
 -2147483648 | -2147483648 |   20161231 | -736.5709632 | -618.0659668 |  -736.5709632 |        -677.318465
 -2147483648 | -2147483648 |   20170630 |  89.46417653 | -736.5709632 |   89.46417653 |     -323.553393335
 -2147483648 | -2147483648 |   20171231 |     Infinity |  89.46417653 |      Infinity |           Infinity
 -2147483648 | -2147483648 |   20180630 |          NaN |     Infinity |           NaN |                NaN
 -2147483648 | -2147483648 |   20180930 |    -Infinity |          NaN |     -Infinity |                NaN
 -2147483648 | -2147483648 |   20181231 |          NaN |    -Infinity |           NaN |                NaN

Hive

+--------------+--------------+-------------+---------------+---------------+----------------+----------------------+--+
|  customerid  |   num_doc    | fecha_eeff  |  patrimonio   | primer_valor  | segundo_valor  |    patrimonio_avg    |
+--------------+--------------+-------------+---------------+---------------+----------------+----------------------+--+
| -2147483648  | -2147483648  | 20081231    | NULL          | NULL          | NULL           | NULL                 |
| -2147483648  | -2147483648  | 20091231    | NULL          | NULL          | NULL           | NULL                 |
| -2147483648  | -2147483648  | 20101231    | -26.71346658  | NULL          | -26.71346658   | -26.71346658         |
| -2147483648  | -2147483648  | 20111231    | 25.20101545   | -26.71346658  | 25.20101545    | -0.7562255649999994  |
| -2147483648  | -2147483648  | 20121231    | NULL          | 25.20101545   | NULL           | 25.20101545          |
| -2147483648  | -2147483648  | 20131231    | NULL          | NULL          | NULL           | NaN                  |
| -2147483648  | -2147483648  | 20141231    | NULL          | NULL          | NULL           | NaN                  |
| -2147483648  | -2147483648  | 20151231    | 640.7372572   | NULL          | 640.7372572    | 640.7372572          |
| -2147483648  | -2147483648  | 20160630    | -725.6532577  | 640.7372572   | -725.6532577   | -42.45800025000002   |
| -2147483648  | -2147483648  | 20160930    | -618.0659668  | -725.6532577  | -618.0659668   | -671.85961225        |
| -2147483648  | -2147483648  | 20161231    | -736.5709632  | -618.0659668  | -736.5709632   | -677.3184650000001   |
| -2147483648  | -2147483648  | 20170630    | 89.46417653   | -736.5709632  | 89.46417653    | -323.553393335       |
| -2147483648  | -2147483648  | 20171231    | NULL          | 89.46417653   | NULL           | 89.46417653000003    |
| -2147483648  | -2147483648  | 20180630    | NULL          | NULL          | NULL           | NaN                  |
| -2147483648  | -2147483648  | 20180930    | NULL          | NULL          | NULL           | NaN                  |
| -2147483648  | -2147483648  | 20181231    | NULL          | NULL          | NULL           | NaN                  |
+--------------+--------------+-------------+---------------+---------------+----------------+----------------------+--+