[jira] [Commented] (TRAFODION-1920) suppress SQL error during HIVE_SCAN when encounter invalid value, assign null to the invalid value

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-1920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15265806#comment-15265806 ] 

ASF GitHub Bot commented on TRAFODION-1920:
-------------------------------------------

Github user anoopsharma00 commented on a diff in the pull request:

    https://github.com/apache/incubator-trafodion/pull/441#discussion_r61689151
  
    --- Diff: core/sql/exp/exp_eval.cpp ---
    @@ -862,7 +862,17 @@ ex_expr::exp_return_type ex_expr::evalClauses(ex_clause *clause,
     	atp1->setDiagsArea(diagsArea);
     
           if (retcode == ex_expr::EXPR_ERROR)
    -	return retcode;
    +      {
    +        if((getPCodeMode() & ex_expr::ERROR_CONTINUE) > 0)
    +        {
    +          ExpTupleDesc::setNullValue( op_data[0],
    +                                      clause->getOperand(0)->getNullBitIndex(),
    +                                      clause->getOperand(0)->getTupleFormat() );
    +          retcode = ex_expr::EXPR_OK;
    --- End diff --
    
    -- this code also will return back from line #871 on the first conversion clause error instead
       of continuing to the next clause.
    -- it will also not work correctly if getPCodeMode() is not  set.



> 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)