{"id":19585,"date":"2024-03-15T19:07:13","date_gmt":"2024-03-15T19:07:13","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/"},"modified":"2024-03-21T16:03:14","modified_gmt":"2024-03-21T16:03:14","slug":"how-to-specify-character-set-when-creating-a-table-in-a-hive","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/","title":{"rendered":"How to specify character set when creating a table in a hive?"},"content":{"rendered":"<p>In Hive, you can specify the character set by using the ROW FORMAT DELIMITED clause in the CREATE TABLE statement.<\/p>\n<p>Here is an example:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">TABLE<\/span> my_table (\r\n  col1 STRING,\r\n  col2 <span class=\"hljs-type\">INT<\/span>\r\n)\r\n<span class=\"hljs-type\">ROW<\/span> FORMAT DELIMITED\r\nFIELDS TERMINATED <span class=\"hljs-keyword\">BY<\/span> <span class=\"hljs-string\">','<\/span>\r\nSTORED <span class=\"hljs-keyword\">AS<\/span> TEXTFILE\r\nLOCATION <span class=\"hljs-string\">'\/path\/to\/table'<\/span>\r\nTBLPROPERTIES (<span class=\"hljs-string\">'charset'<\/span><span class=\"hljs-operator\">=<\/span><span class=\"hljs-string\">'utf8'<\/span>);\r\n<\/code><\/pre>\n<p>In the example above, the field delimiter is specified as a comma using the ROW FORMAT DELIMITED clause, and the character set is specified as UTF-8 using the TBLPROPERTIES clause. You can replace the character set with a different one according to your needs.<\/p>\n<p>Please note that the character set specification method mentioned above applies to text file storage formats such as TEXTFILE. If you are using other storage formats like ORC or Parquet, you may need to use a different method to specify the character set. For more information, refer to the Hive documentation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Hive, you can specify the character set by using the ROW FORMAT DELIMITED clause in the CREATE TABLE statement. Here is an example: CREATE TABLE my_table ( col1 STRING, col2 INT ) ROW FORMAT DELIMITED FIELDS TERMINATED BY &#8216;,&#8217; STORED AS TEXTFILE LOCATION &#8216;\/path\/to\/table&#8217; TBLPROPERTIES (&#8216;charset&#8217;=&#8217;utf8&#8217;); In the example above, the field delimiter is [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-19585","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to specify character set when creating a table in a hive? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to specify character set when creating a table in a hive?\" \/>\n<meta property=\"og:description\" content=\"In Hive, you can specify the character set by using the ROW FORMAT DELIMITED clause in the CREATE TABLE statement. Here is an example: CREATE TABLE my_table ( col1 STRING, col2 INT ) ROW FORMAT DELIMITED FIELDS TERMINATED BY &#039;,&#039; STORED AS TEXTFILE LOCATION &#039;\/path\/to\/table&#039; TBLPROPERTIES (&#039;charset&#039;=&#039;utf8&#039;); In the example above, the field delimiter is [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T19:07:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T16:03:14+00:00\" \/>\n<meta name=\"author\" content=\"Isabella Edwards\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Isabella Edwards\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/\"},\"author\":{\"name\":\"Isabella Edwards\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd\"},\"headline\":\"How to specify character set when creating a table in a hive?\",\"datePublished\":\"2024-03-15T19:07:13+00:00\",\"dateModified\":\"2024-03-21T16:03:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/\"},\"wordCount\":131,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/\",\"name\":\"How to specify character set when creating a table in a hive? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T19:07:13+00:00\",\"dateModified\":\"2024-03-21T16:03:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to specify character set when creating a table in a hive?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd\",\"name\":\"Isabella Edwards\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g\",\"caption\":\"Isabella Edwards\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/isabellaedwards\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to specify character set when creating a table in a hive? - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/","og_locale":"en_US","og_type":"article","og_title":"How to specify character set when creating a table in a hive?","og_description":"In Hive, you can specify the character set by using the ROW FORMAT DELIMITED clause in the CREATE TABLE statement. Here is an example: CREATE TABLE my_table ( col1 STRING, col2 INT ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE LOCATION '\/path\/to\/table' TBLPROPERTIES ('charset'='utf8'); In the example above, the field delimiter is [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T19:07:13+00:00","article_modified_time":"2024-03-21T16:03:14+00:00","author":"Isabella Edwards","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Isabella Edwards","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/"},"author":{"name":"Isabella Edwards","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd"},"headline":"How to specify character set when creating a table in a hive?","datePublished":"2024-03-15T19:07:13+00:00","dateModified":"2024-03-21T16:03:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/"},"wordCount":131,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/","name":"How to specify character set when creating a table in a hive? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T19:07:13+00:00","dateModified":"2024-03-21T16:03:14+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-specify-character-set-when-creating-a-table-in-a-hive\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to specify character set when creating a table in a hive?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd","name":"Isabella Edwards","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g","caption":"Isabella Edwards"},"url":"https:\/\/www.silicloud.com\/blog\/author\/isabellaedwards\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/19585","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=19585"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/19585\/revisions"}],"predecessor-version":[{"id":53335,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/19585\/revisions\/53335"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=19585"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=19585"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=19585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}