hadoop vs teradata what is the difference

database hadoop teradata business-intelligence
John picture John · Jan 31, 2013 · Viewed 32.8k times · Source

I've touched a Teradata. I've never touched hadoop, but since yesterday, I am doing some research on that. By description of both, they seem quite interchangable, but in some papers it is written that they serve for different purposes. But all I found is vague. I am confused.

Has anybody experience with both of them? What is the serious difference between them?

Simple Example: I want to build ETL which will transform billions rows of raw data and organize them to DWH. Then do some resources expensive analysis on them. Why use TD? Why Hadoop? or why not?

Answer

ryanbwork picture ryanbwork · Apr 2, 2013

I think this article titled 'MapReduce and Parallel DBMSs: Friends or Foes' does quite a good job describing the situations where each technology works best. In a nutshell, Hadoop is excellent for storing unstructured data and running parallel transformations to 'sanitize' incoming data, where DBMSs excel at executing complex queries quickly.

Related questions

How do I output the results of a HiveQL query to CSV?

we would like to put the results of a Hive query to a CSV file. I thought the command should look like this: insert overwrite directory '/home/output.csv' select books from table; When I run it, it says …

Read More
data block size in HDFS, why 64MB?

The default data block size of HDFS/hadoop is 64MB. The block size in disk is generally 4KB. What does 64MB block size mean? ->Does it mean that the smallest unit of read from disk is 64MB? If …

Read More
What is meant by sparse data/ datastore/ database?

Have been reading up on Hadoop and HBase lately, and came across this term- HBase is an open-source, distributed, sparse, column-oriented store... What do they mean by sparse? Does it have something to do with a sparse matrix? I am …

Read More