Lab Sql

In below Hive-query, I need to read the null / empty 'string' tags as well, from the XML co… Read more In Hive, How To Read Through Null / Empty Tags Present Within An Xml Using Explode(xpath(..)) Function?

I'm trying to transpose a variable in Hive such as: Id1 Id2 Event 1 1 7 2 2 3 2 … Read more Transpose Dataset In Hive

I have a table that contains JSON objects. Each JSON object contains an array in square brackets, s… Read more Sql: Explode An Array

I have a table in hive , with 2 columns as col1 array and col2 array . Output is as shown below co… Read more Hive Sort Array Column With Respect To Other Array Column In Same Table

I have a need for a hive query that I'm having difficulty figuring out. I have a time series th… Read more Temporal Join In Hive Query (events In Close Proximity In Time)

I have spent days trying to figure out how to add missing dates with the nearest values in Hive wit… Read more Hive Sql Query To Fill Missing Date Values In Table With Nearest Values