Clone
Anoop Sharma <anoop.sharma@esgyn.com>
committed
on 22 Jun 16
JIRA TRAFODION-2084 Handling of invalid data inserts into hive tables
cqd hive_insert_error_mode '<val>' has been added to control
insert be… Show more
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.

Show less

default + 5 more