今天下的小雨,上了软件企业文化和大型数据库,完成了数据库的作业。
echo "hello world" > file1.txt
echo "hello hadoop" > file2.txt
创键文件
之后进入hive进行操作:
- create table docs(line string);
- load data inpath 'file:///usr/local/hadoop/input' overwrite into table docs;
- create table word_count as
- select word, count(1) as count from
- (select explode(split(line,' '))as word from docs) w
- group by word
- order by word;