I have an AVRO schema which works and querries fine on HIVE, but when we query the same on Impala it thorws an error saying "Your query has the following error(s): Could not connect to <HOST NAME>:21050" Which is weird and i dont see any log information on Hue as i am able to browse other tables that are defined on TEXT format within same database. we are on impala-2.1.3+cdh5.3.3+0 One thing which looks wired on my schema when i decsribe it on Impala is it has the first row as NULL like below and i am not sure why! My AVRO schema file is defined like below: Its just sample and all the fields are defined as STRING { "namespace": "HDFS", "name": "sample", "type": "record", "fields":[{"name":"recipient_identification_number", "type":"string"}, {"name":"validation_digit", "type":"string"}, {"name":"eligibility_status_code", "type":"string"}, {"name":"recipient_last_name", "type":"string"}, {"name":"recipient_first_name", "type":"string"}, {"name":"recipient_middle_name", "type":"string"}, {"name":"recipient_name_appel", "type":"string"}, {"name":"recipient_dob", "type":"string"}, {"name":"recipient_ssn", "type":"string"}, {"name":"recipient_ssn_prefix", "type":"string"}, {"name":"recipient_race_code", "type":"string"}, PS: Not sure why my pics have these wired color.
... View more
