wfn0UCve

1create external table if not exists movies.oscars (ceremony_year int,ceremony string,award int,winner string,name string,film string)
2row format delimited fields terminated by ','
3stored as textfile
4location 'hdfs://quickstart.cloudera:8022/user/hadoop/HDFS/raw_data/oscars'
5create external table if not exists movies.actors_genders (name string, gender string)
6row format delimited fields terminated by ','
7stored as textfile
8location 'hdfs://quickstart.cloudera:8022/user/hadoop/HDFS/raw_data/actors_genders'
9 
10michal4237Dziś o 22:12
11create table plot_analysis_middle_set (release_year int, word string, accuracy int);
12create table plot_analysis_result_set (word string, release_year int, no_premieres int);
13create table womens_in_movies_middle_set (women_percentage float, films_with_women float);
14create table womens_in_movies_result_set (women_percentage_oscars float, women_films_oscars string);