[ https://issues.apache.org/jira/browse/DRILL-7336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16905057#comment-16905057 ]
Bohdan Kazydub commented on DRILL-7336: --------------------------------------- This option works when casting empty string as some other type, i.e. {{CAST(columns[0] as INT)}}. The option's description is wrong. > `cast_empty_string_to_null` option doesn't work when text file has > 1 column > ----------------------------------------------------------------------------- > > Key: DRILL-7336 > URL: https://issues.apache.org/jira/browse/DRILL-7336 > Project: Apache Drill > Issue Type: Bug > Reporter: Denys Ordynskiy > Priority: Major > > *Description:* > 1 - create 2 nullable csv files with 1 and 2 columns: > _one_col.csv_ > {noformat} > 1 > 2 > 4 > {noformat} > _two_col.csv_ > {noformat} > 1,1 > 2, > ,3 > 4,4 > {noformat} > 2 - enable option: > {noformat} > alter system set `drill.exec.functions.cast_empty_string_to_null`=true; > {noformat} > 3 - query file with 1 column: > {noformat} > select columns[0] from dfs.tmp.`one_col.csv`; > {noformat} > | EXPR$0 | > | 1 | > | 2 | > | null | > | 4 | > 4 - query file with 2 columns: > {noformat} > select columns[0] from dfs.tmp.`two_col.csv`; > {noformat} > *Expected result:* > Table with NULL in the 3-rd row: > | EXPR$0 | > | 1 | > | 2 | > | null | > | 4 | > *Actual result:* > {color:#d04437}Drill returns an empty string in the 3-rd row:{color} > | EXPR$0 | > | 1 | > | 2 | > | | > | 4 | -- This message was sent by Atlassian JIRA (v7.6.14#76016)