31.derby-插入8组数据

[01].Hive的8条数据

• 启动hive

• 使用默认数据库

• 创建表

  create table student(id String,name String,stature double,en double,ma double);

• 插入数据

  INSERT INTO student(id,name,stature,en,ma) VALUES('1001','Tom',180,85,100);
  INSERT INTO student(id,name,stature,en,ma) VALUES('1002','Lily',165,72,90);
  INSERT INTO student(id,name,stature,en,ma) VALUES('1003','Mary',172,60,85);
  INSERT INTO student(id,name,stature,en,ma) VALUES('1004','Jack',175,95,80);
  INSERT INTO student(id,name,stature,en,ma) VALUES('1005','Rob',177,88,70);
  INSERT INTO student(id,name,stature,en,ma) VALUES('1006','John',192,78,86);
  INSERT INTO student(id,name,stature,en,ma) VALUES('1007','Alice',163,81,60);
  INSERT INTO student(id,name,stature,en,ma) VALUES('1008','Kate',168,68,85);

• 查询全表

  select * from student;