{"id":1532,"date":"2020-03-11T22:27:22","date_gmt":"2020-03-11T13:27:22","guid":{"rendered":"https:\/\/oboki.net\/?p=1532"},"modified":"2020-05-06T22:28:30","modified_gmt":"2020-05-06T13:28:30","slug":"from_utc_timestamp-%ed%83%80%ec%9e%84%ec%a1%b4-%ec%b2%98%eb%a6%ac","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/database\/impala\/from_utc_timestamp-%ed%83%80%ec%9e%84%ec%a1%b4-%ec%b2%98%eb%a6%ac\/","title":{"rendered":"[impala] from_utc_timestamp \ud0c0\uc784\uc874 \ucc98\ub9ac"},"content":{"rendered":"<p>HUE\ub294 \ud0c0\uc784\uc874\uc774 UTC \ub85c \ud558\ub4dc\ucf54\ub4dc \ub3fc \uc788\uc5b4\uc11c \uc124\uc815\uc744 \ud1b5\ud574 \uae30\ubcf8 \ud0c0\uc784\uc874\uc744 \ubc14\uafd4\uc904 \uc218\ub294 \uc5c6\ub2e4\uace0 \ud55c\ub2e4. <\/p>\n<p>impala 3.1 \ubc84\uc804 \ubd80\ud130\ub294 TIMEZONE \uc124\uc815\uc774 \uc0dd\uacbc\ub2e4\uace0\ub294 \ud558\ub294\ub370 \ucd5c\uc2e0 HUE \uc5d0\uc11c\ub3c4 \uc124\uc815\uc774 \uac00\ub2a5\ud560 \uc9c0\ub294 \ubaa8\ub974\uaca0\ub2e4. \ud14c\uc2a4\ud2b8 \ud658\uacbd\uc778 v2.10.0-cdh5.13.0 \ubc84\uc804\uc5d0\uc11c\ub294 impala \uc790\uccb4\uc801\uc73c\ub85c\ub3c4 \ud0c0\uc784\uc874\uc744 \ubcc0\uacbd\ud560 \uc218 \uc5c6\ub2e4.<\/p>\n<p>\uc5b4\uca0b\ub4e0 <code>from_utc_timestamp<\/code> \ud568\uc218\ub97c \uc774\uc6a9\ud574 \ucffc\ub9ac \ub808\ubca8\uc5d0\uc11c \ud0c0\uc784\uc874 \ucc98\ub9ac\uac00 \uac00\ub2a5\ud55c\ub370, \ud0c0\uc784\uc874 \ucf54\ub4dc\ub97c <code>&#039;KST&#039;<\/code>\ub85c \uc798\ubabb \ub123\uc5b4\uc11c \uc624\ub7ab\ub3d9\uc548 \uc0bd\uc9c8\uc744 \ud588\ub2e4.<\/p>\n<pre><code class=\"language-sql\">from_utc_timestamp(evnt_dttm, &#039;ROK&#039;)<\/code><\/pre>\n<p>\ucc3e\uc544\ubcf4\ub2c8 \ub300\ud55c\ubbfc\uad6d \ud45c\uc900\uc2dc\uc758 \uacbd\uc6b0 <code>&#039;KST&#039;<\/code> \uac00 \uc544\ub2cc <code>&#039;ROK&#039;<\/code> \ub85c \ud0c0\uc784\uc874 \uc774\ub984\uc774 \ubcc0\uacbd\ub418\uc5c8\uace0 \ub2e4\uc74c URL \uc5d0\uc11c \ubcc0\uacbd\ub41c \ud0c0\uc784\uc874\ub4e4\uacfc \ud604\uc7ac \uc0ac\uc6a9 \uac00\ub2a5\ud55c \uc774\ub984\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n<p><a href=\"https:\/\/docs.cloudera.com\/documentation\/enterprise\/6\/release-notes\/topics\/rg_cdh_600_unsupported_tz.html\">https:\/\/docs.cloudera.com\/documentation\/enterprise\/6\/release-notes\/topics\/rg_cdh_600_unsupported_tz.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>HUE\ub294 \ud0c0\uc784\uc874\uc774 UTC \ub85c \ud558\ub4dc\ucf54\ub4dc \ub3fc \uc788\uc5b4\uc11c \uc124\uc815\uc744 \ud1b5\ud574 \uae30\ubcf8 \ud0c0\uc784\uc874\uc744 \ubc14\uafd4\uc904 \uc218\ub294 \uc5c6\ub2e4\uace0 \ud55c\ub2e4. impala 3.1 \ubc84\uc804 \ubd80\ud130\ub294 TIMEZONE \uc124\uc815\uc774 \uc0dd\uacbc\ub2e4\uace0\ub294 \ud558\ub294\ub370 \ucd5c\uc2e0 HUE \uc5d0\uc11c\ub3c4 \uc124\uc815\uc774 \uac00\ub2a5\ud560 \uc9c0\ub294 \ubaa8\ub974\uaca0\ub2e4. \ud14c\uc2a4\ud2b8 \ud658\uacbd\uc778 v2.10.0-cdh5.13.0 \ubc84\uc804\uc5d0\uc11c\ub294 impala \uc790\uccb4\uc801\uc73c\ub85c\ub3c4 \ud0c0\uc784\uc874\uc744 \ubcc0\uacbd\ud560 \uc218 \uc5c6\ub2e4. \uc5b4\uca0b\ub4e0 from_utc_timestamp \ud568\uc218\ub97c \uc774\uc6a9\ud574 \ucffc\ub9ac \ub808\ubca8\uc5d0\uc11c \ud0c0\uc784\uc874 \ucc98\ub9ac\uac00 \uac00\ub2a5\ud55c\ub370, \ud0c0\uc784\uc874 \ucf54\ub4dc\ub97c &#039;KST&#039;\ub85c \uc798\ubabb \ub123\uc5b4\uc11c \uc624\ub7ab\ub3d9\uc548 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[161],"tags":[195,170,196,197,194],"class_list":["post-1532","post","type-post","status-publish","format-standard","hentry","category-impala","tag-from_utc_timestamp","tag-impala","tag-kst","tag-rok","tag-timezone"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1532","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/comments?post=1532"}],"version-history":[{"count":0,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1532\/revisions"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=1532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=1532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=1532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}