GitHub user traflm opened a pull request:
https://github.com/apache/incubator-trafodion/pull/461
[TRAFODION-1920] suppress SQL error during HIVE_SCAN when conv error
A new PR for JIRA 1920. When read from HDFS in HIVE_SCAN and encounter
invalid data, continue and set the offending data to null.
Latest implementation details:
In code gen of HIVE_SCAN, if the CQD HIVE_SCAN_SPECIAL_MODE is set to '2'.
Generate a CAST function setting a special flag. In that CAST codegen, it will
set runtime flag based on the special flag. This will create a special
ex_conv_clause.
Codegen also disable pCode in this mode.
At runtime, ex_conv_caluse::eval() will move null into target if convDoIt()
failed. And continue.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/traflm/incubator-trafodion TRAFODION-1920
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/461.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 #461
----
commit 67b89f8ad6c1dc0b30607d98d6e5a141a79ae3e2
Author: Liu Ming <[email protected]>
Date: 2016-05-03T15:48:03Z
[TRAFODION-1920] suppress SQL error during HIVE_SCAN when conv error
----
---
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.
---
