首页这是我的数据信息1,225,5,47.02,Bamboo Shoots - Sliced,2017-08-04,8:18,2017-8 10,455,5,8.31,Trout - Smoked,2018-02-20,0:53,2018-2 100,386,5,7.53,Gherkin - Sour,2018-03-08,21:15,2018-3 1003,387,1,25.78,Fondant - Icing,2018-01-08,10:42 AM,2018-1 1006,231,1,7.77,"Salmon - Atlantic, No Skin",2017-10-23,4:07 PM,2017-10 1007,31,3,18.89,Chicken - Ground,2017-12-21,5:04 PM,2017-12 1009,232,4,38.01,Sobe - Cranberry Grapefruit,2017-11-20,7:26 PM,2017-11 1010,349,3,35.97,Ecolab - Solid Fusion,2017-06-05,8:31 PM,2017-6 1013,63,5,39.73,Oil - Cooking Spray,2017-04-21,5:30 PM,2017-4 1025,234,4,30.28,Table Cloth 62x120 White,2017-09-22,12:43 PM,2017-9 1029,473,2,3.39,Flower - Leather Leaf Fern,2017-07-31,10:08 PM,2017-7 1034,192,4,27.6,Veal - Knuckle,2017-05-10,5:26 PM,2017-5 为什么加不到我的表里，下面是我的建表语句create external table if not exists ext_transaction_details ( transaction_id string, customer_id string, store_id string, price decimal(8, 2), product string, purchase_date string, purchase_time string ) partitioned by (year_month STRING) row format serde 'org.apache.hadoop.hive.serde2.OpenCSVSerde' --this must tblproperties tblproperties ("skip.header.line.count" = "1");

这是我的数据信息1,225,5,47.02,Bamboo Shoots - Sliced,2017-08-04,8:18,2017-8 10,455,5,8.31,Trout - Smoked,2018-02-20,0:53,2018-2 100,386,5,7.53,Gherkin - Sour,2018-03-08,21:15,2018-3 1003,387,1,25.78,Fondant - Icing,2018-01-08,10:42 AM,2018-1 1006,231,1,7.77,"Salmon - Atlantic, No Skin",2017-10-23,4:07 PM,2017-10 1007,31,3,18.89,Chicken - Ground,2017-12-21,5:04 PM,2017-12 1009,232,4,38.01,Sobe - Cranberry Grapefruit,2017-11-20,7:26 PM,2017-11 1010,349,3,35.97,Ecolab - Solid Fusion,2017-06-05,8:31 PM,2017-6 1013,63,5,39.73,Oil - Cooking Spray,2017-04-21,5:30 PM,2017-4 1025,234,4,30.28,Table Cloth 62x120 White,2017-09-22,12:43 PM,2017-9 1029,473,2,3.39,Flower - Leather Leaf Fern,2017-07-31,10:08 PM,2017-7 1034,192,4,27.6,Veal - Knuckle,2017-05-10,5:26 PM,2017-5 为什么加不到我的表里，下面是我的建表语句create external table if not exists ext_transaction_details ( transaction_id string, customer_id string, store_id string, price decimal(8, 2), product string, purchase_date string, purchase_time string ) partitioned by (year_month STRING) row format serde 'org.apache.hadoop.hive.serde2.OpenCSVSerde' --this must tblproperties tblproperties ("skip.header.line.count" = "1");

时间: 2023-09-20 08:13:18 浏览: 160

根据你提供的数据信息和建表语句，我注意到你的数据信息中包含了一些额外的字段，可能导致无法将数据正确加载到表中。建议你检查一下数据信息和建表语句中的字段是否匹配，确保数据的每个字段与表的每个列对应。此外，还要确保数据中的每一行符合CSV格式，并且没有包含任何格式错误或特殊字符。如果问题仍然存在，请提供更多的错误信息以便我更好地帮助你解决问题。

阅读全文