Page History

...

An example table with two rows:

pageid	adid_list
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="371a141a-0038-4582-af52-00790b85b998"><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="e56204a6-2471-46fc-b430-da8bc32628cd"><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="c57333f2-7937-454e-aef8-e478ffb33791"><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="f3ff776d-3a98-4fb2-9bb3-93bf142c2f3b"><ac:plain-text-body><![CDATA[
[3, 4]	[d", "e", "f"] ] ]></ac:plain-text-body></ac:structured-macro>

The query:

Code Block

	sql
	sql

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="e8da723d-1778-4162-af37-89da44d2380b"><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="3b6828e3-4939-403f-bc9d-1bd63557d26c"><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="3b00685a-332a-497d-a5c3-f7b2ae76213d"><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="5310a03d-dfc9-4143-9709-057df542f0bf"><ac:plain-text-body><![CDATA[
4	[d", "e", "f"] ] ]></ac:plain-text-body></ac:structured-macro>

A query that adds an additional LATERAL VIEW:

...

Space shortcuts