.dat文件到配置单元表中，数据用双引号引起来

我有一个文件.dat文件，如下所示，该文件要加载到hdfs位置，然后再加载到表中。这是由软件生成的

"Fact" "Jan" "2011YR" "7913" "25A04PLTF" "PM IAP None" "R_LOC" "Custom2.FM None" "Custom1.PM None" "Custom4.FM None" "25BU" "25A04PLTF_OC0001" -196.790000000000
"Fact" "Jan" "2011YR" "9370" "25A01MKT" "PM IAP None" "R_INR" "Custom2.FM None" "Custom1.PM None" "Custom4.FM None" "39BU" "25A01MKT_NoSubDiv" 778.210000000000
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| term | month  | year  | ledger_group  | condition1  | condition2  | condition3  | condition4     | condition5     |  condition6    | condition7  | condition8       | Value               |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|Fact  | Jan    |2011YR |2025           |25A01PLTF    |PM IAP None  |R_INR        |Custom2.FM None |Custom1.PM None |Custom4.FM None |22BU         |25A06PLTF_B603    |561.400000000000     |
|Fact  | Jan    |2011YR |7913           |25A04PLTF    |PM IAP None  |R_LOC        |Custom2.FM None |Custom1.PM None |Custom4.FM None |25BU         |25A04PLTF_OC0001  |-196.790000000000    |
|Fact  | Jan    |2011YR |9370           |25A01MKT     |PM IAP None  |R_INR        |Custom2.FM None |Custom1.PM None |Custom4.FM None |39BU         |25A01MKT_NoSubDiv |778.210000000000     |

我在下面使用了以下create语句。

create table db.hpm_poc( term string,month string,year varchar(32),ledger_group varchar(32),condition1 varchar(32),condition2 varchar(32),condition3 varchar(32),condition4 varchar(32),condition5 varchar(32),condition6 varchar(32),condition7 varchar(32),condition8 varchar(32),value float)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES (
   "separatorChar" = "\t","quoteChar"     = "\"")
LOCATION 'xyz';

但得到以下结果

+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+-------+---------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+------------+--------+--+
|                                                                                       term                                                                                       | month  | year  | ledger_group  | condition1  | condition2  | condition3  | condition4  | condition5  | condition6  | condition7  | Condition8 | value  |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+-------+---------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+------------+--------+--+
| Fact" "Jan" "2011YR" "2025" "25A01PLTF" "PM IAP None" "R_INR" "Custom2.FM None" "Custom1.PM None" "Custom4.FM None" "22BU" "25A06PLTF_B603" 561.400000000000                   | NULL   | NULL  | NULL          | NULL        | NULL        | NULL        | NULL        | NULL        | NULL        | NULL        | NULL       | NULL   |
| Fact" "Jan" "2011YR" "7913" "25A04PLTF" "PM IAP None" "R_LOC" "Custom2.FM None" "Custom1.PM None" "Custom4.FM None" "25BU" "25A04PLTF_OC0001" -196.790000000000                | NULL   | NULL  | NULL          | NULL        | NULL        | NULL        | NULL        | NULL        | NULL        | NULL        | NULL       | NULL   |
| Fact" "Jan" "2011YR" "9370" "25A01MKT" "PM IAP None" "R_INR" "Custom2.FM None" "Custom1.PM None" "Custom4.FM None" "39BU" "25A01MKT_NoSubDiv" 778.210000000000                 | NULL   | NULL  | NULL          | NULL        | NULL        | NULL        | NULL        | NULL        | NULL        | NULL        | NULL       | NULL   |

并且在SHOW CREATE TABLE中ddl数据类型不同

 CREATE TABLE `db.hpm_poc`(                                                    
   `term` string COMMENT 'from deserializer',`month` string COMMENT 'from deserializer',`year` string COMMENT 'from deserializer',`ledger_group` string COMMENT 'from deserializer',`condition1` string COMMENT 'from deserializer',`condition2` string COMMENT 'from deserializer',`condition3` string COMMENT 'from deserializer',`condition4` string COMMENT 'from deserializer',`condition5` string COMMENT 'from deserializer',`condition6` string COMMENT 'from deserializer',`condition7` string COMMENT 'from deserializer',`condition8` string COMMENT 'from deserializer',`value` string COMMENT 'from deserializer')                                                            
 ROW FORMAT SERDE                                                                                         
   'org.apache.hadoop.hive.serde2.OpenCSVSerde'                                                           
 WITH SERDEPROPERTIES (                                                                                   
   'quoteChar'='\"','separatorChar'='\t')                                                                                  
 STORED AS INPUTFORMAT                                                                                    
   'org.apache.hadoop.mapred.TextInputFormat'                                                             
 OUTPUTFORMAT                                                                                             
   'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'                                           
 LOCATION                                                                                                 
   'xyz'  
 TBLPROPERTIES (                                                                                          
   'numFiles'='0','totalSize'='0','transient_lastDdlTime'='0');`

有人可以指导我吗？

.dat文件到配置单元表中，数据用双引号引起来

sjhranran 回答：.dat文件到配置单元表中，数据用双引号引起来

大家都在问