每日总结

今天下的小雨，上了软件企业文化和大型数据库，完成了数据库的作业。

echo "hello world" > file1.txt

echo "hello hadoop" > file2.txt

创键文件

 之后进入hive进行操作：

1. create table docs(line string);
2. load data inpath 'file:///usr/local/hadoop/input' overwrite into table docs;
3. create table word_count as
4. select word, count(1) as count from
5. (select explode(split(line,' '))as word from docs) w
6. group by word
7. order by word;

最后查询表word_count;

select * from word_count;