Hive经典常见面试练手题.pdfVIP

作业题

1、找出全部夺得3连贯的队伍

team,year

活塞,1990

公⽜,1991

公⽜,1992

公⽜,1993

⽕箭,1994

⽕箭,1995

公⽜,1996

公⽜,1997

公⽜,1998

⻢刺,1999

湖⼈,2000

湖⼈,2001

湖⼈,2002

⻢刺,2003

活塞,2004

⻢刺,2005

热⽕,2006

⻢刺,2007

凯尔特⼈,2008

湖⼈,2009

湖⼈,2010

createtablet1(

teamstring,

yearint

)rowformatdelimitedfieldsterminatedby,;

loaddatalocalinpath/root/data/t1.datintotablet1;

2、找出每个id在在⼀天之内所有的波峰与波⾕值

id,time,price

sh66688,9:35,29.48

sh66688,9:40,28.72

sh66688,9:45,27.74

sh66688,9:50,26.75

sh66688,9:55,27.13

sh66688,10:00,26.30

sh66688,10:05,27.09

sh66688,10:10,26.46

sh66688,10:15,26.11

sh66688,10:20,26.88

sh66688,10:25,27.49

sh66688,10:30,26.70

sh66688,10:35,27.57

sh66688,10:40,28.26

sh66688,10:45,28.03

sh66688,10:50,27.36

sh66688,10:55,26.48

sh66688,11:00,27.41

sh66688,11:05,26.70

sh66688,11:10,27.35

sh66688,11:15,27.35

sh66688,11:20,26.63

sh66688,11:25,26.35

sh66688,11:30,26.81

sh66688,13:00,29.45

sh66688,13:05,29.41

sh66688,13:10,29.10

sh66688,13:15,28.24

sh66688,13:20,28.20

sh66688,13:25,28.59

sh66688,13:30,29.49

sh66688,13:35,30.45

sh66688,13:40,30.31

sh66688,13:45,30.17

sh66688,13:50,30.55

sh66688,13:55,30.75

sh66688,14:00,30.03

sh66688,14:05,29.61

sh66688,14:10,29.96

sh66688,14:15,30.79

sh66688,14:20,29.82

sh66688,14:25,30.09

sh66688,14:30,29.61

sh66688,14:35,29.88

sh66688,14:40,30.36

sh66688,14:45,30.88

sh66688,14:50,30.73

sh66688,14:55,30.76

sh88888,9:35,67.23

sh88888,9:40,66.56

sh88888,9:45,66.73

sh88888,9:50,67.43

sh88888,9:55,67.49

sh88888,10:00,68.34

sh88888,10:05,68.13

sh88888,10:10,67.35

sh88888,10:15,68.13

sh88888,10:20,69.05

sh88888,10:25,69.82

sh88888,10:30,70.62

sh88888,10:35,70.59

sh88888,10:40,70.40

sh88888,10:45,70.29

sh88888,10:50,70.53

sh88888,10:55,70.92

sh88888,11:00,71.13

sh88888,11:05,70.24

sh88888,11:10,70.37

sh88888,11:15,69.79

sh88888,11:20,69.73

sh88888,11:25,70.52

sh88888,11:30,71.23

sh8888