Using the built-in User Defined Table Function (UDTF)
Normal functions take one row as input and provide one row as transformed output. On the other side, built-in table-generating functions take one row as input and produce multiple output rows.
How to do it…
The built-in table-generating functions could be used directly in the query. The following are some examples of the table-generating functions available in Hive:
Function Name |
Return Type |
Description |
---|---|---|
|
N rows |
It will return |
|
N rows |
It will return |
Get Apache Hive Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.