{"id":6758,"date":"2026-07-12T02:07:13","date_gmt":"2026-07-12T10:07:13","guid":{"rendered":"https:\/\/www.gudusoft.com\/hive-data-lineage\/"},"modified":"2026-07-12T02:07:13","modified_gmt":"2026-07-12T10:07:13","slug":"hive-data-lineage","status":"publish","type":"page","link":"https:\/\/www.gudusoft.com\/ko\/%ed%95%98%ec%9d%b4%eb%b8%8c-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/","title":{"rendered":"Hive \ub370\uc774\ud130 \uacc4\ubcf4: HQL \ubc0f Hadoop ETL\uc744 \uc704\ud55c \uc5f4 \uc218\uc900 \uacc4\ubcf4"},"content":{"rendered":"<p><strong>\ud558\uc774\ube0c \ub370\uc774\ud130 \uacc4\ubcf4<\/strong> HQL\uc740 \ub370\uc774\ud130\uac00 HQL\uc744 \ud1b5\ud574 \ud750\ub974\ub294 \ubc29\uc2dd\uc744 \uc5f4 \uc218\uc900\uc5d0\uc11c \ubcf4\uc5ec\uc8fc\ub294 \ub9f5\uc785\ub2c8\ub2e4. \uc989, \uc5b4\ub5a4 \uc18c\uc2a4 \ud14c\uc774\ube14\uacfc \uc5f4\uc774 \uac01 Hive \ud14c\uc774\ube14, \ud30c\ud2f0\uc158 \ubc0f \ubdf0\uc5d0 \ub370\uc774\ud130\ub97c \uc81c\uacf5\ud558\ub294\uc9c0, \uadf8\ub9ac\uace0 \uc5b4\ub5a4 \uc870\uc778, \uc9d1\uacc4 \ub4f1\uc744 \ud1b5\ud574 \ub370\uc774\ud130\uac00 \ucc98\ub9ac\ub418\ub294\uc9c0\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4. <code>\uce21\uba74\ub3c4<\/code> \ud655\uc7a5 \uae30\ub2a5. \uc774\ub97c \uad6c\ucd95\ud558\ub294 \uac00\uc7a5 \ud655\uc2e4\ud55c \ubc29\ubc95\uc740 HQL \uc790\uccb4\ub97c \ud30c\uc2f1\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. <strong>Gudu SQLFlow<\/strong> \uc774 \uc18c\ud504\ud2b8\uc6e8\uc5b4\ub294 \ud074\ub7ec\uc2a4\ud130\ub97c \uac74\ub4dc\ub9ac\uc9c0 \uc54a\uace0\ub3c4 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ub300\ud654\ud615 \uc5f4 \uc218\uc900 \uacc4\ubcf4 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc73c\ub85c \ubcc0\ud658\ud558\ub294 \uc804\uc6a9 Hive \ubc29\uc5b8 \ud30c\uc11c\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained\" style=\"background-color:#eef7fb;padding-top:24px;padding-bottom:24px\"><div class=\"wp-block-group__inner-container\">\n\n<p><strong>\uc9c0\uae08 \ubc14\ub85c \uc2dc\ub3c4\ud574 \ubcf4\uc138\uc694:<\/strong> HiveQL \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc5ec\uae30\uc5d0 \ubd99\uc5ec\ub123\uc73c\uc138\uc694. <a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=hive-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">\ubb34\ub8cc \uc628\ub77c\uc778 Hive \uacc4\ubcf4 \uc2dc\uac01\ud654 \ub3c4\uad6c<\/a>Hive \ubc29\uc5b8\uc744 \uc120\ud0dd\ud558\uba74 \uba87 \ucd08 \ub9cc\uc5d0 \uc5f4 \uc218\uc900\uc758 \uacc4\ubcf4\ub3c4\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud074\ub7ec\uc2a4\ud130 \uc561\uc138\uc2a4\ub294 \ud544\uc694\ud558\uc9c0 \uc54a\uc73c\uba70, \ubb34\ub8cc \ud2f0\uc5b4\ub294 \ube0c\ub77c\uc6b0\uc800\uc5d0\uc11c \uc2e4\ud589\ub429\ub2c8\ub2e4.<\/p>\n\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Hive \ub370\uc774\ud130 \uacc4\ubcf4 \ucd94\uc801\uc774 \uc0dd\uac01\ubcf4\ub2e4 \uc5b4\ub824\uc6b4 \uc774\uc720<\/h2>\n\n\n\n<p>\uc77c\ubc18\uc801\uc778 \ud558\ub461 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc5d0\ub294 \uc218\ub144\uac04\uc758 \uace0\ud488\uc9c8 \ub370\uc774\ud130(HQL)\uac00 \ucd95\uc801\ub429\ub2c8\ub2e4. \uc5ec\uae30\uc5d0\ub294 \uc2a4\ud14c\uc774\uc9d5 \ub85c\ub4dc, \ud30c\ud2f0\uc158\ub41c \ub85c\ub4dc \ub4f1\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4. <code>\uc0bd\uc785 \ub36e\uc5b4\uc4f0\uae30<\/code> \uc791\uc5c5, \uc678\ubd80 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \ubcf4\uae30, \uadf8\ub9ac\uace0 \uc791\uc131\uc790\uac00 \ub5a0\ub09c \uc774\ud6c4 \uc544\ubb34\ub3c4 \uc77d\uc9c0 \uc54a\uc740 Oozie \ub610\ub294 Airflow\ub85c \uc608\uc57d\ub41c \uc2a4\ud06c\ub9bd\ud2b8. &quot;\ubb34\uc5c7\uc774 \ud53c\ub4dc\ub97c \uc81c\uacf5\ud558\ub294\uac00&quot;\uc5d0 \ub300\ud55c \ub2f5\ubcc0 <code>dw.\uc77c\uc77c\uc218\uc775<\/code>&quot;\ub5a8\uc5b4\ub728\ub9ac\uba74 \uc5b4\ub5bb\uac8c \ub420\uae4c\uc694?&quot; \ub610\ub294 &quot;\ub5a8\uc5b4\ub728\ub9ac\uba74 \uc5b4\ub5bb\uac8c \ub420\uae4c\uc694?&quot; <code>\uc2a4\ud14c\uc774\uc9d5.\uc8fc\ubb38.\uc0c1\ud0dc<\/code>?&quot;\ub294 \uc804\uccb4 \uc5f4 \ucc38\uc870\ub97c \ucd94\uc801\ud55c\ub2e4\ub294 \uc758\ubbf8\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc77c\ubc18\uc801\uc778 SQL \ud30c\uc11c\ub294 HiveQL\uc744 \uace0\uc720\ud55c \ubc29\uc5b8\uc73c\ub85c \ub9cc\ub4dc\ub294 \uad6c\ubb38\uc744 \ucc98\ub9ac\ud558\ub294 \ub370 \uc5b4\ub824\uc6c0\uc744 \uacaa\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li><strong><code>\uce21\uba74 \ubcf4\uae30 explode()<\/code><\/strong> \u2014 \ubc30\uc5f4\uc774\ub098 \ub9f5\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9c4 \ud558\ub098\uc758 \uc785\ub825 \uc5f4\uc774 \uc5ec\ub7ec \ud589\uacfc \uc0c8\ub85c\uc6b4 \ud30c\uc0dd \uc5f4\ub85c \ud655\uc7a5\ub429\ub2c8\ub2e4. \ub9ac\ub2c8\uc9c0\ub294 \ud655\uc7a5\ub41c \ucd9c\ub825 \uc5f4\uc744 \ub2e8\uc77c \uc18c\uc2a4 \uceec\ub809\uc158\uc5d0 \ub2e4\uc2dc \uc5f0\uacb0\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\ubd84\ud560\ub428 <code>\uc0bd\uc785 \ub36e\uc5b4\uc4f0\uae30<\/code><\/strong> \u2014 \ud30c\ud2f0\uc158 \uc5f4\uc740 \uc815\uc801 \ub9ac\ud130\ub7f4\uc5d0\uc11c \uac00\uc838\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4. <code>\ubd84\ud560<\/code> \uc808\uc744 \uc0ac\uc6a9\ud558\uac70\ub098 \ub9c8\uc9c0\ub9c9 SELECT \uc5f4\uc5d0\uc11c \ub3d9\uc801\uc73c\ub85c \uac00\uc838\uc635\ub2c8\ub2e4. \ub450 \uacbd\uc6b0 \ubaa8\ub450 \uacc4\ubcf4 \uc18c\uc2a4\ub85c \uac04\uc8fc\ub418\ub294 \uc5f4\uc774 \ubcc0\uacbd\ub429\ub2c8\ub2e4.<\/li>\n<li><strong>\uc678\ubd80 \ud14c\uc774\ube14<\/strong> \u2014 \ud574\ub2f9 \ud14c\uc774\ube14\uc740 HDFS \ub610\ub294 \uac1d\uccb4 \uc2a4\ud1a0\ub9ac\uc9c0\uc758 \ud30c\uc77c \uc704\uc5d0 \uc788\ub294 \uc2a4\ud0a4\ub9c8\uc785\ub2c8\ub2e4. \uc0c1\uc704 SQL\uc5d0\uc11c \ud574\ub2f9 \ud14c\uc774\ube14\uc5d0 \uae30\ub85d\ub41c \uc801\uc774 \uc5c6\ub354\ub77c\ub3c4, \ub9ac\ub2c8\uc9c0\ub294 \uc774\ub97c \uc77c\uae09 \uc18c\uc2a4\ub85c \ucde8\uae09\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li>\n<li><strong>Hive \uad00\ub828 \uad6c\ubb38<\/strong> \u2014 <code>\ubc30\ud3ec\ucc98<\/code>, <code>\ud074\ub7ec\uc2a4\ud130 \uae30\uc900<\/code>, \ub2e4\uc911 \uc0bd\uc785(<code>...\uc5d0\uc11c ... \uc0bd\uc785 ... \uc0bd\uc785 ...<\/code>), SerDe \uae30\ubc18 \uc720\ud615 \ubc0f \ubc31\ud2f1\uc73c\ub85c \ubb36\uc778 \uc2dd\ubcc4\uc790\ub294 \ubaa8\ub450 ANSI \uc804\uc6a9 \ubb38\ubc95\uc744 \uc704\ubc18\ud569\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<p>SQLFlow\ub294 \uc804\uc6a9 \ubc29\uc5b8 \ud30c\uc11c\ub97c \uc0ac\uc6a9\ud558\uc5ec HiveQL\uc744 \uad6c\ubb38 \ubd84\uc11d\ud569\ub2c8\ub2e4. \uc774 \ud30c\uc11c\ub294 \ub3c4\uad6c\uc5d0 \ub0b4\uc7a5\ub41c 39\uac1c\uc758 \ubc29\uc5b8\ubcc4 \ud30c\uc11c \uc911 \ud558\ub098\uc774\uba70, \uc77c\ubc18\uc801\uc778 ANSI \ud30c\uc11c\uc5d0 \uc608\uc678 \ucc98\ub9ac\ub97c \ucd94\uac00\ud55c \uac83\uc774 \uc544\ub2c8\ub77c HiveQL\uc5d0 \ub9de\uac8c \uad6c\ucd95\ub41c \ubb38\ubc95\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uae30\ubcf8 \uc5d4\uc9c4\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/www.sqlparser.com\/\">\uc77c\ubc18 SQL \ud30c\uc11c<\/a>, has been developed commercially since the mid-2000s and is validated against roughly 13,600 per-dialect SQL test fixtures.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Atlas \ud6c5\uacfc HQL \ud30c\uc2f1: Hive \uacc4\ubcf4\ub97c \uc5bb\ub294 \ub450 \uac00\uc9c0 \ubc29\ubc95<\/h2>\n\n\n\n<p>\ub300\ubd80\ubd84\uc758 \ud558\ub461 \ud300\uc740 \uacc4\ubcf4\ub97c \ud1b5\ud574 \ucc98\uc74c \uc811\ud558\uac8c \ub429\ub2c8\ub2e4. <strong>\uc544\ud30c\uce58 \uc544\ud2c0\ub77c\uc2a4<\/strong>Atlas\ub294 \ubcf8\ub798\uc758 \ubaa9\uc801\uc5d0 \ubd80\ud569\ud558\ub294 \ub6f0\uc5b4\ub09c \uc131\ub2a5\uc744 \uc790\ub791\ud569\ub2c8\ub2e4. \ud074\ub7ec\uc2a4\ud130\uc5d0 \uc5f0\uacb0\ub41c Hive \ud6c4\ud06c\ub97c \ud1b5\ud574 \uc791\uc5c5\uc774 \uc2e4\uc81c\ub85c \uc2e4\ud589\ub420 \ub54c \uc791\uc5c5 \ub0b4\uc5ed\uc744 \uae30\ub85d\ud558\uc5ec, Hadoop \uc2a4\ud0dd \uc804\ubc18\uc5d0 \uac78\uccd0 \ubd84\ub958 \ubc0f \ud0dc\uae45\uacfc \uc5f0\ub3d9\ub41c, \uc5b8\uc81c \uc5b4\ub5a4 \uc791\uc5c5\uc774 \uc2e4\ud589\ub418\uc5c8\ub294\uc9c0\uc5d0 \ub300\ud55c \uc2e4\uc2dc\uac04 \uad00\ub9ac \uae30\ub85d\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ud558\uc9c0\ub9cc \ud6c5 \ubc29\uc2dd\uc5d0\ub294 \uad6c\uc870\uc801\uc778 \ud55c\uacc4\uac00 \uc788\uc73c\uba70, \uc774\ub7ec\ud55c \ud55c\uacc4\ub294 \ud300\uc774 \uacc4\ubcf4\ub97c \ucc3e\uc744 \ub54c \uac00\uc7a5 \uc911\uc694\ud558\uac8c \uc791\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th><\/th><th>\ub7f0\ud0c0\uc784 \ud6c4\ud06c(Atlas \uc2a4\ud0c0\uc77c)<\/th><th>HQL \ud30c\uc2f1(SQLFlow)<\/th><\/tr><\/thead><tbody>\n<tr><td>\uc2e4\ud589 \uc911\uc778 \ud074\ub7ec\uc2a4\ud130\uac00 \ud544\uc694\ud569\ub2c8\ub2e4.<\/td><td>\uc608, \uacc4\ubcf4\ub294 \ud6c5\uc774 \uc124\uce58\ub41c \uc0c1\ud0dc\ub85c \uc791\uc5c5\uc774 \uc2e4\ud589\ub420 \ub54c\ub9cc \ucea1\ucc98\ub429\ub2c8\ub2e4.<\/td><td>\uc544\ub2c8\uc694, SQL \ud14d\uc2a4\ud2b8\uc5d0 \ub300\ud55c \uc815\uc801 \ubd84\uc11d\uc740 \uc5b4\ub514\uc5d0\uc11c\ub3c4 \uc218\ud589\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/td><\/tr>\n<tr><td>\uc2e4\ud589\ub418\uc9c0 \uc54a\uc740 \ucf54\ub4dc\ub97c \ud3ec\ud568\ud569\ub2c8\ub2e4.<\/td><td>\uc544\ub2c8\uc694, \uc2e4\ud589\ub418\uc9c0 \uc54a\uc740 \uc2a4\ud06c\ub9bd\ud2b8\ub294 \uc544\ubb34\ub7f0 \ud754\uc801\ub3c4 \ub0a8\uae30\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/td><td>\uc608, \uc800\uc7a5\uc18c\uc5d0 \uc788\ub294 \ubaa8\ub4e0 \uc2a4\ud06c\ub9bd\ud2b8(\uc2e4\ud589\ub418\uc9c0 \uc54a\uac70\ub098 \uac70\uc758 \uc2e4\ud589\ub418\uc9c0 \uc54a\ub294 \uc791\uc5c5 \ud3ec\ud568)\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4.<\/td><\/tr>\n<tr><td>\ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc911\/\uc774\ud6c4 \uc791\uc5c5<\/td><td>\uc5b4\ub835\uc2b5\ub2c8\ub2e4. \ud074\ub7ec\uc2a4\ud130\uac00 \uc0ac\uc6a9 \uc911\uc9c0\ub418\uba74 \ucea1\ucc98 \uc9c0\uc810\ub3c4 \uc0ac\ub77c\uc9d1\ub2c8\ub2e4.<\/td><td>\uc608, \uc774\ub3d9 \uc804, \uc774\ub3d9 \uc911, \uc774\ub3d9 \ud6c4\uc5d0 \ub0b4\ubcf4\ub0b8 HQL\uc744 \uc624\ud504\ub77c\uc778\uc5d0\uc11c \ubd84\uc11d\ud569\ub2c8\ub2e4.<\/td><\/tr>\n<tr><td>\uc5ed\uc0ac \uad00\ub828 \ub0b4\uc6a9<\/td><td>\ud6c4\ud06c\ub97c \uc124\uce58\ud55c \uc2dc\uc810\ubd80\ud130 \uc2dc\uc791\ub429\ub2c8\ub2e4.<\/td><td>\uc644\ub8cc\ub428 \u2014 \ucf54\ub4dc\uac00 \uae30\ub85d\uc785\ub2c8\ub2e4<\/td><\/tr>\n<tr><td>\ub370\uc774\ud130\ub97c \uc77d\uc2b5\ub2c8\ub2e4<\/td><td>\ud074\ub7ec\uc2a4\ud130 \ub0b4\ubd80\uc5d0\uc11c \ub2e4\ub978 \uc791\uc5c5\ub4e4\uacfc \ud568\uaed8 \uc2e4\ud589\ub429\ub2c8\ub2e4.<\/td><td>\uc808\ub300 \uc548 \ub428 \u2014 SQL \ud14d\uc2a4\ud2b8 \ubc0f \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\ub9cc \ud574\ub2f9<\/td><\/tr>\n<\/tbody><\/table><\/figure>\n\n\n\n<p>\uc774\ub7ec\ud55c \uc811\uadfc \ubc29\uc2dd\uc740 \uacbd\uc7c1 \uad00\uacc4\ub77c\uae30\ubcf4\ub2e4\ub294 \uc0c1\ud638 \ubcf4\uc644\uc801\uc785\ub2c8\ub2e4. \ud6c5\uc740 \uc5b4\ub5a4 \ucf54\ub4dc\uac00 \uc2e4\ud589\ub418\uc5c8\ub294\uc9c0 \uc54c\ub824\uc8fc\uace0, \ud30c\uc11c\ub294 \ucf54\ub4dc\uac00 \ubb34\uc5c7\uc744 \ud558\ub294\uc9c0 \uc54c\ub824\uc90d\ub2c8\ub2e4. \ub9cc\uc57d &quot;\uc774 Hive \ud658\uacbd\uc758 \ubaa8\ub4e0 \uc885\uc18d\uc131\uc744 \ubb38\uc11c\ud654\ud558\uc5ec \uac10\uc0ac\ud558\uac70\ub098 \uc774\ub3d9\ud560 \uc218 \uc788\ub3c4\ub85d \ud558\uc138\uc694&quot;\ub77c\ub294 \uc9c8\ubb38\uc774\ub77c\uba74, \ud30c\uc2f1\uc774 \ubc14\ub85c \uadf8 \ud574\ub2f5\uc744 \uc81c\uc2dc\ud558\ub294 \ub3c4\uad6c\uc774\uba70, SQLFlow\ub294 \uadf8 \uacb0\uacfc\ub97c \uc81c\uacf5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <strong>DataHub, Microsoft Purview \ub610\ub294 OpenMetadata<\/strong> \ub9cc\uc57d \uadf8 \uc911 \ud558\ub098\uac00 \uadc0\ud558\uc758 \uae30\ub85d \uc2dc\uc2a4\ud15c\uc774\ub77c\uba74.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc2e4\uc81c HiveQL \uc791\uc5c5\uc5d0\uc11c \uac00\uc838\uc628 \uc5f4 \uc218\uc900 \uacc4\ubcf4<\/h2>\n\n\n\n<p>\ub2e4\uc74c\uc740 \ubaa8\ub4e0 \ud558\ub461 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uac00 \ub9e4\uc77c \ubc24 \uc2e4\ud589\ud558\ub294 \uc791\uc5c5\uc758 \ud615\ud0dc\uc785\ub2c8\ub2e4. \uc989, \ud30c\ud2f0\uc158\ub41c \ud615\ud0dc\uc785\ub2c8\ub2e4. <code>\uc0bd\uc785 \ub36e\uc5b4\uc4f0\uae30<\/code> \uacb0\ud569\ub41c \uc2a4\ud14c\uc774\uc9d5 \ud14c\uc774\ube14\uc5d0\uc11c \uc0dd\uc131\ub428:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT OVERWRITE TABLE dw.daily_revenue PARTITION (ds = &#039;2026-07-11&#039;) SELECT c.region, SUM(o.amount) AS revenue, COUNT(DISTINCT o.order_id) AS order_cnt FROM staging.orders o JOIN staging.customers c ON o.customer_id = c.customer_id WHERE o.ds = &#039;2026-07-11&#039; AND o.status = &#039;COMPLETE&#039; GROUP BY c.region;<\/code><\/pre>\n\n\n\n<p>SQLFlow\ub97c \ud1b5\ud574 \uc2e4\ud589\ud558\uba74 \ucd9c\ub825 \uc5f4\ubcc4\ub85c \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li><code>dw.\uc77c\uc77c\uc218\uc775.\uc218\uc775<\/code> \uc9c1\uc811 \uacf5\uae09\ub429\ub2c8\ub2e4 <code>\uc2a4\ud14c\uc774\uc9d5.\uc8fc\ubb38.\uae08\uc561<\/code> ~\uc744 \ud1b5\ud574 <code>\ud569\uc9d1\ud569()<\/code>.<\/li>\n<li><code>dw.daily_revenue.order_cnt<\/code> ~\uc5d0 \uc758\ud574 \uacf5\uae09\ub429\ub2c8\ub2e4 <code>\uc2a4\ud14c\uc774\uc9d5.\uc8fc\ubb38.\uc8fc\ubb38_id<\/code> ~\uc744 \ud1b5\ud574 <code>COUNT(DISTINCT)<\/code>.<\/li>\n<li><code>dw.\uc77c\uc77c\uc218\uc775.\uc9c0\uc5ed<\/code> \uc9c0\ub3c4 \ubc14\ub85c\uac00\uae30 <code>\uc2a4\ud14c\uc774\uc9d5.\uace0\uac1d.\uc9c0\uc5ed<\/code>.<\/li>\n<li>\uc815\uc801 \ud30c\ud2f0\uc158 \uac12\uc774 \ucc44\uc6cc\uc9d1\ub2c8\ub2e4. <code>dw.daily_revenue.ds<\/code> \u2014 SQLFlow\ub294 \ud30c\ud2f0\uc158 \uc5f4\uc774 SELECT \ubaa9\ub85d\uc5d0 \ub098\ud0c0\ub098\uc9c0 \uc54a\ub354\ub77c\ub3c4 \ud574\ub2f9 \uc5f4\uc744 \ub9ac\ub2c8\uc9c0 \ub300\uc0c1\uc73c\ub85c \ubaa8\ub378\ub9c1\ud569\ub2c8\ub2e4.<\/li>\n<li><code>\uc2a4\ud14c\uc774\uc9d5.\uc8fc\ubb38.\uc0c1\ud0dc<\/code>, <code>\uc2a4\ud14c\uc774\uc9d5.\uc624\ub354.ds<\/code>\uadf8\ub9ac\uace0 \ub458 \ub2e4 <code>\uace0\uac1d ID<\/code> \uceec\ub7fc\uc740 \uacb0\uacfc\ub97c \ud615\uc131\ud569\ub2c8\ub2e4. <code>\uc5b4\ub514<\/code> \uadf8\ub9ac\uace0 <code>\uac00\uc785\ud558\ub2e4<\/code> \ucd9c\ub825\uc5d0 \ub098\ud0c0\ub098\uc9c0 \uc54a\ub294 \uc870\uac74\uc785\ub2c8\ub2e4. SQLFlow\ub294 \uc774\ub97c \ub2e4\uc74c\uacfc \uac19\uc774 \uae30\ub85d\ud569\ub2c8\ub2e4. <strong>\uac04\uc811\uc801 (\uc601\ud5a5) \uacc4\ubcf4<\/strong>\ubcc4\ub3c4\uc758 \uc804\ud658 \uac00\ub2a5\ud55c \uad00\uacc4 \uc720\ud615\uc785\ub2c8\ub2e4. \ub300\ubd80\ubd84\uc758 \uacc4\ubcf4 \ub3c4\uad6c\ub294 \uc774\ub7ec\ud55c \uad6c\ubd84\uc744 \ud558\uc9c0 \uc54a\uc9c0\ub9cc, \uc601\ud5a5 \ubd84\uc11d\uc5d0 \uaf2d \ud544\uc694\ud55c \uac83\uc774 \ubc14\ub85c \ubcc0\uacbd\uc785\ub2c8\ub2e4. <code>\uc0c1\ud0dc<\/code> \ucf54\ub529\uacfc \uadf8 \uc774\ud6c4\uc758 \ubaa8\ub4e0 \uc218\uc775 \uc218\uce58\ub294 \ubcc0\ub3d9\ud569\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<p>\ub3d9\uc77c\ud55c \uc5f4 \ud574\uc0c1\ub3c4\uac00 \uc801\uc6a9\ub429\ub2c8\ub2e4. <code>\uce21\uba74 \ubcf4\uae30 explode()<\/code>\ud558\uc704 \ud14c\uc774\ube14\uc5d0\uc11c \uc120\ud0dd\ud558\ub294 \uacbd\uc6b0 <code>\ud488\ubaa9.sku<\/code> \ud3ed\ubc1c\ub85c\ubd80\ud130 <code>\uc8fc\ubb38 \uc774\ubca4\ud2b8.\ud56d\ubaa9<\/code> \ubc30\uc5f4, SQLFlow \ucd94\uc801 <code>\uc2a4\ucfe0<\/code> \ud14c\uc774\ube14 \ubcc4\uce6d\uc744 \ud1b5\ud574 \ub3c4\uc785\ub41c \uce21\uba74 \ubdf0\ub97c \uac70\uccd0 \uc18c\uc2a4 \uceec\ub809\uc158 \uc5f4\ub85c \ub3cc\uc544\uac11\ub2c8\ub2e4. \ub610\ud55c CTE, \uc911\ucca9 \uc11c\ube0c\ucffc\ub9ac, \ubdf0 \ub4f1\uc744 \ud1b5\ud55c \ucc38\uc870\ub3c4 \ud574\uacb0\ud569\ub2c8\ub2e4. <code>\uc120\ud0dd\ud558\ub2e4 *<\/code> \ud655\uc7a5\uc131\uc73c\ub85c \uc778\ud574 \ubcc4\ud45c\uac00 \ub9ce\uc740 \uae30\uc874 HQL\ub3c4 \uc5ec\uc804\ud788 \uc815\ud655\ud55c \uc5f4 \uac00\uc7a5\uc790\ub9ac\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc774\uc8fc \uc2dc\uc810\uc758 \ubc8c\uc9d1 \uacc4\ud1b5<\/h2>\n\n\n\n<p>\uc624\ub298\ub0a0 \ud300\ub4e4\uc774 Hive \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ud544\uc694\ub85c \ud558\ub294 \uac00\uc7a5 \uc77c\ubc18\uc801\uc778 \uc774\uc720\ub294 Hive\ub97c \ub5a0\ub098\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. Spark, Databricks \ub610\ub294 \ud074\ub77c\uc6b0\ub4dc \uc6e8\uc5b4\ud558\uc6b0\uc2a4 \ub4f1 \uc5b4\ub5a4 \ubaa9\uc801\uc9c0\ub85c \uc774\ub3d9\ud558\ub4e0, \ub2e4\uc74c\uacfc \uac19\uc740 \uc9c8\ubb38\uc774 \uc81c\uae30\ub429\ub2c8\ub2e4. \uc5b4\ub5a4 \uc791\uc5c5\uc774 \uc5b4\ub5a4 \ud14c\uc774\ube14\uc5d0 \ub370\uc774\ud130\ub97c \uc81c\uacf5\ud558\ub294\uc9c0, \uc5b4\ub5a4 \uc21c\uc11c\ub85c \uc774\ub3d9\ud574\uc57c \ud558\ub294\uc9c0, \uadf8\ub9ac\uace0 \uc774 4,000\uac1c\uc758 \uc2a4\ud06c\ub9bd\ud2b8 \uc911 \uc2e4\uc81c\ub85c \ub354 \uc774\uc0c1 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\ub294 \uc2a4\ud06c\ub9bd\ud2b8\ub294 \ubb34\uc5c7\uc778\uc9c0\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>SQLFlow\ub294 \ucf54\ub4dc\ub9cc\uc73c\ub85c \uc791\ub3d9\ud558\uae30 \ub54c\ubb38\uc5d0 \ud074\ub7ec\uc2a4\ud130(\uc774\ubbf8 \ub3d9\uacb0\ub418\uc5c8\uc744 \uc218\ub3c4 \uc788\uc74c)\uc5d0 \uc811\uadfc\ud560 \ud544\uc694 \uc5c6\uc774 \uc5b4\ub5a4 \uba38\uc2e0\uc5d0\uc11c\ub4e0 HQL \ub9ac\ud3ec\uc9c0\ud1a0\ub9ac \ub0b4\ubcf4\ub0b4\uae30 \ud30c\uc77c\uc5d0 \ub300\ud55c \ubd84\uc11d\uc744 \uc2e4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubc30\uce58 \uc2a4\uce94\uc740 \uc774\ub7ec\ud55c \uc6a9\ub3c4\ub85c \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4. SQLFlow\ub294 100\uac1c \uc774\uc0c1\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ubc31\ub9cc \uac1c \uc774\uc0c1\uc758 \uc5f4\ub85c \uad6c\uc131\ub41c \ud658\uacbd\uc744 \uc2a4\uce94\ud558\uace0, \uacb0\uacfc\ub97c \uc601\uad6c\uc801\uc778 \ub9ac\ubbf8\uc9c0 \ub9ac\ud3ec\uc9c0\ud1a0\ub9ac\uc5d0 \uc800\uc7a5\ud558\uba70, \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc911\uc5d0 \uc2a4\ud06c\ub9bd\ud2b8\uac00 \ubcc0\uacbd\ub420 \ub54c\ub9c8\ub2e4 \uc810\uc9c4\uc801\uc73c\ub85c \uc0c8\ub85c \uace0\uce69\ub2c8\ub2e4. \uadf8\ub9ac\uace0 Hive \uc774\ud6c4\ub85c\ub294, <a href=\"https:\/\/www.gudusoft.com\/ko\/%ec%8a%a4%ed%8c%8c%ed%81%ac-sql-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/\">Spark SQL<\/a>, \uadf8\ub9ac\uace0 <a href=\"https:\/\/www.gudusoft.com\/ko\/%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b8%8c%eb%a6%ad%ec%8a%a4-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/\">\ub370\uc774\ud130\ube0c\ub9ad\uc2a4<\/a> \uac01\uac01 \uace0\uc720\ud55c \ubc29\uc5b8 \uad6c\ubb38 \ubd84\uc11d\uae30\uac00 \ub3d9\uc77c\ud55c \ub3c4\uad6c \ub0b4\uc5d0 \uc788\uc73c\ubbc0\ub85c \uc6d0\ubcf8 \ud658\uacbd\uacfc \uc7ac\uc791\uc131\ub41c \ub300\uc0c1 \ud658\uacbd\uc744 \ub098\ub780\ud788 \ubd84\uc11d\ud558\uace0 \uc0c8 \uacc4\ubcf4\uac00 \uc774\uc804 \uacc4\ubcf4\uc640 \uc77c\uce58\ud558\ub294\uc9c0 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc2e4\ud589 \ubc29\ubc95<\/h2>\n\n\n\n<ul><li><strong>HQL \ud30c\uc77c\uc744 \ubd99\uc5ec\ub123\uac70\ub098 \uc5c5\ub85c\ub4dc\ud558\uc138\uc694.<\/strong> SQLFlow \ud074\ub77c\uc6b0\ub4dc(\ubb34\ub8cc \ud2f0\uc5b4)\uc5d0\uc11c\ub294 \uacb0\uacfc\ub97c \ube0c\ub77c\uc6b0\uc800\uc5d0\uc11c \ubc14\ub85c \ud655\uc778\ud560 \uc218 \uc788\uc73c\uba70, JSON, CSV \ub610\ub294 PNG \ud615\uc2dd\uc73c\ub85c \ub0b4\ubcf4\ub0bc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\uba54\ud0c0\uc2a4\ud1a0\uc5b4\uc5d0\uc11c \uba54\ud0c0\ub370\uc774\ud130\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/strong> JDBC\ub97c \ud1b5\ud574 \ubdf0 \uc815\uc758\uc640 \uc2a4\ud0a4\ub9c8\uac00 \ud574\uacb0\ub429\ub2c8\ub2e4. <code>\uc120\ud0dd\ud558\ub2e4 *<\/code> \ub610\ud55c \uc2a4\ud06c\ub9bd\ud2b8 \uac04 \ucc38\uc870\ub97c \uc62c\ubc14\ub974\uac8c \uc218\ud589\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\uc790\ub3d9\ud654\ud558\uc138\uc694<\/strong> ~\uc744 \ud1b5\ud574 <a href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-restful-api\/\">REST API<\/a> \ub610\ub294 \ud5e4\ub4dc\ub9ac\uc2a4 CLI\ub97c \uc0ac\uc6a9\ud558\uc5ec CI\uc5d0\uc11c \ubcd1\ud569\ud558\uae30 \uc804\uc5d0 \ubaa8\ub4e0 HQL \ubcc0\uacbd \uc0ac\ud56d\uc744 \ubd84\uc11d\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\ubaa8\ub4e0 \uac83\uc744 \ub124\ud2b8\uc6cc\ud06c \ub0b4\uc5d0\uc11c \ucc98\ub9ac\ud558\uc138\uc694<\/strong> ~\uc640 \ud568\uaed8 <a href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-on-premise-%eb%b2%84%ec%a0%84\/\">\uc628\ud504\ub808\ubbf8\uc2a4 SQLFlow<\/a>Docker \ub610\ub294 Kubernetes \ud658\uacbd(\ud544\uc694\uc2dc \uc5d0\uc5b4\uac2d \uad6c\uc131 \uac00\ub2a5), \uc6d4 $500 \ub610\ub294 \uc120\ud0dd\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\ud615\ubcc4 \uc77c\ud68c\uc131 $4,800. SQL \ud14d\uc2a4\ud2b8\ub97c \ub124\ud2b8\uc6cc\ud06c \uc678\ubd80\ub85c \uc804\uc1a1\ud560 \uc218 \uc5c6\ub294 \uc740\ud589 \ubc0f \ud1b5\uc2e0 \ud68c\uc0ac\uc640 \uac19\uc740 \ud658\uacbd\uc5d0 Hadoop\uc774 \ub9ce\uc774 \uc124\uce58\ub418\uc5b4 \uc788\uc73c\ubbc0\ub85c, \uc774 \uc5d0\ub514\uc158\uc740 \uc774\ub7ec\ud55c \ud658\uacbd\uc744 \uc704\ud574 \ub9c8\ub828\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<p>SQLFlow\ub294 \ubaa8\ub4e0 \ubc30\ud3ec \ud658\uacbd\uc5d0\uc11c \uc815\uc801 \ubd84\uc11d\ub9cc \uc218\ud589\ud569\ub2c8\ub2e4. SQL \ucf54\ub4dc\uc640 \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\ub9cc \uc77d\uace0 \ud14c\uc774\ube14\uc758 \ud589\uc740 \uc77d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ubc84\uc804 8.2.3\ubd80\ud130\ub294 \uacb0\uacfc \uadf8\ub798\ud504\ub97c \uc77c\ubc18\uc801\uc778 \uc601\uc5b4 \ud45c\ud604(&quot;\uc5b4\ub5a4 \ud14c\uc774\ube14\uc774 \ub2e4\uc74c\uc5d0 \uc758\uc874\ud558\ub294\uc9c0&quot;)\uc73c\ub85c \ucffc\ub9ac\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <code>\uc2a4\ud14c\uc774\uc9d5.\uc8fc\ubb38<\/code>\ub2f5\ubcc0\uc758 \ubaa8\ub4e0 \ud45c\uc640 \uc5f4\uc740 \ud45c\uc2dc\ud558\uae30 \uc804\uc5d0 \ubd84\uc11d\ub41c \uadf8\ub798\ud504\uc640 \ube44\uad50\ud558\uc5ec \uc720\ud6a8\uc131\uc744 \uac80\uc0ac\ud569\ub2c8\ub2e4. \ub354 \uc790\uc138\ud55c \uae30\ub2a5 \ub458\ub7ec\ubcf4\uae30\ub294 \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc138\uc694. <a href=\"https:\/\/www.gudusoft.com\/ko\/sql-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4-%eb%8f%84%ea%b5%ac\/\">SQL \ub370\uc774\ud130 \uacc4\ubcf4 \ub3c4\uad6c \uac1c\uc694<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc790\uc8fc \ubb3b\ub294 \uc9c8\ubb38<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 \ud074\ub7ec\uc2a4\ud130\uc5d0 \uc811\uadfc\ud558\uc9c0 \uc54a\uace0\ub3c4 Hive \uacc4\ubcf4\ub97c \uad6c\ucd95\ud560 \uc218 \uc788\uc2b5\ub2c8\uae4c?<\/h3>\n\n\n<p>\ub124. SQLFlow\ub294 HQL \ud14d\uc2a4\ud2b8\ub97c \ud30c\uc2f1\ud558\ubbc0\ub85c \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ub0b4\ubcf4\ub0b4\uba74 (\uc815\ud655\ud55c \uacb0\uacfc\ub97c \uc5bb\uc73c\ub824\uba74 DDL\ub3c4 \ud3ec\ud568) \ub429\ub2c8\ub2e4. <code>\uc120\ud0dd\ud558\ub2e4 *<\/code> \ud574\uc0c1\ub3c4)\uba74 \ucda9\ubd84\ud569\ub2c8\ub2e4. \uc774\uac83\uc774 Apache Atlas\uc640 \uac19\uc740 \ud6c4\ud06c \uae30\ubc18 \uc811\uadfc \ubc29\uc2dd\uacfc\uc758 \ud575\uc2ec\uc801\uc778 \ucc28\uc774\uc810\uc785\ub2c8\ub2e4. \ud6c4\ud06c \uae30\ubc18 \uc811\uadfc \ubc29\uc2dd\uc740 \ud6c4\ud06c\uac00 \uc124\uce58\ub41c \uc2e4\uc81c \ud074\ub7ec\uc2a4\ud130\uc5d0\uc11c \uc791\uc5c5\uc774 \uc2e4\ud589\ub420 \ub54c\ub9cc \uacc4\ubcf4\ub97c \ucea1\ucc98\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">LATERAL VIEW explode \ubc0f \uae30\ud0c0 Hive \uad00\ub828 \uad6c\ubb38\uc744 \uc9c0\uc6d0\ud569\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc608. Hive\ub294 SQLFlow\uc758 39\uac1c \ubc29\uc5b8 \ud30c\uc11c \uc911 \uc790\uccb4 \uc804\uc6a9 \ud30c\uc11c\ub97c \ubcf4\uc720\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. <code>\uce21\uba74 \ubcf4\uae30 explode()<\/code>\ubd84\ud560\ub428 <code>\uc0bd\uc785 \ub36e\uc5b4\uc4f0\uae30<\/code>\uadf8\ub9ac\uace0 \uc678\ubd80 \ud14c\uc774\ube14.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uacc4\ubcf4\uac00 \uceec\ub7fc \uc218\uc900\uc778\uac00\uc694, \uc544\ub2c8\uba74 \ud14c\uc774\ube14 \uc218\uc900\uc778\uac00\uc694?<\/h3>\n\n\n<p>\uceec\ub7fc \uc218\uc900. SQLFlow\ub294 \uac01 \ucd9c\ub825 \uceec\ub7fc\uc5d0 \ub300\ud574 \ud574\ub2f9 \uceec\ub7fc\uc744 \uad6c\ub3d9\ud558\ub294 \uc815\ud655\ud55c \uc18c\uc2a4 \uceec\ub7fc\uacfc \uadf8 \uacfc\uc815\uc5d0\uc11c \uc0ac\uc6a9\ub41c \ud568\uc218, \ud615\ubcc0\ud658, \uc870\uc778 \ubc0f \uc9d1\ud569 \uc5f0\uc0b0\uc790\ub97c \uc2dd\ubcc4\ud569\ub2c8\ub2e4. \ub610\ud55c \uac04\uc811\uc801\uc778 \uacc4\ubcf4, \uc989 \ub2e4\ub978 \uceec\ub7fc\uc5d0\uc11c \uc0ac\uc6a9\ub41c \uceec\ub7fc\ub3c4 \uae30\ub85d\ud569\ub2c8\ub2e4. <code>\uc5b4\ub514<\/code>, <code>\uac00\uc785\ud558\ub2e4<\/code>, \uadf8\ub9ac\uace0 <code>\uadf8\ub8f9\ud654 \uae30\uc900<\/code> \uacb0\uacfc\uc5d0 \uc9c1\uc811\uc801\uc73c\ub85c \ub098\ud0c0\ub098\uc9c0\ub294 \uc54a\uc9c0\ub9cc \uacb0\uacfc\ub97c \ud615\uc131\ud558\ub294 \uc870\ud56d\ub4e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Hive \uacc4\ubcf4\ub97c \ub370\uc774\ud130 \uce74\ud0c8\ub85c\uadf8\ub85c \ub0b4\ubcf4\ub0bc \uc218 \uc788\ub098\uc694?<\/h3>\n\n\n<p>\uc608. \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ubc30\ud3ec\uc5d0\ub294 DataHub, Microsoft Purview \ubc0f OpenMetadata\uc6a9 \ub0b4\ubcf4\ub0b4\uae30 \uc5b4\ub311\ud130\uc640 JSON \ubc0f CSV \ub0b4\ubcf4\ub0b4\uae30, \uc0ac\uc6a9\uc790 \uc9c0\uc815 \ud1b5\ud569\uc744 \uc704\ud55c REST API\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 Hive \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ub41c \ub370\uc774\ud130\ub97c \uc77d\uc744 \uc218 \uc788\ub098\uc694?<\/h3>\n\n\n<p>\uc544\ub2c8\uc694. SQL \ucf54\ub4dc\uc5d0 \ub300\ud55c \uc815\uc801 \ubd84\uc11d\uc744 \uc218\ud589\ud558\uace0 \uc120\ud0dd\uc801\uc73c\ub85c \uba54\ud0c0\uc2a4\ud1a0\uc5b4\uc5d0\uc11c \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\ub97c \uc77d\uc2b5\ub2c8\ub2e4. \ud14c\uc774\ube14 \ud589 \ub370\uc774\ud130\ub294 \uc808\ub300 \uac74\ub4dc\ub9ac\uc9c0 \uc54a\uc73c\uba70, \uc628\ud504\ub808\ubbf8\uc2a4 \ubc84\uc804\uc758 \uacbd\uc6b0 SQL \ud14d\uc2a4\ud2b8 \uc790\uccb4\ub294 \ub124\ud2b8\uc6cc\ud06c\ub97c \ubc97\uc5b4\ub098\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow \ube44\uc6a9\uc740 \uc5bc\ub9c8\uc778\uac00\uc694?<\/h3>\n\n\n<p>SQLFlow Cloud\ub294 \ubb34\ub8cc\ub85c \uc2dc\uc791\ud558\uba70, \ud504\ub9ac\ubbf8\uc5c4 \uacc4\uc815\uc740 \uc6d4 $49.99\uc785\ub2c8\ub2e4. SQLFlow On-Premise\ub294 \uc120\ud0dd\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\ud615\ub2f9 \uc6d4 $500 \ub610\ub294 \uc77c\ud68c\uc131 $4,800\uc774\uba70, \ub450 \ub300\uc758 \uc11c\ubc84\uc5d0 \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ucd94\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\ud615\uc740 \uac01\uac01 \uc6d4 $100 \ub610\ub294 \uc77c\ud68c\uc131 $1,000\uc5d0 \ucd94\uac00\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained\" style=\"background-color:#60d5f6;padding-top:32px;padding-bottom:32px\"><div class=\"wp-block-group__inner-container\">\n\n<h2 class=\"wp-block-heading\">\ud558\uc774\ube0c \uc601\uc9c0\uc758 \uacc4\ubcf4\ub97c \uc9c0\ub3c4\uc5d0 \ud45c\uc2dc\ud558\uc138\uc694<\/h2>\n\n\n<p>\ubb34\ub8cc \uc2dc\uac01\ud654 \ub3c4\uad6c\uc5d0 HQL \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ubd99\uc5ec\ub123\uac70\ub098, \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc2dc\uc791 \uc804\uc5d0 \uc804\uccb4 \ud558\ub461 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub97c \uc77c\uad04 \uc2a4\uce94\ud558\ub294 \uac83\uc5d0 \ub300\ud574 \uc800\ud76c\uc640 \uc0c1\ub2f4\ud558\uc138\uc694.<\/p>\n\n\n<div class=\"wp-block-buttons is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=hive-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">SQLFlow\ub97c \ubb34\ub8cc\ub85c \uc0ac\uc6a9\ud574 \ubcf4\uc138\uc694.<\/a><\/div>\n<\/div>\n\n\n<div class=\"wp-block-buttons is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.gudusoft.com\/ko\/%ec%97%b0%eb%9d%bd%ed%95%98%eb%8b%a4\/\">\uae30\uc5c5\uc6a9 \ub370\ubaa8\ub97c \uc694\uccad\ud558\uc138\uc694<\/a><\/div>\n<\/div>\n\n<\/div><\/div>\n\n\n\n<script type=\"application\/ld+json\">{\n    \"@context\": \"https:\\\/\\\/schema.org\",\n    \"@graph\": [\n        {\n            \"@type\": \"SoftwareApplication\",\n            \"name\": \"Gudu SQLFlow\",\n            \"applicationCategory\": \"DeveloperApplication\",\n            \"applicationSubCategory\": \"SQL Data Lineage Tool\",\n            \"operatingSystem\": \"Web, Linux, Windows, macOS\",\n            \"url\": \"https:\\\/\\\/www.gudusoft.com\\\/hive-data-lineage\\\/\",\n            \"description\": \"Automated data lineage for Apache Hive: a dedicated HiveQL parser produces interactive column-level lineage diagrams from HQL scripts \\u2014 LATERAL VIEW, partitioned INSERT OVERWRITE, external tables \\u2014 with no running cluster required.\",\n            \"featureList\": \"Hive dialect parser, column-level lineage, indirect\\\/impact lineage, LATERAL VIEW explode support, partitioned INSERT OVERWRITE, batch estate scanning, DataHub\\\/Purview\\\/OpenMetadata export, REST API, on-premise deployment\",\n            \"softwareVersion\": \"8.2.3\",\n            \"offers\": [\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow Cloud Free\",\n                    \"price\": \"0\",\n                    \"priceCurrency\": \"USD\"\n                },\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow Cloud Premium\",\n                    \"price\": \"49.99\",\n                    \"priceCurrency\": \"USD\",\n                    \"priceSpecification\": {\n                        \"@type\": \"UnitPriceSpecification\",\n                        \"price\": \"49.99\",\n                        \"priceCurrency\": \"USD\",\n                        \"billingIncrement\": 1,\n                        \"unitText\": \"MONTH\"\n                    }\n                },\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow On-Premise\",\n                    \"price\": \"4800\",\n                    \"priceCurrency\": \"USD\"\n                }\n            ],\n            \"publisher\": {\n                \"@type\": \"Organization\",\n                \"name\": \"Gudu Software\",\n                \"url\": \"https:\\\/\\\/www.gudusoft.com\\\/\"\n            }\n        },\n        {\n            \"@type\": \"FAQPage\",\n            \"mainEntity\": [\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can SQLFlow build Hive lineage without access to the cluster?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. SQLFlow parses HQL text, so an export of your scripts plus DDL is enough. Hook-based approaches like Apache Atlas capture lineage only when jobs execute on a live cluster with the hook installed.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does it handle LATERAL VIEW explode and other Hive-specific syntax?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. Hive has its own dedicated parser among SQLFlow's 39 dialect parsers, covering LATERAL VIEW explode(), partitioned INSERT OVERWRITE, and external tables.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Is the lineage column-level or table-level?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Column-level. For each output column, SQLFlow identifies the exact source columns that feed it and the functions, casts, joins, and set operators along the way, plus indirect lineage from WHERE, JOIN, and GROUP BY clauses.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can I export Hive lineage to my data catalog?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. Enterprise deployments include export adapters for DataHub, Microsoft Purview, and OpenMetadata, plus JSON and CSV export and a REST API for custom integrations.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does SQLFlow read the data stored in my Hive tables?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"No. It performs static analysis of SQL code and optionally reads schema metadata from the metastore. Table row data is never touched, and with the On-Premise edition the SQL text never leaves your network.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"What does SQLFlow cost?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"SQLFlow Cloud starts free; premium is $49.99\\\/month. SQLFlow On-Premise is $500\\\/month or $4,800 one-time per selected database type, installable on two servers, with additional database types at $100\\\/month or $1,000 one-time each.\"\n                    }\n                }\n            ]\n        }\n    ]\n}<\/script>","protected":false},"excerpt":{"rendered":"<p>Hive data lineage is the column-level map of how data flows through your HQL: which source tables and columns feed each Hive table, partition, and view, and through which joins, aggregations, and LATERAL VIEW expansions. The most reliable way to build it is to parse the HQL itself \u2014 Gudu SQLFlow ships a dedicated Hive dialect parser that turns your scripts into an interactive, column-level lineage diagram without touching your cluster. Try it now: paste any HiveQL script into the free online Hive lineage visualizer, select the Hive dialect, and get a column-level lineage diagram in seconds. No cluster access\u2026<\/p>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"_links":{"self":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/6758"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/comments?post=6758"}],"version-history":[{"count":0,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/6758\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=6758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}