Description
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.