hi, i have a table in which I need to calculate the max among the previous 30 days for every record , is there a way in hive with sub queries?, see below for sample data FIELD1 FIELD2 FIELD3 DATE VAR MAX VAR USA TX RTB 20160930 1 USA TX RTB 20161001 1 USA TX RTB 20161002 1 USA TX RTB 20161003 1 USA TX RTB 20161004 1 USA TX RTB 20161005 2 USA TX RTB 20161006 2 USA TX RTB 20161007 2 USA TX RTB 20161008 2 USA TX RTB 20161009 1 USA TX RTB 20161010 2 USA TX RTB 20161011 2 USA TX RTB 20161012 2 USA TX RTB 20161013 2 USA TX RTB 20161014 2 USA TX RTB 20161015 2 USA TX RTB 20161016 2 USA TX RTB 20161017 2 USA TX RTB 20161018 2 USA TX RTB 20161019 2 USA TX RTB 20161020 2 USA TX RTB 20161021 2 USA TX RTB 20161022 2 USA TX RTB 20161023 2 USA TX RTB 20161024 2 USA TX RTB 20161025 3 USA TX RTB 20161026 2 USA TX RTB 20161027 2 USA TX RTB 20161028 2 USA TX RTB 20161029 2 USA TX RTB 20161030 2 3 USA TX RTB 20161031 2 3 USA TX RTB 20161101 2 3 USA TX RTB 20161102 2 3 USA TX RTB 20161103 2 3 USA TX RTB 20161104 2 3 USA TX RTB 20161105 2 3 USA TX RTB 20161106 2 3 USA TX RTB 20161107 2 3 USA TX RTB 20161108 2 3 USA TX RTB 20161109 2 3 USA TX RTB 20161110 2 3 USA TX RTB 20161111 2 3 USA TX RTB 20161112 2 3 USA TX RTB 20161113 2 3 USA TX RTB 20161114 2 3 USA TX RTB 20161115 2 3 USA TX RTB 20161116 2 3 USA TX RTB 20161117 2 3 USA TX RTB 20161118 2 3 USA TX RTB 20161119 2 3 USA TX RTB 20161120 2 3 USA TX RTB 20161121 2 3 USA TX RTB 20161122 2 3 USA TX RTB 20161123 2 3 USA TX RTB 20161124 2 3 USA TX RTB 20161125 2 2 USA TX RTB 20161126 2 2 USA TX RTB 20161127 2 2 USA TX RTB 20161128 2 2 USA TX RTB 20161129 2 2 UK LONDON RTB 20160930 1 UK LONDON RTB 20161001 1 UK LONDON RTB 20161002 1 UK LONDON RTB 20161003 1 UK LONDON RTB 20161004 1 UK LONDON RTB 20161005 1 UK LONDON RTB 20161006 1 UK LONDON RTB 20161007 1 UK LONDON RTB 20161008 1 UK LONDON RTB 20161009 1 UK LONDON RTB 20161010 1 UK LONDON RTB 20161011 1 UK LONDON RTB 20161012 1 UK LONDON RTB 20161013 1 UK LONDON RTB 20161014 1 UK LONDON RTB 20161015 1 UK LONDON RTB 20161016 1 UK LONDON RTB 20161017 1 UK LONDON RTB 20161018 1 UK LONDON RTB 20161019 1 UK LONDON RTB 20161020 1 UK LONDON RTB 20161021 1 UK LONDON RTB 20161022 1 UK LONDON RTB 20161023 1 UK LONDON RTB 20161024 1 UK LONDON RTB 20161025 4 UK LONDON RTB 20161026 2 UK LONDON RTB 20161027 2 UK LONDON RTB 20161028 2 UK LONDON RTB 20161029 2 UK LONDON RTB 20161030 2 4 UK LONDON RTB 20161031 2 4 UK LONDON RTB 20161101 2 4 UK LONDON RTB 20161102 2 4 UK LONDON RTB 20161103 2 4 UK LONDON RTB 20161104 2 4 UK LONDON RTB 20161105 2 4 UK LONDON RTB 20161106 2 4 UK LONDON RTB 20161107 2 4 UK LONDON RTB 20161108 2 4 UK LONDON RTB 20161109 2 4 UK LONDON RTB 20161110 2 4 UK LONDON RTB 20161111 2 4 UK LONDON RTB 20161112 2 4 UK LONDON RTB 20161113 2 4 UK LONDON RTB 20161114 2 4 UK LONDON RTB 20161115 2 4 UK LONDON RTB 20161116 2 4 UK LONDON RTB 20161117 2 4 UK LONDON RTB 20161118 2 4 UK LONDON RTB 20161119 2 4 UK LONDON RTB 20161120 2 4 UK LONDON RTB 20161121 2 4 UK LONDON RTB 20161122 2 4 UK LONDON RTB 20161123 2 4 UK LONDON RTB 20161124 2 4 UK LONDON RTB 20161125 2 2 UK LONDON RTB 20161126 2 2 UK LONDON RTB 20161127 2 2 UK LONDON RTB 20161128 2 2 UK LONDON RTB 20161129 2 2
... View more