Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the input data [(1pm, $10), (2pm, $15), (3pm, $15), (4pm, $20), (5pm, $10), (6pm, $20), (7pm, $30), (8pm, $25), (9pm, $25), (10pm, $30), (11pm,

Given the input data [(1pm, $10), (2pm, $15), (3pm, $15), (4pm, $20), (5pm, $10), (6pm, $20), (7pm, $30), (8pm, $25), (9pm, $25), (10pm, $30), (11pm, $30)]. a) What will the Hive (or Oracle/SQL) query compute average price return? (yes, this is as obvious as it seems, asked for comparison with following parts)

b) What will a Storm query compute average price per each 3 hour window return? (tumbling, i.e., non-overlapping window of tuples, as many as you can fit).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions