Re: Problem querying deeply nested data with Parquet and ORC File Hive SerDes

2014-04-04 Thread mpeterson2
I figured out the problem. The JSON SerDe I wrote is not case sensitive, but the ORC and Parquet SerDes are case sensitive. So this works: select ClientCode, Encounter.Number from parquet_tbl; but this does not: select clientcode, encounter.Number from parquet_tbl; -Michael On Thu, Apr 3, 2014

Problem querying deeply nested data with Parquet and ORC File Hive SerDes

2014-04-03 Thread mpeterson2
Hi, I'm new to using Parquet and ORC files and I'm hitting a problem with querying nested data. Can those files formats be used to query deeply nested data? If yes, why I am getting an error with the SerDes for both of them? Here's the background: I'm starting from a JSON data file like this: