{"id":9810,"date":"2024-03-14T10:12:26","date_gmt":"2024-03-14T10:12:26","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-sorting-methods-in-hive\/"},"modified":"2024-03-20T16:23:48","modified_gmt":"2024-03-20T16:23:48","slug":"what-are-the-commonly-used-sorting-methods-in-hive","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-sorting-methods-in-hive\/","title":{"rendered":"What are the commonly used sorting methods in hive?"},"content":{"rendered":"

\u5e38\u89c1\u7684Hive\u6392\u5e8f\u65b9\u6cd5\u5305\u62ec\uff1a<\/p>\n

    \n
  1. ORDER BY: Sorting the query results by specifying one or more columns. By default, the sorting is in ascending order, but DESC keyword can be used for descending order.<\/li>\n
  2. Sort data before passing it to the reducer. Unlike ORDER BY, SORT BY does not maintain the sorting order in the final output.<\/li>\n
  3. DISTRIBUTE BY: Distribute data to different reducer tasks based on the values of a specified column, and perform local sorting within the reducer tasks. Typically used in conjunction with SORT BY.<\/li>\n
  4. CLUSTER BY: Similar to DISTRIBUTE BY, it partitions data based on the values of a specified column and distributes data with the same value to the same reducer task. The difference is that CLUSTER BY also performs sorting within the reducer task.<\/li>\n
  5. Combining ORDER BY and DISTRIBUTE BY can sort data across multiple reducer tasks and ensure the output remains in order.<\/li>\n<\/ol>\n

    These sorting methods can be selected based on specific needs and data distributions to perform sorting operations.<\/p>\n","protected":false},"excerpt":{"rendered":"

    \u5e38\u89c1\u7684Hive\u6392\u5e8f\u65b9\u6cd5\u5305\u62ec\uff1a ORDER BY: Sorting the query results by specifying one or more columns. By default, the sorting is in ascending order, but DESC keyword can be used for descending order. Sort data before passing it to the reducer. Unlike ORDER BY, SORT BY does not maintain the sorting order in the final output. DISTRIBUTE BY: […]<\/p>\n","protected":false},"author":11,"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-9810","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nWhat are the commonly used sorting methods in 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\/what-are-the-commonly-used-sorting-methods-in-hive\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What are the commonly used sorting methods in hive?\" \/>\n<meta property=\"og:description\" content=\"\u5e38\u89c1\u7684Hive\u6392\u5e8f\u65b9\u6cd5\u5305\u62ec\uff1a ORDER BY: Sorting the query results by specifying one or more columns. By default, the sorting is in ascending order, but DESC keyword can be used for descending order. Sort data before passing it to the reducer. Unlike ORDER BY, SORT BY does not maintain the sorting order in the final output. DISTRIBUTE BY: […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-sorting-methods-in-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-14T10:12:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-20T16:23:48+00:00\" \/>\n<meta name=\"author\" content=\"Olivia Parker\" \/>\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=\"Olivia Parker\" \/>\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\/what-are-the-commonly-used-sorting-methods-in-hive\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-sorting-methods-in-hive\/\"},\"author\":{\"name\":\"Olivia Parker\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\"},\"headline\":\"What are the commonly used sorting methods in hive?\",\"datePublished\":\"2024-03-14T10:12:26+00:00\",\"dateModified\":\"2024-03-20T16:23:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-sorting-methods-in-hive\/\"},\"wordCount\":172,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-sorting-methods-in-hive\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-sorting-methods-in-hive\/\",\"name\":\"What are the commonly used sorting methods in hive? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T10:12:26+00:00\",\"dateModified\":\"2024-03-20T16:23:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-sorting-methods-in-hive\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-sorting-methods-in-hive\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-sorting-methods-in-hive\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What are the commonly used sorting methods in 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\/3ff7b3da0e45ac5dbbef2502f3cea8d9\",\"name\":\"Olivia Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"caption\":\"Olivia Parker\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"What are the commonly used sorting methods in 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\/what-are-the-commonly-used-sorting-methods-in-hive\/","og_locale":"en_US","og_type":"article","og_title":"What are the commonly used sorting methods in hive?","og_description":"\u5e38\u89c1\u7684Hive\u6392\u5e8f\u65b9\u6cd5\u5305\u62ec\uff1a ORDER BY: Sorting the query results by specifying one or more columns. By default, the sorting is in ascending order, but DESC keyword can be used for descending order. Sort data before passing it to the reducer. Unlike ORDER BY, SORT BY does not maintain the sorting order in the final output. DISTRIBUTE BY: […]","og_url":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-sorting-methods-in-hive\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T10:12:26+00:00","article_modified_time":"2024-03-20T16:23:48+00:00","author":"Olivia Parker","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Olivia Parker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-sorting-methods-in-hive\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-sorting-methods-in-hive\/"},"author":{"name":"Olivia Parker","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9"},"headline":"What are the commonly used sorting methods in hive?","datePublished":"2024-03-14T10:12:26+00:00","dateModified":"2024-03-20T16:23:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-sorting-methods-in-hive\/"},"wordCount":172,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-sorting-methods-in-hive\/","url":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-sorting-methods-in-hive\/","name":"What are the commonly used sorting methods in hive? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T10:12:26+00:00","dateModified":"2024-03-20T16:23:48+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-sorting-methods-in-hive\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-sorting-methods-in-hive\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-sorting-methods-in-hive\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"What are the commonly used sorting methods in 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\/3ff7b3da0e45ac5dbbef2502f3cea8d9","name":"Olivia Parker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","caption":"Olivia Parker"},"url":"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/9810","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\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=9810"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/9810\/revisions"}],"predecessor-version":[{"id":43005,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/9810\/revisions\/43005"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=9810"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=9810"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=9810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}