Here is a small example content of the docword.txt file. docld 3 3 2 1 2 2 3 3 3 1 1 1 vocabld 3 3 2 5 2 1 1 15 14 3 1 c

[answerhappygod]

Here Is A Small Example Content Of The Docword Txt File Docld 3 3 2 1 2 2 3 3 3 1 1 1 Vocabld 3 3 2 5 2 1 1 15 14 3 1 C 1 (23.08 KiB) Viewed 68 times

Question: [spark SQL] Calculate the total count of each word
across all documents. List the words in ascending alphabetical
order. Write the results to “Task_3a-out” in CSV format (multiple
output parts are allowed). So, for the above small example input
the output would be the following:
boat,2200
car,620
motorbike,2502
plane,1100
truck,122
Note: spark SQL will give the output in multiple files. You should
ensure that the data is sorted globally across all the files
(parts). So, all words in part 0, will be alphabetically before the
words in part 1.
Here is a small example content of the docword.txt file. docld 3 3 2 1 2 2 3 3 3 1 1 1 vocabld 3 3 2 5 2 1 1 15 14 3 1 count 600 702 120 200 500 100 2000 122 1200 1000

Here is an example of the vocab.txt file vocabld 1 2 3 4 5 | دي | | C word plane car motorbike truck boat