[TRAFODION-1911] A special mode to be more tolerant during bulkloading and accessing HDFS raw data

• Type: Umbrella
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0-incubating
• Assignee: liu ming
• Reporter: liu ming
• Created: 30/Mar/16 01:43
• Updated: 15/Sep/18 07:31
• Resolved: 29/Jun/16 12:56

Description

Raw data in HDFS sometimes are not well formatted or contains bad values. Trafodion bulkloader will complain error or not work well by default once that is the case.
It will be valuable to let Trafodion work in a special mode to tolerate bad raw data in the HDFS. A not completed list below:

1. Automatically remove ‘\r’ when it is used as ‘\r\n’ the DOS format line delimiter.
2. Donot raise SQL error, but convert bad data into null automatically, and still be able to log this into error log files when required, don’t make this change silent, and make this action traceable.
3. Allow ‘\n’ in data field even ‘\n’ is the line terminator
4. Auto truncate overflowed string, log it into the error log file, in order to make it traceable.
5. Tolerate ‘\0’ in source data

There may be more, this is an umbrella JIRA to track all related sub tasks.

Sub-Tasks

• support automatic convert DOS format during bulkload: Closed
• suppress SQL error during HIVE_SCAN when encounter invalid value, assign null to the invalid value: Closed