Support Questions

Find answers, ask questions, and share your expertise

Querying Hive Table created using Complex AVRO Schema

Explorer

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 REPLIES 2

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

Explorer

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.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.