Terradata SQL Vs Hive QL
- Sql is a database however hive is not a database.
- Sql is used for OLTP hive is used for OLAP.
- Sql is used for insert updates and deletes however hive is efficient for batch processing.
Name | Hive | Teradata |
---|---|---|
Description | Data warehouse software for querying and managing large distributed datasets, built on Hadoop |
DBMS mainly used for data warehousing |
Developer | Apache Software Foundation | Teradata |
Initial release | 2012 | 1979 |
Server operating systems | All OS with a Java VM | Linux |
APIs and other access methods | JDBC,ODBC,Thrift | .NET Client API, JDBC, JMS Adapter, ODBC OLE DB |
Server-side scripts | Yes | Yes |
Concurrency | Yes | Yes |
User concepts | Access rights for users, groups and roles | Fine grained access rights according to SQL-standard |
License | Open source | Commercial |
![terradata sql](https://cdn.wikitechy.com/interview-questions/hive/terradata-sql.png)