Have you taken a look at https://github.com/klarna/HiveRunner?
regards /Pelle On Fri, Sep 30, 2016 at 11:23 AM, Staņislavs Rogozins < stanislavs.rogoz...@gmail.com> wrote: > The Unit testing wiki page > <https://cwiki.apache.org/confluence/display/Hive/Unit+Testing+Hive+SQL> > suggests > using macros to 'extract and resuse the expressions applied to columns' and > that they can be 'readily isolated for testing'. However as far as I'm > aware, right now only temporary macros can be created, that stop existing > outside of session where they were defined(https://cwiki.apache. > org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create/ > DropMacro), thus making it necessary to include the macro in every HQL > script that uses it. How is it possible to isolate them for testing? > -- *Per Ullberg* Data Vault Tech Lead Odin Uppsala +46 701612693 <+46+701612693> Klarna AB (publ) Sveavägen 46, 111 34 Stockholm Tel: +46 8 120 120 00 <+46812012000> Reg no: 556737-0431 klarna.com