You can translate the question and the replies:

VQL significance

Hi Why do we need VQL in Denodo as developer I am writing only SQLs to build views. how does Denodo converts SQL which has two different sources(teradata and Hive table) when connecting two diffrent sources with ANSI SQL how Denodo will push part of the sql to each source
user
06-08-2020 09:20:06 -0400

1 Answer

Hi, Denodo's Virtual DataPort can easily deal with a wide range of structured, semi-structured and unstructured data sources. The system allows easily importing each data source into the “virtual database”. Virtual DataPort uses a SQL-like language called Denodo VQL (Virtual Query Language) as Data Definition and Data Manipulation Language. VQL is used to create views that arbitrarily combine the data using operations such as selections, projections, unions, joins, groups, etc., thus creating unified views of the source data. The [“General Architecture”](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/general_architecture/general_architecture) section of the Virtual DataPort Administration Guide provides a general overview of the Virtual DataPort system architecture. Please refer to the [“Virtual DataPort Administration Guide”](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/index#virtual-dataport-administration-guide) and [“Virtual DataPort VQL Guide”](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/index#virtual-dataport-vql-guide) to know more about the fundamentals of the data integration solutions in Virtual DataPort. Hope this helps!
Denodo Team
07-08-2020 16:44:30 -0400
You must sign in to add an answer. If you do not have an account, you can register here