Re: Nested types in ORC

2014-09-09 Thread Abhishek Agarwal
s point, schema 2 will make you enable predicate pushdown. The > performance difference depends mainly on the data layout/if column is > sorted or not. > > Thanks > Prasanth Jayachandran > > On Sep 8, 2014, at 6:16 AM, Abhishek Agarwal wrote: > > Hi all, > I have few ques

Nested types in ORC

2014-09-08 Thread Abhishek Agarwal
access nested columns? In general, is there a significant performance difference in following schemas with regards to query execution and storage? Schema1: { string a; struct b { string b1; string b2; } } Schema 2: { string a; string b.b1; string b.b2; } -- Regards, Abhishek Agarwal

Re: Using Parquet and Thrift in Hive

2014-07-25 Thread Abhishek Agarwal
+ Re-sending as delivery of earlier mail failed. On Fri, Jul 25, 2014 at 5:14 PM, Abhishek Agarwal wrote: > Hi All, > Is it possible to create a table with Parquet as storage mechanism, with > schema being supplied from thrift IDL rather than metastore? > > Something like be