Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

sql on hadoop vs Flex Zone

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.

Comments

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

  • 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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.