Question : I have some daily data and monthly data. I want to compare these two datasets, with Hive and […]
Tag: hive
Query fails sometimes on casting error
Question : I have a query that can run on the same data set, and sometimes it fails and sometimes […]
How can I group the null results in this FULL OUTER JOIN with non-null responses?
Question : I am looking at the overlap and non-overlap (unique values) of users-ids from two different select statements using […]
Hive metrastore Database in Postgresql External [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
HIVE SQL [Error 10025]: Expression not in GROUP BY key
Question : Here is my SQL statement: my_table includes 10+ columns (e.g, day, ip_address, user, request, etc), including strings and […]