Querying Hive Table created using Complex AVRO Schema

[#1]

Hi All,

I am storing AVRO Data into HDFS whose schemas are complex ( With lots of nested Complex Types).

I am able to create the Hive Table without any Issues and when i run the Hive Query to describe the tables the Column data types (Struct) is getting displayed as expected.

How ever when i query for the column of a record type i am getting null as response even though there is data.

We are using HDP3.1

Thanks

Sateesh

[#2]

Hi @sateesh kommineni!
Could you share with us your avro schema and a sample of the data which you're trying to read?

[#3]

Never mind i am able to query and get the response back. The date being referenced has some avro files which are are conforming to the schema.