Hive面试题SQL测试题目1数据

1 ÕÅÈý 24 male
2 ÀîËÄ 26 female
3 ÍúÍú 28 male
4 ÕÔÁø 34 male
5 Ç®ç÷ 24 female
6 ÖÜ°Ë 22 male
7 °×dz 74 female
8 ÀîÀö 24 female
9 Å·ÆÕ 64 female
create table IF NOT EXISTS default.student
(
SNO bigint comment 'ѧºÅ',
SNAME string,
SAGE bigint,
SSEX string
)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES (
  'colelction.delim'=',',
  'field.delim'=' ',
  'line.delim'='\n',
  'mapkey.delim'=':',
  'serialization.format'='|')
STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'

1001 english TS01
1002 math TS09
1003 art TS07
1004 dance TS08