[jira] [Commented] (CARBONDATA-646) Bad record handling is not correct for Int data type

[Akash R Nilugal (Jira)]

    [ https://issues.apache.org/jira/browse/CARBONDATA-646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15825525#comment-15825525 ]

Ramakrishna commented on CARBONDATA-646:
----------------------------------------

same way this is not handled in Update query, giving in consistent data:

0: jdbc:hive2://172.168.100.212:23040> select * from t_carbn02;
+----------------+---------------+--------------+------------+--+
| active_status  | item_type_cd  | qty_day_avg  | qty_total  |
+----------------+---------------+--------------+------------+--+
| TRUE           | 0             | 1            | 2          |
+----------------+---------------+--------------+------------+--+
1 row selected (0.088 seconds)
0: jdbc:hive2://172.168.100.212:23040> update t_carbn02 set (item_type_cd) = (1.3);
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (5.528 seconds)
0: jdbc:hive2://172.168.100.212:23040> select * from t_carbn02;
+----------------+---------------+--------------+------------+--+
| active_status  | item_type_cd  | qty_day_avg  | qty_total  |
+----------------+---------------+--------------+------------+--+
| TRUE           | 1             | 1            | 2          |
+----------------+---------------+--------------+------------+--+
1 row selected (0.093 seconds)
0: jdbc:hive2://172.168.100.212:23040> update t_carbn02 set (item_type_cd) = (item_type_cd/2);
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (5.544 seconds)
0: jdbc:hive2://172.168.100.212:23040> select * from t_carbn02;
+----------------+---------------+--------------+------------+--+
| active_status  | item_type_cd  | qty_day_avg  | qty_total  |
+----------------+---------------+--------------+------------+--+
| TRUE           | 0             | 1            | 2          |
+----------------+---------------+--------------+------------+--+

> Bad record handling is not correct for Int data type
> ----------------------------------------------------
>
>                 Key: CARBONDATA-646
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-646
>             Project: CarbonData
>          Issue Type: Bug
>            Reporter: Ramakrishna
>            Priority: Minor
>
> With Bad record handling as default,
> If Char value is given for Int data type, that is handled properly(moving NULL).
> If Decimal values is given for Int Data type, it is stripping the decimal, where it should consider this as bad record and move NULL.
> Bad record csv:
> TRUE,2.7,423.0,A,200000000003454300, 121.5,4.99,2.44,SE3423ee,asfdsffdfg,EtryTRWT,2012-01-12 03:14:05.123456729,2012-01-20
> 0: jdbc:hive2://172.168.100.212:23040> select * from t_carbn01 where qty_total is NULL;
> +----------------+---------------+--------------+------------+---------------------+--------------+-----------------+---------+------------+-------------+--------------+------------------------+--------------+--+
> | active_status  | item_type_cd  | qty_day_avg  | qty_total  |     sell_price      | sell_pricep  | discount_price  | profit  | item_code  |  item_name  | outlet_name  |      update_time       | create_date  |
> +----------------+---------------+--------------+------------+---------------------+--------------+-----------------+---------+------------+-------------+--------------+------------------------+--------------+--+
> | TRUE           | 2             | 423          | NULL       | 200000000003454304  | 121.5        | 4.99            | 2.44    | SE3423ee   | asfdsffdfg  | EtryTRWT     | 2012-01-12 03:14:05.0  | 2012-01-20   |
> +----------------+---------------+--------------+------------+---------------------+--------------+-----------------+---------+------------+-------------+--------------+------------------------+----------
> 0: jdbc:hive2://172.168.100.212:23040> desc t_carbn01;
> +-----------------+---------------+----------+--+
> |    col_name     |   data_type   | comment  |
> +-----------------+---------------+----------+--+
> | active_status   | string        |          |
> | item_type_cd    | bigint        |          |
> | qty_day_avg     | bigint        |          |
> | qty_total       | bigint        |          |
> | sell_price      | bigint        |          |
> | sell_pricep     | double        |          |
> | discount_price  | double        |          |
> | profit          | decimal(3,2)  |          |
> | item_code       | string        |          |
> | item_name       | string        |          |
> | outlet_name     | string        |          |
> | update_time     | timestamp     |          |
> | create_date     | string        |          |
> +-----------------+---------------+----------+--+
>  

--
This message was sent by Atlassian JIRA
(v6.3.4#6332)