Last active
February 19, 2021 03:28
-
-
Save sunbuhui/9160bc1ea4a1bde20ccbc369bc7df8cf to your computer and use it in GitHub Desktop.
Info and links I need when using Hive lateral view
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| lateral view | |
| 侧视图 | |
| https://cwiki.apache.org/confluence/display/Hive/LanguageManual+LateralView | |
| OUTER | |
| If OUTER specified, returns null if an input array/map is empty or null. | |
| posexplode() is similar to explode but instead of just returning the elements of the array | |
| it returns the element as well as its position in the original array. | |
| https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-posexplode | |
| 没啥大区别，就是加了一个pos |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment