...
An example table with two rows:
pageid | adid_list | |
---|---|---|
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="126e592f-b97d-4a12-828a-39a324dd8e55"><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="c2cfc901-c940-4f29-8124-70a623c49e5a"><ac:plain-text-body><![CDATA[ |
contact_page | [3, 4, 5] ] ]></ac:plain-text-body></ac:structured-macro> |
and the user would like to count the total number of times an ad appears across all pages.
...
Array<int> col1 | Array<string> col2 <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="202a7aba-e22a-4d68-8429-f1186bcf5c27"><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="52f48610-ddad-4f17-8688-a922f7e5fac2"><ac:plain-text-body><![CDATA[ |
[3, 4] | [d", "e", "f"] ] ]></ac:plain-text-body></ac:structured-macro> |
The query:
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT myCol1, col2 FROM baseTable LATERAL VIEW explode(col1) myTable1 AS myCol1; |
...
int mycol1 | Array<string> col2 <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="c1f2b68c-4892-4327-911e-8c88aa5206cb"><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="1a64376b-33fc-4bca-bb12-56388bcfa61d"><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="0544ff9e-f411-4c64-aa97-77d193e4a713"><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="88e3e02b-53fc-42d6-9ed5-81031a7e6727"><ac:plain-text-body><![CDATA[ |
4 | [d", "e", "f"] ] ]></ac:plain-text-body></ac:structured-macro> |
A query that adds an additional LATERAL VIEW:
...