[jira] [Created] (DRILL-6171) Querying avro files returns null for not null values

["Engin Sozer (JIRA)" <ji...@apache.org>]

Engin Sozer created DRILL-6171:
----------------------------------

             Summary: Querying avro files returns null for not null values
                 Key: DRILL-6171
                 URL: https://issues.apache.org/jira/browse/DRILL-6171
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - Avro
    Affects Versions: 1.10.0
            Reporter: Engin Sozer


Querying an avro file with a select * statement results in incorrect results. For example:

We have a file (test.avro') with columns col1, col2, col3 and col4 for a total of 5000 rows. In the first 4000 rows, col3 is null. In the last 1000 rows, col3 is not null. The issue is that when we write;

 
{code:java}
select * from dfs.tmp.`test.avro`;
select col1, col2, col3 from dfs.tmp.`test.avro`;
{code}
col3 is returned null for all 5000 rows. If we write:
{code:java}
select col1, col2, COALESCE(col3, null) from dfs.tmp.`test.avro`;{code}
This returns the correct results. (col3 = null for first 4000 rows and col3= not null for the next 1000)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)