sql on hadoop vs Flex Zone

Rodrigo_Merino_1

Hi all,

I have read the new SQL on Hadoop datasheet. But I am not able to see the technical details how it works. So my question is,... what is the difference between the new "SQL on Hadoop" versus the already existing "FlexZone"?

Thanks and best regards,
Rodrigo.

eli_revach

Hi ,
One of the major differences is regarding where your data to be exists , SQL on Hadoop provide you Hive like interface on top of Hadoop data , you will be able to run SQL queries on top of your HDFS external file system  so you will be able to use your existing BI tool on top of Hadoop data store  , on the other hand  in  Flex zone   the data is store on your Vertica  cluster  ,  of course there are many other capability’s that   Flex zone    provide that I not mention .

[Deleted User]

Thanks Eli.

If I may expand on this a bit:  FlexZone is about *how* your data is stored.  SQL on Hadoop is about *where* your data is stored.

FlexZone is about working with differently-structured data.  Hierarchical JSON files, map-structured data, CSV's where you don't know the content up front, etc.

SQL on Hadoop is about working with data that's stored in HDFS, or is otherwise accessible via Hadoop.  That data is often very well structured, with a well-known structure.  It's just stored in HDFS.

It's entirely possible to put a Flex table on Hadoop (via an HDFS storage location or an external table).  In some situations this can be very useful.

Adam