...
Info | ||
---|---|---|
| ||
Prior to Hive 0.6.0, lateral view did not support the predicate push-down optimization. In Hive 0.5.0 and earlier, if you used a WHERE clause your query may not have compiled. A workaround was to add |
Info | ||
---|---|---|
| ||
From Hive 0.12.0, column aliases can be omitted. In this case, aliases are inherited from field names of StructObjectInspector which is returned from UTDF. |
Example
Consider the following base table named pageAds
. It has two columns: pageid
(name of the page) and adid_list
(an array of ads appearing on the page):
...
pageid | adid_list | ||
---|---|---|---|
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="529a5ab9bdd35b8b-9a6ba525-40094b47-873fbcef-cbd4ff8b5d8ceac4e9c09bd6"><ac:plain-text-body><![CDATA[ | front_page | [1, 2, 3] | ]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="d704fecf7cb760e6-aba1be7a-4b99410f-bbb4bf7a-263024027894de6d80633d29"><ac:plain-text-body><![CDATA[ | contact_page | [3, 4, 5] | ]]></ac:plain-text-body></ac:structured-macro> |
...
Array<int> col1 | Array<string> col2 | ||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="535a3fb6d234f7b9-27206963-491c4419-82ca8437-96e6ee1c1d40131503d8b5f6"><ac:plain-text-body><![CDATA[ | [1, 2] | [a", "b", "c"] | ]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="0b5fbaa9a5d2d86c-33317269-424048f4-a130b9ba-421563c7fb4aab658e8d3269"><ac:plain-text-body><![CDATA[ | [3, 4] | [d", "e", "f"] | ]]></ac:plain-text-body></ac:structured-macro> |
...
int mycol1 | Array<string> col2 | ||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="21e911cee716afcb-630778b6-4c77466f-b4f89e11-bdc423c899f971a75c301b50"><ac:plain-text-body><![CDATA[ | 1 | [a", "b", "c"] | ]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="f61045de1d74d994-373f46e1-49264927-9a638fd8-d18d150d323018b9d18081bd"><ac:plain-text-body><![CDATA[ | 2 | [a", "b", "c"] | ]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="cedca26f0cb23b18-f40683d6-45804a99-bc2cbe8f-f1505fa376bb823ade6d8558"><ac:plain-text-body><![CDATA[ | 3 | [d", "e", "f"] | ]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="e408f10e79fbf806-ee679870-4c774876-8a2586aa-efcd8bfd12745ffdf86e5dcb"><ac:plain-text-body><![CDATA[ | 4 | [d", "e", "f"] | ]]></ac:plain-text-body></ac:structured-macro> |
...