{"id":1428,"date":"2019-09-14T17:30:53","date_gmt":"2019-09-14T08:30:53","guid":{"rendered":"https:\/\/oboki.net\/workspace\/?p=1428"},"modified":"2019-10-05T22:38:38","modified_gmt":"2019-10-05T13:38:38","slug":"impala-data-types","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/sql\/impala-data-types\/","title":{"rendered":"[Impala] Data Types"},"content":{"rendered":"<h1>[Impala] Data Types<\/h1>\n<h2>\uc815\uc218 \uc790\ub8cc\ud615<\/h2>\n<p>Impala\uc5d0\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \ub124 \uc885\ub958\uc758 \uc815\uc218 \uc790\ub8cc\ud615\uc744 \uc81c\uacf5\ud558\uba70 \uac01\uac01 \ucc28\uc9c0\ud558\ub294 \uacf5\uac04\uacfc \ubc94\uc704\uac00 \ub2e4\ub974\ub2e4. \uc624\ub77c\ud074\uc758 <code>TO_CHAR()<\/code>, <code>TO_NUMBER()<\/code> \uc640 \uac19\uc774 \uc22b\uc790\uc640 \ubb38\uc790\uc5f4\uc744 \ubc14\uafc0\uc218 \uc5c6\uace0 <code>CAST(SOME_COLUMN_NAME as datatype_to_cast)<\/code> \ud568\uc218\ub97c \uc774\uc6a9\ud574 \ubcc0\ud615\ud558\uace0\uc790 \ud558\ub294 \ud0c0\uc785\uc744 \uc9c0\uc815\ud574\uc8fc\uc5b4\uc57c\ud558\ub294\ub370 \ud14c\uc774\ube14\uc744 \uc124\uacc4\ud560 \ub54c \uc798\ubabb\ud558\uba74 \uc9c0\uc6d0 \ubc94\uc704\ub97c \ub118\uc5b4\uc11c\ub294 \uc22b\uc790\uac00 \uc0dd\uaca8 \ubb38\uc81c\uac00 \ub420 \uc218 \uc788\uc73c\ubbc0\ub85c \uc8fc\uc758\ub97c \ud574\uc57c\ud560 \uac83 \uac19\ub2e4. \ubc88\uac70\ub86d\uae34 \ud558\uc9c0\ub9cc \uc800\uc7a5\uc18c\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc7a5\uc810\uc774 \uc788\ub294 \uac83 \uac19\ub2e4.<\/p>\n<ul>\n<li>TINYINT\n<ul>\n<li>1 byte<\/li>\n<li>-128 ~ 127<\/li>\n<\/ul>\n<\/li>\n<li>SMALLINT\n<ul>\n<li>2 bytes<\/li>\n<li>-32768 ~ 32767<\/li>\n<\/ul>\n<\/li>\n<li>INT\n<ul>\n<li>4 bytes<\/li>\n<li>-2147483648 ~ 214748364<\/li>\n<\/ul>\n<\/li>\n<li>BIGINT\n<ul>\n<li>8 bytes<\/li>\n<li>-9223372036854775808 ~ 9223372036854775807<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>SQL \ud568\uc218\ub85c \ud574\ub2f9 \uc815\uc218 \uc790\ub8cc\ud615\uc758 min max \ub97c \ud638\ucd9c\ud574\ubcfc \uc218\ub3c4 \uc788\ub294\ub370 \uc2a4\ud06c\ub9bd\ud2b8 \uc5b8\uc5b4 \uac19\uc740 \ub290\ub08c\uc774 \uc7ac\ubbf8\uc788\ub2e4.<\/p>\n<pre><code class=\"language-sql\">select &#039;TINYINT&#039; as type, min_tinyint() as min, max_tinyint() as max\nselect &#039;SMALLINT&#039;, min_smallint() as min, max_smallint() as max\nselect &#039;INT&#039; as type, min_int() as min, max_int() as max\nselect &#039;BIGINT&#039; as type, min_bigint() as min, max_bigint() as max\n<\/code><\/pre>\n<p><del>\ucd94\uac00\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\uac8c \ub418\ub294 \uc790\ub8cc\ud615 \ubcc4\ub85c \uc815\ub9ac\ud560 \uc608\uc815<\/del><\/p>\n<h2>\uc2e4\uc218 \uc790\ub8cc\ud615<\/h2>\n","protected":false},"excerpt":{"rendered":"<p>[Impala] Data Types \uc815\uc218 \uc790\ub8cc\ud615 Impala\uc5d0\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \ub124 \uc885\ub958\uc758 \uc815\uc218 \uc790\ub8cc\ud615\uc744 \uc81c\uacf5\ud558\uba70 \uac01\uac01 \ucc28\uc9c0\ud558\ub294 \uacf5\uac04\uacfc \ubc94\uc704\uac00 \ub2e4\ub974\ub2e4. \uc624\ub77c\ud074\uc758 TO_CHAR(), TO_NUMBER() \uc640 \uac19\uc774 \uc22b\uc790\uc640 \ubb38\uc790\uc5f4\uc744 \ubc14\uafc0\uc218 \uc5c6\uace0 CAST(SOME_COLUMN_NAME as datatype_to_cast) \ud568\uc218\ub97c \uc774\uc6a9\ud574 \ubcc0\ud615\ud558\uace0\uc790 \ud558\ub294 \ud0c0\uc785\uc744 \uc9c0\uc815\ud574\uc8fc\uc5b4\uc57c\ud558\ub294\ub370 \ud14c\uc774\ube14\uc744 \uc124\uacc4\ud560 \ub54c \uc798\ubabb\ud558\uba74 \uc9c0\uc6d0 \ubc94\uc704\ub97c \ub118\uc5b4\uc11c\ub294 \uc22b\uc790\uac00 \uc0dd\uaca8 \ubb38\uc81c\uac00 \ub420 \uc218 \uc788\uc73c\ubbc0\ub85c \uc8fc\uc758\ub97c \ud574\uc57c\ud560 \uac83 \uac19\ub2e4. \ubc88\uac70\ub86d\uae34 \ud558\uc9c0\ub9cc [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[161,160],"tags":[],"class_list":["post-1428","post","type-post","status-publish","format-standard","hentry","category-impala","category-sql"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1428","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/comments?post=1428"}],"version-history":[{"count":0,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1428\/revisions"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=1428"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=1428"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=1428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}