assignment issues

[rimsha1010]

Assignment #4 Quiz - Lakehouse
please share full answer of this

[XinghuaPeng]

Assignment #4 Quiz - Lakehouse please share full answer of this

### Assignment #4 Quiz - Lakehouse
Question 1
How many folders were created? Enter the number of records you see from the output below (include the _delta_log in your count)
Ans: 9

Question 2
Delete all the records where City is null. How many records are left in the delta table?
Ans: 416869

Question 3
After you deleted all records where the City is null, how many files were removed? Hint: Look at operationsMetrics in the transaction log using the DESCRIBE HISTORY command.
Ans: 22

Question 4
There are quite a few missing Call_Type_Group values. Use the UPDATE command to replace any null values with Non Life-threatening.
After you replace the null values, how many Non Life-threatening call types are there?
Ans: 302506

Question 5
Travel back in time to the earliest version of the Delta table (version 0). How many records were there?
Ans: 417419

[samasama-123]

Assignment #2 Quiz - Spark Internals
Please Update answers on this

Question 1
How many fire calls are in our table?

Question 2
How large is our fireCalls dataset in memory? Input just the numeric value (e.g. 51.2)

Question 3
Which Unit Type is most common?

Question 4
What type of transformation, wide or narrow, did the GROUP BY and ORDER BY queries result in?

Question 5
Looking at the query below, how many tasks are in the last stage of the last job?
Answer "2" is incorrect

[rimsha1010]

Hi

…

On Thu, May 25, 2023, 11:13 samasama-123 ***@***.***> wrote: Assignment #2 <#2> Quiz - Spark Internals Please Update answers on this Question 1 How many fire calls are in our table? Question 2 How large is our fireCalls dataset in memory? Input just the numeric value (e.g. 51.2) Question 3 Which Unit Type is most common? Question 4 What type of transformation, wide or narrow, did the GROUP BY and ORDER BY queries result in? Question 5 Looking at the query below, how many tasks are in the last stage of the last job? *Answer "2" is incorrect* — Reply to this email directly, view it on GitHub <#1 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AUTJWBGNLRMCC23P6TALKE3XH3Z7DANCNFSM5OFOSUAQ> . You are receiving this because you authored the thread.Message ID: <KaderDurak/Distributed-Computing-with-Spark-SQL/issues/1/1562335083@ github.com>

[Salemespinoza]

can u post how you do for assignment #1 in Queries with Spark

[rimsha1010]

Hello what's about assignments

…

On Wed, Nov 1, 2023, 21:50 Salemespinoza ***@***.***> wrote: can u post how you do for assignment #1 <#1> in Queries with Spark — Reply to this email directly, view it on GitHub <#1 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AUTJWBGE7JGJ3NKQAAGWJN3YCJ4VBAVCNFSM5OFOSUA2U5DIOJSWCZC7NNSXTN2JONZXKZKDN5WW2ZLOOQ5TCNZYHEZTAMZVG4ZA> . You are receiving this because you authored the thread.Message ID: <KaderDurak/Distributed-Computing-with-Spark-SQL/issues/1/1789303572@ github.com>

[rimsha1010]

Who are you referring to?

…

On Wed, Nov 1, 2023, 22:05 Salemespinoza ***@***.***> wrote: Hello what's about assignments … <#m_-5683171879173831802_> On Wed, Nov 1, 2023, 21:50 Salemespinoza *@*.***> wrote: can u post how you do for assignment #1 <#1> <#1 <#1>> in Queries with Spark — Reply to this email directly, view it on GitHub <#1 (comment) <#1 (comment)>>, or unsubscribe https://github.com/notifications/unsubscribe-auth/AUTJWBGE7JGJ3NKQAAGWJN3YCJ4VBAVCNFSM5OFOSUA2U5DIOJSWCZC7NNSXTN2JONZXKZKDN5WW2ZLOOQ5TCNZYHEZTAMZVG4ZA . You are receiving this because you authored the thread.Message ID: < /issues/1 <#1> /1789303572@ github.com> When I make my queries, I don't get any results SELECT * FROM fireincidents WHERE 'Incident Date'= 2016-04-04 I don't know where is the mistake, I did have the same answers in the first and last question, but I don't get the others. — Reply to this email directly, view it on GitHub <#1 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AUTJWBGCHWDJVBPUUUCHE7DYCJ6NBAVCNFSM5OFOSUA2U5DIOJSWCZC7NNSXTN2JONZXKZKDN5WW2ZLOOQ5TCNZYHEZTENZRGQZQ> . You are receiving this because you authored the thread.Message ID: <KaderDurak/Distributed-Computing-with-Spark-SQL/issues/1/1789327143@ github.com>