The dataset consists of 8 columns and their respective description is as follows:
Day of Month
The specified day of the month
Day of Week
The specified day of the week
Unique Carrier Code. When the same code has been used by multiple carriers, a numeric suffix is used for earlier users, for example, PA, PA(1), PA(2). Use this field for analysis across a range of years.
Departure Delay Minutes
Difference in minutes between scheduled and actual departure time. Early departures set to 0.
Arrival Delay Minutes
Difference in minutes between scheduled and actual arrival time. Early arrivals set to 0.
Weather delay in minutes
Querying data stored in HDFS with HIVE
Problem statement :
Write an HQL statement to list all flights whose departure delay time is greater than the average departure delay time and show how much their delay time is greater than the average.
classes, as on account of adding agentive postfix - or to make eliminator) and the distributional angle (to have a comprehension of distributional limitations of sectioned units of a word, as in understanding that making words like printable and decipherable requires adding the addition - ready to the action word, not to the thing; and making words like unlawful, unimaginable, mind blowing, and incapable requires including the prefix(es) il/im/un/in to the modifier to acquire its contrary importance). It is a piece of the morphological information on a student to realize that English morphemes are either free morphemes (which can work in seclusion, as in the free morpheme rest) or bound morphemes (which can just capacity related to at any rate one other morpheme, as in the bound morpheme less). For instance, the word restlessness is made out of one free morpheme (rest) and two bound morphemes (- less, - ness). Free morphemes involve two sorts: lexical morphemes (things, action words, descriptors, and verb modifiers) and utilitarian morphemes (for example relational words and pronouns that serve a capacity as opposed to pass on importance). Thus, bound morphemes contain two sorts: derivational morphemes (which structure new words, e.g., care-thoughtless) and inflectional morphemes (which signal syntactic relationship, e.g., care-cares/minded/minding). It is instrumental to know the significance of certain attaches, for example, those showed in Table 2 underneath (Al-Najjar, 2007:100-119): Table 2: Affixes and significance Prefixes Suffixes Prefix Meaning Suffix Meaning be-influence, give (for example torment) cause to, treat as (for example get to know) - capable/ - ible fit (for example launderable) at risk to (for example wretched) de-expel (for example defrost) - a/ - ian identifying with (for example asian) dis-deny of (for example demoralize) - ance/ - ence activity (for example reliance)>GET ANSWER