我用sqoop拉取mysql表,到hive中后表的存储格式为parquet格式。
这时我要用此表关联另一张表,自己建的表。如下:
两个建表语句(语句2多了 STORED AS parquet):
语句1:
CREATE TABLE `tmp.t_position_name_data_times_greate300_positions`(
`id` string,
`title` string,
`company_name` string,
`work_city` string,
`company_id` string,
`education_request` string,
`work_year_request` string,
`position_description` string);
语句2:
CREATE TABLE `tmp.t_position_name_data_times_greate300_positions`(
`id` string,
`title` string,
`company_name` string,
`work_city` string,
`company_id` string,
`education_request` string,
`work_year_request` string,
`position_description` string) STORED AS parquet;
如果直接使用语句1建表则默认存储格式为Text,这样的话如果字段中有 /r,/t 换行符的 的话sel