adspace


What kind of data warehouse application is suitable for Hive? What are the types of tables in Hive?

Answer Posted / Mukesh Dahiya

"Apache Hive can be used with a variety of data warehousing applications. It is best suited for working with large datasets and performing SQL-like queries on them. In Hive, there are two types of tables: Managed Tables (stored in HDFS) and External Tables (pointing to existing data outside the Hive warehouse)."n

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I delete the above index named index_bonuspay?

807


How to skip header rows from a table in Hive?

907


What is the stable version of Hive ?

2696


Where does the data of a Hive table gets stored?

750


What are the different types of tables available in Hive?

767


When to choose "External Table" in Hive?

867


What is a Hive variable? What for we use it?

881


When we are using queries instead of scripting?

801


When to use explode in Hive?

832


Can We Change settings within Hive Session? If Yes, How?

859