Re: Unit testing macros

2016-09-30 Thread Per Ullberg
fined(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 L

Re: Unit testing macros

2016-09-30 Thread Per Ullberg
es HQL scripts as > actions. Doesn't look like it provides support for such features. > So, it would seem that my current options are either to use shell action > instead or do some magic with concatenation of scripts before main action's > execution. > A first-class command l

Re: Query consuming all resources

2016-09-28 Thread Per Ullberg
rces, which is not desirable to us, since we want to grant some degree > of parallelism to incoming ones: any incoming query should be able to do at > least some progress, not just wait the big one finish. > > > > Is there way to do so? We use Hive 2.1.0 with Tez engine. > > &

Re: Hive metadata on Hbase

2016-10-23 Thread Per Ullberg
Use it at your own risk. Any and all responsibility for any > loss, damage or destruction of data or any other property which may arise > from relying on this email's technical content is explicitly disclaimed. > The author will in no case be liable for any monetary damages arising from > suc

Re: Hive metadata on Hbase

2016-10-24 Thread Per Ullberg
tly disclaimed. > The author will in no case be liable for any monetary damages arising from > such loss, damage or destruction. > > > > On 24 October 2016 at 06:46, Per Ullberg <per.ullb...@klarna.com > <javascript:_e(%7B%7D,'cvml','per.ullb...@klarna.com');>>

Re: Connect metadata

2016-10-25 Thread Per Ullberg
.. as i am > not started hive server service, bcoz hadoop not installed on my syatem. > > -- > Thanks and > Regards > > Rajendra Bhat > -- *Per Ullberg* Data Vault Tech Lead Odin Uppsala +46 701612693 <+46+701612693> Klarna AB (publ) Sveavägen 46, 111 34 Stockho

Re: Interrogating a uniontype

2016-11-23 Thread Per Ullberg
e"}} >> >> >> If not possible with HQL, would it be possible to implement a UDF that >> can explode the type into something more navigable, like an array, struct, >> or map? >> >> Example when exploded as array: >> >> >> [1,null,null,null]

Re: Unable to retrieve table metadata from hcatalog

2017-05-12 Thread Per Ullberg
file/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > http://talebzadehmich.wordpress.com > > > *Disclaimer:* Use it at your own risk. Any and all responsibility for any > loss, damage or destruction of data or any other property which may arise > from relying

Re: Is 'application' a reserved word?

2018-05-30 Thread Per Ullberg
] but didn't see 'application' on the list of > >>> reserved words. However if I change the column name to anything else > >>> (even 'applicatio') it works. Can someone confirm whether this is a > >>> reserved word? > >>> > >>> Thanks in advance, > >>> Matt > >>> > >>> [1] > >>> > https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Keywords,Non-reservedKeywordsandReservedKeywords > > > > > -- *Per Ullberg* Datavault Tech Lead Odin (Uppsala) Klarna Bank AB (publ) Sveavägen 46, 111 34 Stockholm Tel: +46 8 120 120 00 Reg no: 556737-0431 klarna.com

Re: HiveRunner 3.2.1 released

2018-05-31 Thread Per Ullberg
/>. > > We encourage everyone to upgrade to this new version. > > Thanks, > > Adrian > (on behalf of the HiveRunner committers) > -- *Per Ullberg* Datavault Tech Lead Odin (Uppsala) Klarna Bank AB (publ) Sveavägen 46, 111 34 Stockholm Tel: +46 8 120 120 00 Reg no: 556737-0431 klarna.com