Hive3 detailed tutorial (II) basic use of hive3

Miss Zhu 2022-02-13 08:38:55 阅读数:294

hive3 hive detailed tutorial ii

In the last article , Launched the hive client , It can be like MySQL The use of Hive 了 .
view the database , Using a database :
 Insert picture description here
Create a table :
 Insert picture description here
Insert a piece of data , Will execute a mapreduce, Therefore, it is generally not recommended insert、update、delete operation :
 Insert picture description here
Inquire about :
 Insert picture description here
Insert into Hive Data in , Can be in HDFS View in :
 Insert picture description here

because Hive As a data bin , Data is stored in the underlying HDFS in , Its operation on data should be converted into MapReduce Conduct , Therefore, it is not good at adding, deleting and modifying small and scattered data , So for insert、update、delete Not recommended .
Follow up Hive In the use , We will use the import method to load the data into Hive in .

copyright:author[Miss Zhu],Please bring the original link to reprint, thank you. https://en.javamana.com/2022/02/202202130838527613.html