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

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

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