Lab Sql

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 a hive table as below with 5 columns name orderno productcategory amount description KJFSFKS… Read more Hive/sql Bundling Columns For Few Columns,rest Of The Columns Are Pull Based Lowest/highest Of Other Columns

I'm trying to see the value of a calculated value in hive. For example, I'm trying to get t… Read more How To View The Calculated Value Of A Hive Variable

This is a follow-up question to How to pass ElasticSearch query to hadoop. Basically, I want to do … Read more Passing Reduced Es Query Results To Sql

I am working on a project to allow searching on Hadoop. How it works is the query is first passed t… Read more How To Pass Elasticsearch Query To Hadoop