hive

Hive - Unit-testing

Testing is really important for coding. It provide ensuring the code is working. It is really a way to gain rather it is thought as time lost. This is actually another topic sould be discussed in another article. Unit-testing is one of most tough thing among coding phases. If you

Hive - Sliding Last Not Null Value

Hive supports windowing features over columns according to current row. You can see the documantation about windowing functions in Hive at LanguageManual WindowingAndAnalytics. Those functions are not going be the topic in this article. Assume that, you have a dataset contains null value on some columns and you want to

Hive - Custom UDF

Apache Hive is a project which provides SQL dsl which is HiveQL on top of map-reduce in hadoop ecosystem. Mapper(s) and reducer(s) are produced by hive according to given SQL. It is an alternative to Apache Pig. There are too many built-in functions in Hive. But sometimes we