{"id":475878,"date":"2023-08-09T07:24:43","date_gmt":"2023-08-09T07:24:43","guid":{"rendered":""},"modified":"2023-09-05T11:11:30","modified_gmt":"2023-09-05T11:11:30","slug":"apache-hive","status":"publish","type":"wiki","link":"https:\/\/oneproxy.pro\/kr\/wiki\/apache-hive\/","title":{"rendered":"\uc544\ud30c\uce58 \ud558\uc774\ube0c"},"content":{"rendered":"<p>Apache Hive\ub294 Apache Hadoop\uc744 \uae30\ubc18\uc73c\ub85c \uad6c\ucd95\ub41c \uc624\ud508 \uc18c\uc2a4 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc9d5 \ubc0f SQL \uc720\uc0ac \ucffc\ub9ac \uc5b8\uc5b4 \ub3c4\uad6c\uc785\ub2c8\ub2e4. Hadoop\uc758 \ubd84\uc0b0 \ud30c\uc77c \uc2dc\uc2a4\ud15c(HDFS)\uc5d0 \uc800\uc7a5\ub41c \ub300\uaddc\ubaa8 \ub370\uc774\ud130 \uc138\ud2b8\ub97c \uad00\ub9ac\ud558\uace0 \ucffc\ub9ac\ud558\uae30 \uc704\ud55c \uc0ac\uc6a9\uc790 \uce5c\ud654\uc801\uc778 \uc778\ud130\ud398\uc774\uc2a4\ub97c \uc81c\uacf5\ud558\uae30 \uc704\ud574 \uac1c\ubc1c\ub418\uc5c8\uc2b5\ub2c8\ub2e4. Hive\ub294 \ubd84\uc11d\uac00\uc640 \ub370\uc774\ud130 \uacfc\ud559\uc790\uac00 \ubcf5\uc7a1\ud55c \ubd84\uc11d \uc791\uc5c5\uc744 \ud6a8\uc728\uc801\uc73c\ub85c \uc218\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \uc9c0\uc6d0\ud558\ub294 Hadoop \uc5d0\ucf54\uc2dc\uc2a4\ud15c\uc758 \uc911\uc694\ud55c \uad6c\uc131 \uc694\uc18c\uc785\ub2c8\ub2e4.<\/p>\n<h2>Apache Hive\uc758 \uc720\ub798\uc640 \ucd5c\ucd08 \uc5b8\uae09\uc758 \uc5ed\uc0ac<\/h2>\n<p>Apache Hive\uc758 \uc2dc\uc791\uc740 Jeff Hammerbacher\uc640 Facebook\uc758 \ub370\uc774\ud130 \uc778\ud504\ub77c \ud300\uc774 \ucc98\uc74c \uad6c\uc0c1\ud55c 2007\ub144\uc73c\ub85c \uac70\uc2ac\ub7ec \uc62c\ub77c\uac11\ub2c8\ub2e4. Hadoop\uc758 \ubc29\ub300\ud55c \ub370\uc774\ud130 \uc138\ud2b8\uc640 \uc0c1\ud638 \uc791\uc6a9\ud558\uae30 \uc704\ud55c \uace0\uae09 \uc778\ud130\ud398\uc774\uc2a4\uc5d0 \ub300\ud55c \uc99d\uac00\ud558\ub294 \uc694\uad6c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574 \ub9cc\ub4e4\uc5b4\uc84c\uc2b5\ub2c8\ub2e4. Hammerbacher\uc758 \uc791\uc5c5\uc740 Hive\uc758 \uae30\ubc18\uc744 \ub9c8\ub828\ud588\uc73c\uba70, \uace7 Facebook\uc740 2008\ub144\uc5d0 \ud574\ub2f9 \ud504\ub85c\uc81d\ud2b8\ub97c Apache Software Foundation(ASF)\uc5d0 \ub118\uacbc\uc2b5\ub2c8\ub2e4. \uc774\ud6c4 \uc804 \uc138\uacc4\uc758 \ub2e4\uc591\ud55c \uac1c\ubc1c\uc790\uc640 \uc870\uc9c1\uc758 \uae30\uc5ec\ub85c \ubc88\uc131\ud558\ub294 \uc624\ud508 \uc18c\uc2a4 \ud504\ub85c\uc81d\ud2b8\ub85c \ube60\ub974\uac8c \ubc1c\uc804\ud588\uc2b5\ub2c8\ub2e4. .<\/p>\n<h2>Apache Hive\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \uc815\ubcf4: \uc8fc\uc81c \ud655\uc7a5<\/h2>\n<p>Apache Hive\ub294 HQL(Hive \ucffc\ub9ac \uc5b8\uc5b4)\ub85c \uc54c\ub824\uc9c4 SQL\uacfc \uc720\uc0ac\ud55c \ucffc\ub9ac\ub97c MapReduce \uc791\uc5c5\uc73c\ub85c \ubcc0\ud658\ud558\uc5ec \uc791\ub3d9\ud558\ubbc0\ub85c \uc0ac\uc6a9\uc790\ub294 \uc775\uc219\ud55c SQL \uad6c\ubb38\uc744 \ud1b5\ud574 Hadoop\uacfc \uc0c1\ud638 \uc791\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ucd94\uc0c1\ud654\ub294 \ubd84\uc0b0 \ucef4\ud4e8\ud305\uc758 \ubcf5\uc7a1\uc131\uc73c\ub85c\ubd80\ud130 \uc0ac\uc6a9\uc790\ub97c \ubcf4\ud638\ud558\uace0 \ub0ae\uc740 \uc218\uc900\uc758 MapReduce \ucf54\ub4dc\ub97c \uc791\uc131\ud558\uc9c0 \uc54a\uace0\ub3c4 \ubd84\uc11d \uc791\uc5c5\uc744 \uc218\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \ud574\uc90d\ub2c8\ub2e4.<\/p>\n<p>Apache Hive\uc758 \uc544\ud0a4\ud14d\ucc98\ub294 \uc138 \uac00\uc9c0 \uc8fc\uc694 \uad6c\uc131 \uc694\uc18c\ub85c \uad6c\uc131\ub429\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\n<p><strong>HiveQL<\/strong>: \uc0ac\uc6a9\uc790\uac00 \uc775\uc219\ud55c \ubc29\uc2dd\uc73c\ub85c \ub370\uc774\ud130 \uc870\uc791 \ubc0f \ubd84\uc11d \uc791\uc5c5\uc744 \ud45c\ud604\ud560 \uc218 \uc788\ub3c4\ub85d \ud558\ub294 SQL\uacfc \uc720\uc0ac\ud55c \uc5b8\uc5b4\uc778 Hive \ucffc\ub9ac \uc5b8\uc5b4\uc785\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\uba54\ud0c0\uc2a4\ud1a0\uc5b4<\/strong>: \ud14c\uc774\ube14 \uc2a4\ud0a4\ub9c8, \ud30c\ud2f0\uc158 \uc815\ubcf4, \uae30\ud0c0 \uba54\ud0c0\ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\ub294 \uba54\ud0c0\ub370\uc774\ud130 \uc800\uc7a5\uc18c\uc785\ub2c8\ub2e4. Apache Derby, MySQL, PostgreSQL\uacfc \uac19\uc740 \ub2e4\uc591\ud55c \uc2a4\ud1a0\ub9ac\uc9c0 \ubc31\uc5d4\ub4dc\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\uc2e4\ud589 \uc5d4\uc9c4<\/strong>: HiveQL \ucffc\ub9ac \ucc98\ub9ac\ub97c \ub2f4\ub2f9\ud569\ub2c8\ub2e4. \ucc98\uc74c\uc5d0 Hive\ub294 MapReduce\ub97c \uc2e4\ud589 \uc5d4\uc9c4\uc73c\ub85c \uc0ac\uc6a9\ud588\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 Hadoop\uc758 \ubc1c\uc804\uc73c\ub85c Tez \ubc0f Spark\uc640 \uac19\uc740 \ub2e4\ub978 \uc2e4\ud589 \uc5d4\uc9c4\uc774 \ud1b5\ud569\ub418\uc5b4 \ucffc\ub9ac \uc131\ub2a5\uc774 \ud06c\uac8c \ud5a5\uc0c1\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<\/li>\n<\/ol>\n<h2>Apache Hive\uc758 \ub0b4\ubd80 \uad6c\uc870: Apache Hive \uc791\ub3d9 \ubc29\uc2dd<\/h2>\n<p>\uc0ac\uc6a9\uc790\uac00 Hive\ub97c \ud1b5\ud574 \ucffc\ub9ac\ub97c \uc81c\ucd9c\ud558\uba74 \ub2e4\uc74c \ub2e8\uacc4\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\n<p><strong>\ud30c\uc2f1<\/strong>: \ucffc\ub9ac\uac00 \uad6c\ubb38 \ubd84\uc11d\ub418\uc5b4 AST(\ucd94\uc0c1 \uad6c\ubb38 \ud2b8\ub9ac)\ub85c \ubcc0\ud658\ub429\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\uc758\ubbf8\ub860\uc801 \ubd84\uc11d<\/strong>: AST\ub294 Metastore\uc5d0 \uc815\uc758\ub41c \uc2a4\ud0a4\ub9c8\uc758 \uc815\ud655\uc131\uacfc \uc900\uc218\ub97c \ubcf4\uc7a5\ud558\uae30 \uc704\ud574 \uac80\uc99d\ub429\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\ucffc\ub9ac \ucd5c\uc801\ud654<\/strong>: \ucffc\ub9ac \ucd5c\uc801\ud654 \ud504\ub85c\uadf8\ub7a8\uc740 \ub370\uc774\ud130 \ubd84\ud3ec, \uc0ac\uc6a9 \uac00\ub2a5\ud55c \ub9ac\uc18c\uc2a4 \ub4f1\uc758 \uc694\uc18c\ub97c \uace0\ub824\ud558\uc5ec \ucffc\ub9ac\uc5d0 \ub300\ud55c \ucd5c\uc801\uc758 \uc2e4\ud589 \uacc4\ud68d\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\uc2e4\ud589<\/strong>: MapReduce, Tez, Spark \ub4f1 \uc120\ud0dd\ub41c \uc2e4\ud589 \uc5d4\uc9c4\uc774 \ucd5c\uc801\ud654\ub41c \ucffc\ub9ac\ub97c \ucc98\ub9ac\ud558\uace0 \uc911\uac04 \ub370\uc774\ud130\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\ub9c8\ubb34\ub9ac<\/strong>: \ucd5c\uc885 \ucd9c\ub825\uc740 HDFS \ub610\ub294 \uc9c0\uc6d0\ub418\ub294 \ub2e4\ub978 \uc2a4\ud1a0\ub9ac\uc9c0 \uc2dc\uc2a4\ud15c\uc5d0 \uc800\uc7a5\ub429\ub2c8\ub2e4.<\/p>\n<\/li>\n<\/ol>\n<h2>Apache Hive\uc758 \uc8fc\uc694 \uae30\ub2a5 \ubd84\uc11d<\/h2>\n<p>Apache Hive\ub294 \ube45 \ub370\uc774\ud130 \ubd84\uc11d\uc5d0 \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \uba87 \uac00\uc9c0 \uc8fc\uc694 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\n<p><strong>\ud655\uc7a5\uc131<\/strong>: Hive\ub294 \ub300\uc6a9\ub7c9 \ub370\uc774\ud130\uc14b\uc744 \ucc98\ub9ac\ud560 \uc218 \uc788\uc5b4 \ub300\uaddc\ubaa8 \ub370\uc774\ud130 \ucc98\ub9ac\uc5d0 \uc801\ud569\ud569\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\uc0ac\uc6a9\uc758 \uc6a9\uc774\uc131<\/strong>: SQL\uacfc \uc720\uc0ac\ud55c \uc778\ud130\ud398\uc774\uc2a4\ub97c \ud1b5\ud574 SQL \uc9c0\uc2dd\uc774 \uc788\ub294 \uc0ac\uc6a9\uc790\ub294 Hive \uc791\uc5c5\uc744 \ube60\ub974\uac8c \uc2dc\uc791\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\ud655\uc7a5\uc131<\/strong>: Hive\ub294 \uc0ac\uc6a9\uc790 \uc815\uc758 \ud568\uc218(UDF)\ub97c \uc9c0\uc6d0\ud558\ubbc0\ub85c \uc0ac\uc6a9\uc790\ub294 \ud2b9\uc815 \ub370\uc774\ud130 \ucc98\ub9ac \uc694\uad6c \uc0ac\ud56d\uc5d0 \ub9de\ub294 \uc0ac\uc6a9\uc790 \uc815\uc758 \ud568\uc218\ub97c \uc791\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\ud30c\ud2f0\uc154\ub2dd<\/strong>: Hive\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ubd84\ud560\ud560 \uc218 \uc788\uc5b4 \ud6a8\uc728\uc801\uc778 \ucffc\ub9ac \ubc0f \ubd84\uc11d\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\ub370\uc774\ud130 \ud615\uc2dd<\/strong>: Hive\ub294 TextFile, SequenceFile, ORC, Parquet \ub4f1 \ub2e4\uc591\ud55c \ub370\uc774\ud130 \ud615\uc2dd\uc744 \uc9c0\uc6d0\ud558\uc5ec \ub370\uc774\ud130 \uc800\uc7a5\uc758 \uc720\uc5f0\uc131\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n<\/li>\n<\/ol>\n<h2>\uc544\ud30c\uce58 \ud558\uc774\ube0c\uc758 \uc720\ud615<\/h2>\n<p>Apache Hive\ub294 \ub370\uc774\ud130 \ucc98\ub9ac \ubc29\ubc95\uc5d0 \ub530\ub77c \ub450 \uac00\uc9c0 \uc8fc\uc694 \uc720\ud615\uc73c\ub85c \ubd84\ub958\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\n<p><strong>\uc77c\uad04 \ucc98\ub9ac<\/strong>: MapReduce\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc77c\uad04 \ucc98\ub9ac\ud558\ub294 \uc804\ud1b5\uc801\uc778 \uc811\uadfc \ubc29\uc2dd\uc785\ub2c8\ub2e4. \ub300\uaddc\ubaa8 \ubd84\uc11d\uc5d0\ub294 \uc801\ud569\ud558\uc9c0\ub9cc \uc2e4\uc2dc\uac04 \ucffc\ub9ac\uc758 \uacbd\uc6b0 \ub300\uae30 \uc2dc\uac04\uc774 \uae38\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\ub300\ud654\ud615 \ucc98\ub9ac<\/strong>: Hive\ub294 Tez \ubc0f Spark\uc640 \uac19\uc740 \ucd5c\uc2e0 \uc2e4\ud589 \uc5d4\uc9c4\uc744 \ud65c\uc6a9\ud558\uc5ec \ub300\ud654\ud615 \ucffc\ub9ac \ucc98\ub9ac\ub97c \ub2ec\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ucffc\ub9ac \uc751\ub2f5 \uc2dc\uac04\uc774 \ud06c\uac8c \uc904\uc5b4\ub4e4\uace0 \uc804\ubc18\uc801\uc778 \uc0ac\uc6a9\uc790 \uacbd\ud5d8\uc774 \ud5a5\uc0c1\ub429\ub2c8\ub2e4.<\/p>\n<\/li>\n<\/ol>\n<p>\ub2e4\uc74c\uc740 \uc774 \ub450 \uac00\uc9c0 \uc720\ud615\uc744 \ube44\uad50\ud55c \ud45c\uc785\ub2c8\ub2e4.<\/p>\n<table>\n<thead>\n<tr>\n<th>\ud2b9\uc9d5<\/th>\n<th>\uc77c\uad04 \ucc98\ub9ac<\/th>\n<th>\ub300\ud654\ud615 \ucc98\ub9ac<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\uc9c0\uc5f0 \uc2dc\uac04<\/td>\n<td>\ub354 \ub192\uc740<\/td>\n<td>\ub0ae\ucd94\ub2e4<\/td>\n<\/tr>\n<tr>\n<td>\ucffc\ub9ac \uc751\ub2f5 \uc2dc\uac04<\/td>\n<td>\ub354 \uae38\uac8c<\/td>\n<td>\ub354 \ube60\ub974\uac8c<\/td>\n<\/tr>\n<tr>\n<td>\uc0ac\uc6a9 \uc0ac\ub840<\/td>\n<td>\uc624\ud504\ub77c\uc778 \ubd84\uc11d<\/td>\n<td>\uc784\uc2dc \ubc0f \uc2e4\uc2dc\uac04 \ucffc\ub9ac<\/td>\n<\/tr>\n<tr>\n<td>\uc2e4\ud589 \uc5d4\uc9c4<\/td>\n<td>\ub9f5\ub9ac\ub4c0\uc2a4<\/td>\n<td>\ud14c\uc988 \ub610\ub294 \uc2a4\ud30c\ud06c<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>Apache Hive \uc0ac\uc6a9 \ubc29\ubc95, \ubb38\uc81c \ubc0f \ud574\uacb0 \ubc29\ubc95<\/h2>\n<p>Apache Hive\ub294 \ub2e4\uc74c\uc744 \ud3ec\ud568\ud558\uc5ec \ub2e4\uc591\ud55c \ub3c4\uba54\uc778\uc5d0\uc11c \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \ucc3e\uc2b5\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\n<p><strong>\ube45\ub370\uc774\ud130 \ubd84\uc11d<\/strong>: Hive\ub97c \ud1b5\ud574 \ubd84\uc11d\uac00\ub294 \ubc29\ub300\ud55c \uc591\uc758 \ub370\uc774\ud130\uc5d0\uc11c \uadc0\uc911\ud55c \ud1b5\ucc30\ub825\uc744 \ucd94\ucd9c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\ube44\uc988\ub2c8\uc2a4 \uc778\ud154\ub9ac\uc804\uc2a4<\/strong>: \uc870\uc9c1\uc5d0\uc11c\ub294 Hive\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc784\uc2dc \ucffc\ub9ac\ub97c \uc218\ud589\ud558\uace0 \ubcf4\uace0\uc11c\ub97c \uc791\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc9d5<\/strong>: Hive\ub294 \ud655\uc7a5\uc131\uc73c\ub85c \uc778\ud574 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc9d5 \uc791\uc5c5\uc5d0 \uc801\ud569\ud569\ub2c8\ub2e4.<\/p>\n<\/li>\n<\/ol>\n<p>\uadf8\ub7ec\ub098 Hive\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\ub824\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \ud2b9\uc815 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\n<p><strong>\uc9c0\uc5f0 \uc2dc\uac04<\/strong>: Hive\ub294 \uae30\ubcf8\uc801\uc73c\ub85c \uc77c\uad04 \ucc98\ub9ac\ub97c \uc0ac\uc6a9\ud558\ubbc0\ub85c \uc2e4\uc2dc\uac04 \ucffc\ub9ac\uc758 \uc9c0\uc5f0 \uc2dc\uac04\uc774 \uae38\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\ubcf5\uc7a1\ud55c \ucffc\ub9ac<\/strong>: \uc77c\ubd80 \ubcf5\uc7a1\ud55c \ucffc\ub9ac\ub294 \ud6a8\uc728\uc801\uc73c\ub85c \ucd5c\uc801\ud654\ub418\uc9c0 \uc54a\uc544 \uc131\ub2a5 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/li>\n<\/ol>\n<p>\uc774\ub7ec\ud55c \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\uc790\ub294 \ub2e4\uc74c \uc194\ub8e8\uc158\uc744 \uace0\ub824\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\n<p><strong>\ub300\ud654\ud615 \ucffc\ub9ac<\/strong>: Tez \ub610\ub294 Spark\uc640 \uac19\uc740 \ub300\ud654\ud615 \ucc98\ub9ac \uc5d4\uc9c4\uc744 \ud65c\uc6a9\ud558\uba74 \uc0ac\uc6a9\uc790\ub294 \ucffc\ub9ac \uc751\ub2f5 \uc2dc\uac04\uc744 \ub2e8\ucd95\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\ucffc\ub9ac \ucd5c\uc801\ud654<\/strong>: \ucd5c\uc801\ud654\ub41c HiveQL \ucffc\ub9ac\ub97c \uc791\uc131\ud558\uace0 \uc801\uc808\ud55c \ub370\uc774\ud130 \ud615\uc2dd\uacfc \ud30c\ud2f0\uc154\ub2dd\uc744 \uc0ac\uc6a9\ud558\uba74 \uc131\ub2a5\uc774 \ud06c\uac8c \ud5a5\uc0c1\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\uce90\uc2f1<\/strong>: \uc911\uac04 \ub370\uc774\ud130\ub97c \uce90\uc2f1\ud558\uba74 \ubc18\ubcf5 \ucffc\ub9ac\uc5d0 \ub300\ud55c \uc911\ubcf5 \uacc4\uc0b0\uc744 \uc904\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/li>\n<\/ol>\n<h2>\uc8fc\uc694 \ud2b9\uc9d5 \ubc0f \uae30\ud0c0 \uc720\uc0ac \uc6a9\uc5b4\uc640\uc758 \ube44\uad50<\/h2>\n<p>\ub2e4\uc74c\uc740 Apache Hive\ub97c \ub2e4\ub978 \uc720\uc0ac\ud55c \uae30\uc220\uacfc \ube44\uad50\ud55c \uac83\uc785\ub2c8\ub2e4.<\/p>\n<table>\n<thead>\n<tr>\n<th>\uae30\uc220<\/th>\n<th>\uc124\uba85<\/th>\n<th>Apache Hive\uc640\uc758 \ucc28\uc774\uc810<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\uc544\ud30c\uce58 \ud558\ub461<\/td>\n<td>\ubd84\uc0b0 \ucef4\ud4e8\ud305\uc744 \uc704\ud55c \ube45 \ub370\uc774\ud130 \ud504\ub808\uc784\uc6cc\ud06c<\/td>\n<td>Hive\ub294 Hadoop\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud558\uace0 \uad00\ub9ac\ud558\uae30 \uc704\ud55c SQL\uacfc \uc720\uc0ac\ud55c \uc778\ud130\ud398\uc774\uc2a4\ub97c \uc81c\uacf5\ud558\ubbc0\ub85c SQL\uc5d0 \ub2a5\uc219\ud55c \uc0ac\uc6a9\uc790\uac00 \ub354 \uc27d\uac8c \uc561\uc138\uc2a4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/td>\n<\/tr>\n<tr>\n<td>\uc544\ud30c\uce58 \ub3fc\uc9c0<\/td>\n<td>MapReduce \ud504\ub85c\uadf8\ub7a8 \uc0dd\uc131\uc744 \uc704\ud55c \uace0\uae09 \ud50c\ub7ab\ud3fc<\/td>\n<td>Hive\ub294 \uce5c\uc219\ud55c SQL \uc720\uc0ac \uc5b8\uc5b4\ub85c \ub370\uc774\ud130 \ucc98\ub9ac\ub97c \ucd94\uc0c1\ud654\ud558\ub294 \ubc18\uba74 Pig\ub294 \ub370\uc774\ud130 \ud750\ub984 \uc5b8\uc5b4\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. Hive\ub294 SQL\uc5d0 \uc775\uc219\ud55c \ubd84\uc11d\uac00\uc5d0\uac8c \ub354 \uc801\ud569\ud569\ub2c8\ub2e4.<\/td>\n<\/tr>\n<tr>\n<td>\uc544\ud30c\uce58 \uc2a4\ud30c\ud06c<\/td>\n<td>\ube60\ub974\uace0 \ubc94\uc6a9\uc801\uc778 \ud074\ub7ec\uc2a4\ud130 \ucef4\ud4e8\ud305 \uc2dc\uc2a4\ud15c<\/td>\n<td>Hive\ub294 \uc5ed\uc0ac\uc801\uc73c\ub85c Spark\uc5d0 \ube44\ud574 \ub300\uae30 \uc2dc\uac04\uc774 \ub354 \uae34 MapReduce\ub97c \uc2e4\ud589\uc5d0 \uc758\uc874\ud588\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 Spark\ub97c \uc2e4\ud589 \uc5d4\uc9c4\uc73c\ub85c \ud1b5\ud569\ud558\uba74 Hive\ub294 \ub300\uae30 \uc2dc\uac04\uc744 \uc904\uc774\uace0 \ucc98\ub9ac \uc18d\ub3c4\ub97c \ub192\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>Apache Hive\uc640 \uad00\ub828\ub41c \ubbf8\ub798\uc758 \uad00\uc810\uacfc \uae30\uc220<\/h2>\n<p>\ube45 \ub370\uc774\ud130\uac00 \uacc4\uc18d\ud574\uc11c \uc99d\uac00\ud568\uc5d0 \ub530\ub77c Apache Hive\uc758 \ubbf8\ub798\ub294 \uc720\ub9dd\ud574 \ubcf4\uc785\ub2c8\ub2e4. Hive\uc640 \uad00\ub828\ub41c \uba87 \uac00\uc9c0 \uc8fc\uc694 \uad00\uc810\uacfc \uc0c8\ub85c\uc6b4 \uae30\uc220\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\n<p><strong>\uc2e4\uc2dc\uac04 \ucc98\ub9ac<\/strong>: \ucffc\ub9ac \uc751\ub2f5 \uc2dc\uac04\uc744 \ub354\uc6b1 \uc904\uc774\uace0 \uc989\uac01\uc801\uc778 \ud1b5\ucc30\ub825\uc744 \uc704\ud55c \uc2e4\uc2dc\uac04 \ucc98\ub9ac\ub97c \ud65c\uc131\ud654\ud558\ub294 \ub370 \uc911\uc810\uc744 \ub458 \uac83\uc785\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\uae30\uacc4 \ud559\uc2b5 \ud1b5\ud569<\/strong>: \uae30\uacc4 \ud559\uc2b5 \ub77c\uc774\ube0c\ub7ec\ub9ac\ub97c Hive\uc640 \ud1b5\ud569\ud558\uc5ec \ud50c\ub7ab\ud3fc \ub0b4\uc5d0\uc11c \uc9c1\uc811 \ub370\uc774\ud130 \ubd84\uc11d \ubc0f \uc608\uce21 \ubaa8\ub378\ub9c1\uc744 \uc218\ud589\ud569\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\ud1b5\ud569 \ucc98\ub9ac \uc5d4\uc9c4<\/strong>: \ucd5c\uc801\uc758 \uc131\ub2a5\uacfc \ub9ac\uc18c\uc2a4 \ud65c\uc6a9\uc744 \uc704\ud574 \uc5ec\ub7ec \uc2e4\ud589 \uc5d4\uc9c4\uc744 \uc6d0\ud65c\ud558\uac8c \ud1b5\ud569\ud558\ub294 \ubc29\ubc95\uc744 \ubaa8\uc0c9\ud569\ub2c8\ub2e4.<\/p>\n<\/li>\n<\/ol>\n<h2>\ud504\ub85d\uc2dc \uc11c\ubc84\ub97c Apache Hive\uc640 \uc0ac\uc6a9\ud558\uac70\ub098 \uc5f0\uacb0\ud558\ub294 \ubc29\ubc95<\/h2>\n<p>OneProxy\uc640 \uac19\uc740 \ud504\ub85d\uc2dc \uc11c\ubc84\ub294 Apache Hive\uc758 \ub9e5\ub77d\uc5d0\uc11c \uc911\uc694\ud55c \uc5ed\ud560\uc744 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub300\uaddc\ubaa8 \ubd84\uc0b0 \uc2dc\uc2a4\ud15c\uc744 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 \ub370\uc774\ud130 \ubcf4\uc548, \uac1c\uc778 \uc815\ubcf4 \ubcf4\ud638 \ubc0f \uc561\uc138\uc2a4 \uc81c\uc5b4\uac00 \uc911\uc694\ud55c \uce21\uba74\uc785\ub2c8\ub2e4. \ud504\ub85d\uc2dc \uc11c\ubc84\ub294 \ud074\ub77c\uc774\uc5b8\ud2b8\uc640 Hive \ud074\ub7ec\uc2a4\ud130 \uc0ac\uc774\uc758 \uc911\uac1c\uc790 \uc5ed\ud560\uc744 \ud558\uc5ec \ucd94\uac00\uc801\uc778 \ubcf4\uc548 \ubc0f \uc775\uba85\uc131\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uadf8\ub4e4\uc740 \ud560 \uc218\uc788\ub2e4:<\/p>\n<ol>\n<li>\n<p><strong>\ubcf4\uc548 \uac15\ud654<\/strong>: \ud504\ub85d\uc2dc \uc11c\ubc84\ub294 Hive \ud074\ub7ec\uc2a4\ud130\uc5d0 \ub300\ud55c \uc9c1\uc811 \uc561\uc138\uc2a4\ub97c \uc81c\ud55c\ud558\uace0 \ubb34\ub2e8 \uc0ac\uc6a9\uc790\ub85c\ubd80\ud130 \ud074\ub7ec\uc2a4\ud130\ub97c \ubcf4\ud638\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\ub85c\ub4dc \ubc38\ub7f0\uc2f1<\/strong>: \ud504\ub85d\uc2dc \uc11c\ubc84\ub294 \ud074\ub77c\uc774\uc5b8\ud2b8 \uc694\uccad\uc744 \uc5ec\ub7ec Hive \ud074\ub7ec\uc2a4\ud130\uc5d0 \ubd84\uc0b0\ud558\uc5ec \ud6a8\uc728\uc801\uc778 \ub9ac\uc18c\uc2a4 \ud65c\uc6a9\uc744 \ubcf4\uc7a5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\uce90\uc2f1<\/strong>: \ud504\ub85d\uc2dc \uc11c\ubc84\ub294 \ucffc\ub9ac \uacb0\uacfc\ub97c \uce90\uc2dc\ud558\uc5ec \ubc18\ubcf5 \ucffc\ub9ac\uc5d0 \ub300\ud55c Hive \ud074\ub7ec\uc2a4\ud130\uc758 \uc791\uc5c5 \ubd80\ud558\ub97c \uc904\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong>\uc775\uba85<\/strong>: \ud504\ub85d\uc2dc \uc11c\ubc84\ub294 \uc0ac\uc6a9\uc790 IP \uc8fc\uc18c\ub97c \uc775\uba85\ud654\ud558\uc5ec \ucd94\uac00\uc801\uc778 \uac1c\uc778 \uc815\ubcf4 \ubcf4\ud638 \uacc4\uce35\uc744 \uc81c\uacf5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/li>\n<\/ol>\n<h2>\uad00\ub828\ub41c \ub9c1\ud06c\ub4e4<\/h2>\n<p>Apache Hive\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9\uc744 \ubcf4\ub824\uba74 \ub2e4\uc74c \ub9ac\uc18c\uc2a4\ub97c \ubc29\ubb38\ud558\uc138\uc694.<\/p>\n<ol>\n<li><a href=\"https:\/\/hive.apache.org\/\" target=\"_new\" rel=\"noopener nofollow\">Apache Hive \uacf5\uc2dd \uc6f9\uc0ac\uc774\ud2b8<\/a><\/li>\n<li><a href=\"https:\/\/cwiki.apache.org\/confluence\/display\/Hive\/Home\" target=\"_new\" rel=\"noopener nofollow\">\uc544\ud30c\uce58 \ud558\uc774\ube0c \ubb38\uc11c<\/a><\/li>\n<li><a href=\"https:\/\/www.apache.org\/\" target=\"_new\" rel=\"noopener nofollow\">\uc544\ud30c\uce58 \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uc7ac\ub2e8<\/a><\/li>\n<\/ol>\n<p>\uacb0\ub860\uc801\uc73c\ub85c, Apache Hive\ub294 Hadoop \uc0dd\ud0dc\uacc4\uc758 \ud544\uc218 \uad6c\uc131 \uc694\uc18c\ub85c\uc11c \uc0ac\uc6a9\uc790 \uce5c\ud654\uc801\uc778 SQL\uacfc \uc720\uc0ac\ud55c \uc778\ud130\ud398\uc774\uc2a4\uc640 \ud655\uc7a5\uc131\uc744 \ud1b5\ud574 \ube45 \ub370\uc774\ud130 \ubd84\uc11d\uc744 \uac15\ud654\ud569\ub2c8\ub2e4. \uc2e4\ud589 \uc5d4\uc9c4\uc758 \ubc1c\uc804\uacfc \ud604\ub300 \uae30\uc220\uc758 \ud1b5\ud569\uc744 \ud1b5\ud574 Hive\ub294 \uc9c0\uc18d\uc801\uc73c\ub85c \uc131\uc7a5\ud558\uace0 \ube45 \ub370\uc774\ud130 \ucc98\ub9ac \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\uac00 \uacc4\uc18d \uc99d\uac00\ud568\uc5d0 \ub530\ub77c Hive\uc758 \ubbf8\ub798\ub294 \uc720\ub9dd\ud574 \ubcf4\uc774\uba70 \ub300\uaddc\ubaa8 \ub370\uc774\ud130 \uc138\ud2b8\uc5d0\uc11c \uadc0\uc911\ud55c \ud1b5\ucc30\ub825\uc744 \uc5bb\uc73c\ub824\uace0 \ub178\ub825\ud558\ub294 \ub370\uc774\ud130 \ubd84\uc11d\uac00 \ubc0f \uc870\uc9c1\uc758 \ubb34\uae30\uace0\uc5d0\uc11c \uc911\uc694\ud55c \ub3c4\uad6c\ub85c \ub0a8\uc744 \uac83\uc785\ub2c8\ub2e4.<\/p>","protected":false},"featured_media":467616,"menu_order":0,"template":"","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"footnotes":""},"class_list":["post-475878","wiki","type-wiki","status-publish","has-post-thumbnail","hentry"],"acf":{"faq_title":"Frequently Asked Questions about <mark>Apache Hive: Empowering Big Data Analytics<\/mark>","faq_items":[{"question":"Question: What is Apache Hive?","answer":"<p>Answer: Apache Hive is an open-source data warehousing and SQL-like query language tool built on top of Apache Hadoop. It provides a user-friendly interface for managing and querying large-scale datasets stored in Hadoop's distributed file system (HDFS).<\/p>"},{"question":"Question: Who developed Apache Hive, and when was it created?","answer":"<p>Answer: Apache Hive was initially conceived by Jeff Hammerbacher and Facebook's Data Infrastructure Team in 2007. It was later handed over to the Apache Software Foundation (ASF) in 2008, evolving as an open-source project with contributions from developers worldwide.<\/p>"},{"question":"Question: How does Apache Hive work, and what is its internal structure?","answer":"<p>Answer: Apache Hive translates SQL-like queries (Hive Query Language or HQL) into MapReduce, Tez, or Spark jobs to interact with Hadoop's distributed data. It consists of three main components: HiveQL (SQL-like language), Metastore (metadata repository), and Execution Engine (processing the queries).<\/p>"},{"question":"Question: What are the key features of Apache Hive?","answer":"<p>Answer: Apache Hive offers scalability for handling large datasets, ease of use with its SQL-like interface, extensibility with user-defined functions (UDFs), partitioning for efficient querying, and support for various data formats like TextFile, SequenceFile, ORC, and Parquet.<\/p>"},{"question":"Question: What are the types of Apache Hive, and how do they differ?","answer":"<p>Answer: Apache Hive can be categorized into Batch Processing and Interactive Processing. Batch Processing uses MapReduce and is suitable for offline analytics, while Interactive Processing leverages Tez or Spark, offering faster query response times and real-time queries.<\/p>"},{"question":"Question: How can I use Apache Hive, and what challenges might I face?","answer":"<p>Answer: Apache Hive finds applications in big data analytics, business intelligence, and data warehousing. Challenges may include higher latency for real-time queries and complexities with certain queries. Solutions involve leveraging interactive processing, query optimization, and caching.<\/p>"},{"question":"Question: How does Apache Hive compare with similar technologies like Apache Hadoop, Apache Pig, and Apache Spark?","answer":"<p>Answer: Apache Hive provides a SQL-like interface for querying and managing data in Hadoop, making it more accessible to SQL-savvy users compared to Hadoop. It differs from Apache Pig by using a SQL-like language instead of a data flow language. With the integration of Spark, Hive achieves lower latency compared to its historical reliance on MapReduce.<\/p>"},{"question":"Question: What can we expect for the future of Apache Hive?","answer":"<p>Answer: The future of Apache Hive looks promising with a focus on real-time processing, machine learning integration, and unified processing engines to optimize performance and resource utilization.<\/p>"},{"question":"Question: How can proxy servers like OneProxy be associated with Apache Hive?","answer":"<p>Answer: Proxy servers like OneProxy can enhance security, load balancing, caching, and anonymity when working with Hive clusters, providing an additional layer of protection and privacy for users.<\/p>"},{"question":"Question: Where can I find more information about Apache Hive?","answer":"<p>Answer: For more information about Apache Hive, visit the official Apache Hive website (<a href=\"https:\/\/hive.apache.org\/\" target=\"_new\">https:\/\/hive.apache.org\/<\/a>), the Apache Hive documentation (<a href=\"https:\/\/cwiki.apache.org\/confluence\/display\/Hive\/Home\" target=\"_new\">https:\/\/cwiki.apache.org\/confluence\/display\/Hive\/Home<\/a>), or the Apache Software Foundation website (<a href=\"https:\/\/www.apache.org\/\" target=\"_new\">https:\/\/www.apache.org\/<\/a>).<\/p>"}]},"_links":{"self":[{"href":"https:\/\/oneproxy.pro\/kr\/wp-json\/wp\/v2\/wiki\/475878","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneproxy.pro\/kr\/wp-json\/wp\/v2\/wiki"}],"about":[{"href":"https:\/\/oneproxy.pro\/kr\/wp-json\/wp\/v2\/types\/wiki"}],"version-history":[{"count":0,"href":"https:\/\/oneproxy.pro\/kr\/wp-json\/wp\/v2\/wiki\/475878\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oneproxy.pro\/kr\/wp-json\/wp\/v2\/media\/467616"}],"wp:attachment":[{"href":"https:\/\/oneproxy.pro\/kr\/wp-json\/wp\/v2\/media?parent=475878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}