ECL - Enterprise Control Language is designed to handle and manipulate immense datasets which make it a perfect language to solve big data problems. ECL can be used for both ETL (Extract, Transform, and Load) and querying data. ECL is a declarative language which allows processing big data without the need of a programmer being involved with details and in-depth imperative decisions.
ECL and SQL can both be used to query a relational database. Following is a table displaying similar features between ECL and SQL.
|Thor Cluster or Roxie Cluster
|An SQL Table
|An ECL Logical File
|An SQL Editor
|VSCode Editor or ECL Cloud IDE
|An SQL File
|An ECL File
|Executing SQL means submitting the written SQL to the Database Server which in turn compiles it and executes it
|Executing ECL means submitting the written ECL to a Thor or Roxie cluster which in turn compiles and executes it
|SQL Execution History/Logs
|ECL Workunits Database & ECL Watch Workunits View
Please refer to the ECL syntax to learn about ECL standards.