人口统计主题数据库

人口统计在hive路径下：1：启动服务bin/hive--servicemetastore&2：启动hive：bin/hive#建库createdatabasedzx_rktj;#进库usedzx_rktj;#建表1createtabletb_analysis_of_floating_population(idint,regionstring,floatingpopulationstring)rowformatdelimitedfieldsterminatedby'\t';#建表2createtabletb_age_gender(idint,sectionstring,numberofpeoplestring,numberofboysstring,numberoffemalestudentsstring)rowformatdelimitedfieldsterminatedby'\t';#建表3createtabletb_anlysis(idint,sourcenamestring,numberstring)rowformatdelimitedfieldsterminatedby'\t';#建表4createtabletb_annuall_national(idint,particularstring,numberofpeoplestring)rowformatdelimitedfieldsterminatedby'\t';#建表5createtabletb_demographic(idint,nameofdistrictstring,regionalpopulationstring)rowformatdelimitedfieldsterminatedby'\t';#建表6createtabletb_mobile_real_time_user_statistics(idint,timestring,numberofpeoplestring)rowformatdelimitedfieldsterminatedby'\t';#建表7createtabletb_statistics_working(idint,regionstring,numberofresidentsstring,numberofworkersstring)rowformatdelimitedfieldsterminatedby'\t';#建表8createtabletb_working_user_statistics(idint,nameofdistrictstring,numberofpeoplestring)rowformatdelimitedfieldsterminatedby'\t';#数据迁移1在sqoop目录下：bin/sqoopimport\--connectjdbc:mysql://hadoop2:3306/dzx_rktj\--usernameroot\--passwordroot\--tabletb_analysis_of_floating_population\--num-mappers1\--hive-import\--hive-databasedzx_rktj\--hive-tabletb_analysis_of_floating_population\--fields-terminated-by'\t'\--delete-target-dir#数据迁移2在sqoop目录下：bin/sqoopimport\--connectjdbc:mysql://hadoop2:3306/dzx_rktj\--usernameroot\--passwordroot\--tabletb_age_gender\--num-mappers1\--hive-import\--hive-databasedzx_rktj\--hive-tabletb_age_gender\--fields-terminated-by'\t'\--delete-target-dir#数据迁移3在sqoop目录下：bin/sqoopimport\--connectjdbc:mysql://hadoop2:3306/dzx_rktj\--usernameroot\--passwordroot\--tabletb_anlysis\--num-mappers1\--hive-import\--hive-databasedzx_rktj\--hive-tabletb_anlysis\--fields-terminated-by'\t'\--delete-target-dir#数据迁移4在sqoop目录下：bin/sqoopimport\--connectjdbc:mysql://hadoop2:3306/dzx_rktj\--usernameroot\--passwordroot\--tabletb_annuall_national\--num-mappers1\--hive-import\--hive-databasedzx_rktj\--hive-tabletb_annuall_national\--fields-terminated-by'\t'\--delete-target-dir#数据迁移5在sqoop目录下：bin/sqoopimport\--connectjdbc:mysql://hadoop2:3306/dzx_rktj\--usernameroot\--passwordroot\--tabletb_demographic\--num-mappers1\--hive-import\--hive-databasedzx_rktj\--hive-tabletb_demographic\--fields-terminated-by'\t'\--delete-target-dir#数据迁移6在sqoop目录下：bin/sqoopimport\--connectjdbc:mysql://hadoop2:3306/dzx_rktj\--usernameroot\--passwordroot\--tabletb_mobile_real_time_user_statistics\--num-mappers1\--hive-import\--hive-databasedzx_rktj\--hive-tabletb_mobile_real_time_user_statistics\--fields-terminated-by'\t'\--delete-target-dir#数据迁移7在sqoop目录下：bin/sqoopimport\--connectjdbc:mysql://hadoop2:3306/dzx_rktj\--usernameroot\--passwordroot\--tabletb_statistics_working\--num-mappers1\--hive-import\--hive-databasedzx_rktj\--hive-tabletb_statistics_working\--fields-terminated-by'\t'\--delete-target-dir#数据迁移8在sqoop目录下：bin/sqoopimport\--connectjdbc:mysql://hadoop2:3306/dzx_rktj\--usernameroot\--passwordroot\--tabletb_working_user_statistics\--num-mappers1\--hive-import\--hive-databasedzx_rktj\--hive-tabletb_working_user_statistics\--fields-terminated-by'\t'\--delete-target-dir查询1select*fromtb_analysis_of_floating_population;查询2select*fromtb_age_gender;查询3select*fromtb_anlysis;查询4select*