[jira] [Created] (IMPALA-8335) Avro support requires all lowercase fields

["Herman Chen (JIRA)" <ji...@apache.org>]

Herman Chen created IMPALA-8335:
-----------------------------------

             Summary: Avro support requires all lowercase fields
                 Key: IMPALA-8335
                 URL: https://issues.apache.org/jira/browse/IMPALA-8335
             Project: IMPALA
          Issue Type: Question
          Components: Catalog, Docs
            Reporter: Herman Chen


I am using external tables where the data resides in S3 in avro format. My avdl contains fields such as:
    string id;
    string sql;
    string templateId;
    union \{ null, string } pool;
    union \{ null, string } user;
    string startTime;
    string endTime;

However, Impala is able to read the all-lowerfields like "id" and "sql", but for any field containing uppercase like "templateId" or "startTime", Impala shows them all as NULL. I believe this is due to how Impala treats all identifier as lowercase, including column name. Is it so? Is there any way to work around it? If not it poses a major roadblock for working with pre-existing avro data.



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