Muestra las diferencias entre dos versiones de la página.
| Ambos lados, revisión anterior Revisión previa Próxima revisión | Revisión previa | ||
|
wiki2:hadoop:ecosystem [2019/05/08 12:02] alfred [Hive] |
wiki2:hadoop:ecosystem [2020/05/09 09:25] (actual) |
||
|---|---|---|---|
| Línea 93: | Línea 93: | ||
| The nice thing about Sqoop is that we can automatically load our relational data from MySQL into HDFS, while preserving the structure. | The nice thing about Sqoop is that we can automatically load our relational data from MySQL into HDFS, while preserving the structure. | ||
| + | |||
| + | Hive and Impala also allow you to create a schema for the HDFS files using ''CREATE EXTERNAL TABLE'' commands. However Sqoop does that authomatically. | ||
| ===== Notes ===== | ===== Notes ===== | ||
| * **Cloudbase** is a group of tools already pre-installed on a Linux distribution to make easier the use of Hadoop technologies. | * **Cloudbase** is a group of tools already pre-installed on a Linux distribution to make easier the use of Hadoop technologies. | ||
| * {{ :wiki2:hadoop:traditional_etl_vs_elt_on_hadoop.pdf |ETL and ELT}} | * {{ :wiki2:hadoop:traditional_etl_vs_elt_on_hadoop.pdf |ETL and ELT}} | ||