{"id":1633,"date":"2015-02-23T17:29:13","date_gmt":"2015-02-23T16:29:13","guid":{"rendered":"https:\/\/bob-team.de\/wordpress\/?p=1633"},"modified":"2015-02-23T17:29:13","modified_gmt":"2015-02-23T16:29:13","slug":"pig-kennenlernen","status":"publish","type":"post","link":"https:\/\/bob-team.de\/wordpress\/2015\/02\/23\/pig-kennenlernen\/","title":{"rendered":"Pig kennenlernen"},"content":{"rendered":"<p><code>pig -x local<br \/>\nA = LOAD '\/home\/admin\/150214.CSV' USING PigStorage(';') AS (tag:int,zeit:chararray,username:chararray);<br \/>\nDESCRIBE A;<br \/>\nILLUSTRATE A;<br \/>\nB = GROUP A BY username;<br \/>\nC = FOREACH B GENERATE group, COUNT(A.tag) as tag_count;<br \/>\nD = ORDER C BY tag_count;<br \/>\nSTORE D INTO '\/home\/admin\/user_count_sorted.txt' USING PigStorage();<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>pig -x local A = LOAD &#8218;\/home\/admin\/150214.CSV&#8216; USING PigStorage(&#8218;;&#8216;) AS (tag:int,zeit:chararray,username:chararray); DESCRIBE A; ILLUSTRATE A; B = GROUP A BY username; C = FOREACH B GENERATE group, COUNT(A.tag) as tag_count; D = ORDER C BY tag_count; STORE D INTO &#8218;\/home\/admin\/user_count_sorted.txt&#8216; USING PigStorage();<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1633","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"_links":{"self":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts\/1633","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/comments?post=1633"}],"version-history":[{"count":1,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts\/1633\/revisions"}],"predecessor-version":[{"id":1634,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts\/1633\/revisions\/1634"}],"wp:attachment":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/media?parent=1633"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/categories?post=1633"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/tags?post=1633"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}