GitHub user anoopsharma00 opened a pull request:
https://github.com/apache/incubator-trafodion/pull/555
JIRA TRAFODION-2084 Handling of invalid data inserts into hive tables
cqd hive_insert_error_mode '<val>' has been added to control
insert behavior.
if 0, datatype error check is not done during inserts into hive tables.
Invalid values may get inserted.
This is the behavior prior to this JIRA fix.
if 1, error check done, row is not inserted if conversion error.
Insertion stops. This is new default behavior.
if 2, error check done, row is not inserted if conversion error.
Insertion continues with next row
if 3, null inserted if conversion error.
Insertion processing continues. This is hive behavior.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/anoopsharma00/incubator-trafodion
ansharma_hiveinserr_br
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/555.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #555
----
commit 392c60889cb437e08e3718a3fc54c244cbfb123b
Author: Anoop Sharma <[email protected]>
Date: 2016-06-22T20:19:59Z
JIRA TRAFODION-2084 Handling of invalid data inserts into hive tables
cqd hive_insert_error_mode '<val>' has been added to control
insert behavior.
if 0, datatype error check is not done during inserts into hive tables.
Invalid values may get inserted.
This is the behavior prior to this JIRA fix.
if 1, error check done, row is not inserted if conversion error.
Insertion stops. This is new default behavior.
if 2, error check done, row is not inserted if conversion error.
Insertion continues with next row
if 3, null inserted if conversion error.
Insertion processing continues. This is hive behavior.
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
