[
https://issues.apache.org/jira/browse/TRAFODION-1920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15268927#comment-15268927
]
ASF GitHub Bot commented on TRAFODION-1920:
-------------------------------------------
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 <ming....@esgyn.cn>
Date: 2016-05-03T15:48:03Z
[TRAFODION-1920] suppress SQL error during HIVE_SCAN when conv error
----
> suppress SQL error during HIVE_SCAN when encounter invalid value, assign null
> to the invalid value
> --------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-1920
> URL: https://issues.apache.org/jira/browse/TRAFODION-1920
> Project: Apache Trafodion
> Issue Type: Sub-task
> Reporter: liu ming
> Assignee: liu ming
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
