Skip to content

Tag: hive

Hive – Merge rows with search term substrings

I got a search results log table with search terms in one of the columns. Since the search results are produced as the user types in the search terms, there are multiple rows for each search term with the partial string. For example, as the user types world the resulting rows in the table will be: Expected re…

left join in hive

would anyone kindly answer the question below? Is left join outer join or inner join in hive? (Do we need to type left “outer” join in order to do the outer join? or simply left join works as outer?) Answer Just like in most, if not all, databases, the outer word is optional in left [outer] join, …

Convert from lateral view to case statements in hive

I need to place below code in case statement: I have tried: But getting error. Answer For the provided SQL on table tab1, the actual logic is like: Explode field secondary.tertiary, alias it as lv, which results in a temporary result set (table) tab2; A join-like operation to concatenate tab2’s fields b…