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

Categorized in:

Tagged in:

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,