Hive parquet vs Vertica vs Impala

2015-01-03 Thread Shashidhar Rao
Hi, Can someone help me with insights into Hive with parquet vs Vertica comparison. I need to store large xml data into one these database so please help me with query performance. Is Impala opensource and can we use it without Cloudera license. Thanks Shashi

Re: Hive parquet vs Vertica vs Impala

2015-01-03 Thread Shashidhar Rao
Imapa > 2) Write your data using using an Parquet (to handle nested objects ) and > Hive to query it.(Hopefully then when Impala adds collection support you > can switch over. > > But mostly you need to do more research. > > Edward > > On Sat, Jan 3, 2015 at 2:15 PM, S

Re: Hive parquet vs Vertica vs Impala

2015-01-03 Thread Shashidhar Rao
nse for Impala is included here: > https://github.com/cloudera/Impala/blob/master/LICENSE.txt > > Edward > > > On Sat, Jan 3, 2015 at 3:29 PM, Shashidhar Rao > wrote: > >> Edward, >> >> Thanks for your reply. >> Can you please tell me the query performanc

Re: Hive parquet vs Vertica vs Impala

2015-01-04 Thread Shashidhar Rao
queries faster some Vertical will query faster. > > Basically hive and vertica are very different even though they are both > considered data warehouses. > > On Sat, Jan 3, 2015 at 4:30 PM, Shashidhar Rao > wrote: > >> Sorry Edward, I mentioned that I didn't have acc