最近在我们的环境中导入了部分测试用的hive外部表，其中绝大部分外部表都没有发现使用上的问题，但是有一张比较核心的表，创建之后一直出现unknown error的问题，无法提供正常的服务以下是我的建表语句
CREATE EXTERNAL TABLE dws_fact_trade_suborder_detail_ymd (
city_k bigint(20) NULL COMMENT “城市主键”,
tra_k bigint(20) NULL COMMENT “商圈主键”,
user_k bigint(20) NULL COMMENT “用户主键”,
logistics_k bigint(20) NULL COMMENT “物流圈主键”,
supplier_k bigint(20) NULL COMMENT “供应商主键”,
supplier_category_k bigint(20) NULL COMMENT “供应商品类主键”,
operator_k bigint(20) NULL COMMENT “运营人员主键”,
goods_k bigint(20) NULL COMMENT “商品主键”,
goods_category_k bigint(20) NULL COMMENT “商品品类主键”,
v_goods_original_amount bigint(20) NULL COMMENT “拼单金额(商品原价金额)mall”,
v_order_goods_amount bigint(20) NULL COMMENT “订单金额/商品金额(GMV)订单金额=拼单价拼单价购买数量+活动价活动价购买数量”,
v_payment_amount bigint(20) NULL COMMENT “应付金额:应付金额=订单金额+运费-红包抵扣金额”,
v_actual_payment_amount bigint(20) NULL COMMENT “实付金额:实付金额=应付金额-钱包支付金额”,
v_goods_count bigint(20) NULL COMMENT “商品数量”,
v_goods_type_count bigint(20) NULL COMMENT “商品种类数量”,
v_original_price_count bigint(20) NULL COMMENT “拼单购买数量”,
v_original_price_amount bigint(20) NULL COMMENT “拼单购买金额”,
v_promotion_price_count bigint(20) NULL COMMENT “优惠价购买数量(活动商品=爆品商品+组合商品+会员商品)”,
v_promotion_price_amount bigint(20) NULL COMMENT “优惠价购买金额(活动商品GMV=爆品商品+组合商品+会员商品)”,
v_single_profit_amount bigint(20) NULL COMMENT “拼单毛利额(GMV-商品成本)”,
v_original_profit_amount bigint(20) NULL COMMENT “非活动商品毛利额(GMV-商品成本)”,
v_goods_profit_amount bigint(20) NULL COMMENT “商品毛利额(GMV-商品成本)”,
v_promotion_profit_amount bigint(20) NULL COMMENT “促销商品毛利额”,
v_explose_profit_amount bigint(20) NULL COMMENT “爆品商品毛利额”,
v_combination_profit_amount bigint(20) NULL COMMENT “组合商品毛利额”,
v_member_profit_amount bigint(20) NULL COMMENT “会员商品毛利额”,
v_promotion_let_profit_amount bigint(20) NULL COMMENT “促销商品让利额(活动商品=爆品商品+组合商品+会员商品)”,
v_supplier_price_total_amount bigint(20) NULL COMMENT “供应商价总金额”,
v_redpacket_payment_amount bigint(20) NULL COMMENT “红包支付金额”,
v_money_off_amount bigint(20) NULL COMMENT “子订单满减金额”,
v_freight_amount bigint(20) NULL COMMENT “运费金额”,
v_preferential_amount bigint(20) NULL COMMENT “订单优惠金额(商品价格层级优惠,如普通商品、爆品、组合商品、会员商品等)”,
v_wallet_pay_amount bigint(20) NULL COMMENT “钱包支付金额”,
v_currency_pay_amount bigint(20) NULL COMMENT “货币支付金额”,
v_pick_goods_count bigint(20) NULL COMMENT “取货商品数量(通过缺货表获取)”,
v_pick_goods_amount bigint(20) NULL COMMENT “取货商品金额(通过缺货表获取)”,
v_recv_goods_count bigint(20) NULL COMMENT “实际签收数量(通过缺货表获取)”,
v_recv_goods_amount bigint(20) NULL COMMENT “实际签收金额(通过缺货表获取)”,
v_actual_red_packet_pay_amount bigint(20) NULL COMMENT “实际红包支付金额(剔除缺退货金额)”,
v_actual_wallet_pay_amount bigint(20) NULL COMMENT “实际钱包支付金额(剔除缺退货金额)”,
v_actual_freight_fee_amount bigint(20) NULL COMMENT “实际运费金额(剔除缺退货金额)”,
v_total_preferential_amount bigint(20) NULL COMMENT “优惠总金额(商品价格优惠+非商品价格优惠(如满减)+品类红包)”,
v_subtotal_preferential_amount bigint(20) NULL COMMENT “商品优惠小计(满减+品类红包)”,
v_pickup_lack_count bigint(20) NULL COMMENT “取货缺货数量(通过缺货表获取)”,
v_pickup_lack_amount bigint(20) NULL COMMENT “取货缺货金额(通过缺货表获取)”,
v_recv_goods_lack_count bigint(20) NULL COMMENT “签收缺货数量(通过缺货表获取)”,
v_recv_goods_lack_amount bigint(20) NULL COMMENT “签收缺货金额(通过缺货表获取)”,
v_recv_goods_lack_redpacket_amount bigint(20) NULL COMMENT “签收缺货退还红包金额(通过缺货表获取)”,
v_refund_goods_count bigint(20) NULL COMMENT “商品退货数量(通过退货表获取)”,
v_refund_goods_amount bigint(20) NULL COMMENT “商品退货金额(通过退货表获取)”,
v_return_refund_redpacket_amount bigint(20) NULL COMMENT “商品退货退还红包金额(通过退货表获取)”,
v_compensation_redpacket_amount bigint(20) NULL COMMENT “红包金额_赔付红包(下单时对应的红包金额)”,
v_category_redpacket_amount bigint(20) NULL COMMENT “红包金额_品类红包(下单时对应的红包金额)”,
v_general_redpacket_amount bigint(20) NULL COMMENT “红包金额_普通红包(下单时对应的红包金额)”,
v_recharge_give_amount decimal(20, 6) NULL COMMENT “充值赠送金额(所有赠送金额按商品拆分)”,
v_sign_red_packet_amount decimal(20, 6) NULL COMMENT “签到红包金额(所有赠送金额按商品拆分)”,
v_sign_wallet_amount decimal(20, 6) NULL COMMENT “签到钱包金额(所有赠送金额按商品拆分)”,
v_operation_sms_amount decimal(20, 6) NULL COMMENT “运营短信金额(短信金额按商品拆分)”,
v_actual_subtotal_preferential_amount bigint(20) NULL COMMENT “实际商品优惠小计(满减、品类红包)(剔除缺退货金额)”,
v_goods_cost_amount bigint(20) NULL COMMENT “商品成本(供应商成本+商品优惠小计)”,
v_actural_supplier_price_total_amount bigint(20) NULL COMMENT “供应商结算金额(剔除缺退货)”,
v_marketing_cost_amount decimal(20, 6) NULL COMMENT “营销成本自然日(当天所有营销金额按商品拆分=订单使用红包(剔除赔付红包+品类红包)+签到余额+充值奖励金额+短信成本)”,
v_turnover_amount decimal(20, 6) NULL COMMENT “成交金额自然日(GMV-缺退货金额-实际红包支付金额-营销成本-实际商品优惠小计)”,
v_net_gross_profit decimal(20, 6) NULL COMMENT “净毛利额自然日(成交金额-供应商结算金额)”,
v_explose_price_count bigint(20) NULL COMMENT “爆品价购买数量”,
v_explose_price_amount bigint(20) NULL COMMENT “爆品价购买金额(爆品GMV)”,
v_combination_price_count bigint(20) NULL COMMENT “组合价购买数量”,
v_combination_price_amount bigint(20) NULL COMMENT “组合价购买金额(组合GMV)”,
v_member_price_count bigint(20) NULL COMMENT “会员价购买数量”,
v_member_price_amount bigint(20) NULL COMMENT “会员价购买金额(会员GMV)”,
v_goods_let_profit_amount bigint(20) NULL COMMENT “商品让利额”,
v_explose_let_profit_amount bigint(20) NULL COMMENT “爆品商品让利额”,
v_combination_let_profit_amount bigint(20) NULL COMMENT “组合商品让利额”,
v_member_let_profit_amount bigint(20) NULL COMMENT “会员商品让利额”,
v_supplier_rebate_amount bigint(20) NULL COMMENT “供应商返点”,
o_order_classify bigint(20) NULL COMMENT “订单分类，值为1-A,2-B”,
o_business_data_time varchar(65533) NULL COMMENT “业务数据时间(货到付款取创建时间 在线支付取支付时间)”,
o_order_create_time varchar(65533) NULL COMMENT “订单下单时间”,
o_order_pay_time varchar(65533) NULL COMMENT “订单支付时间”,
o_dispatch_time varchar(65533) NULL COMMENT “派单时间”,
o_dispatch_date_natural_k bigint(20) NULL COMMENT “派单日期自然日代理键”,
o_pick_confirm_time varchar(65533) NULL COMMENT “取货确认时间[出库确认时间]”,
o_pick_confirm_date_natural_k bigint(20) NULL COMMENT “取货确认日期自然日代理键”,
o_recv_time varchar(65533) NULL COMMENT “签收时间(收货时间)”,
o_recv_date_natural_k bigint(20) NULL COMMENT “签收日期自然日代理键”,
o_complete_time varchar(65533) NULL COMMENT “子订单完成时间”,
o_pay_delivery bigint(20) NULL COMMENT “是否货到付款(1是，0否)”,
o_order_no varchar(65533) NULL COMMENT “原始订单编号”,
o_sub_order_no varchar(65533) NULL COMMENT “子订单编号”,
o_old_sub_order_no varchar(65533) NULL COMMENT “老的子订单号，和sub_order_no的区别是：老的子订单号如果没有拆单，则后边不加【-0】，新的子单后边添加【-0】,该字段是为了兼容和老表关联使用的”,
o_order_status bigint(20) NULL COMMENT “订单状态(200:已收单;290:已完成(预留状态)；295:已取消)”,
o_suborder_status bigint(20) NULL COMMENT “子订单状态”,
o_original_price bigint(20) NULL COMMENT “原价(拼单价)”,
o_promotion_price bigint(20) NULL COMMENT “优惠价(爆品价)”,
o_supplier_price bigint(20) NULL COMMENT “供应商价格”,
o_daily_price bigint(20) NULL COMMENT “供应商日常价”,
o_event_price bigint(20) NULL COMMENT “供应商活动价”,
o_order_source varchar(65533) NULL COMMENT “订单来源(app-应用,miniProgram-小程序，h5-H5网页)”,
o_b_class bigint(20) NULL COMMENT “是否B类(1是,0否)”,
o_dispatch bigint(20) NULL COMMENT “是否派单(1已经派单、0尚未派单)”,
o_avg_settlement_price decimal(20, 6) NULL COMMENT “商圈平均报价”,
o_max_settlement_price bigint(20) NULL COMMENT “商圈最高报价”,
o_min_settlement_price bigint(20) NULL COMMENT “商圈最低报价”,
o_all_settlement_price varchar(65533) NULL COMMENT “商圈所有报价”,
o_all_supplier_id varchar(65533) NULL COMMENT “商圈所有报价供应商”,
o_all_supplier_name varchar(65533) NULL COMMENT “所有供应商名称”,
o_user_id bigint(20) NULL COMMENT “用户id”,
o_user_uid varchar(65533) NULL COMMENT “店铺编码”,
o_user_name varchar(65533) NULL COMMENT “用户名称”,
o_operator_code bigint(20) NULL COMMENT “运营人员id”,
o_operator_name varchar(65533) NULL COMMENT “运营人员名称”,
o_city_code varchar(65533) NULL COMMENT “城市编码”,
o_city_name varchar(65533) NULL COMMENT “城市名称”,
o_tra_code bigint(20) NULL COMMENT “商城-商圈id”,
o_tra_name varchar(65533) NULL COMMENT “商城-商圈名称”,
o_supplier_code bigint(20) NULL COMMENT “供应商id”,
o_supplier_name varchar(65533) NULL COMMENT “供应商名称”,
o_goods_code bigint(20) NULL COMMENT “商品id”,
o_goods_name varchar(65533) NULL COMMENT “商品名称”,
o_logistics_code varchar(65533) NULL COMMENT “物流圈编码”,
o_logistics_name varchar(65533) NULL COMMENT “物流圈名称”,
o_goods_category_code varchar(65533) NULL COMMENT “商品品类编码”,
o_goods_category_name varchar(65533) NULL COMMENT “商品品类名称”,
o_is_statistical_data bigint(20) NULL COMMENT “是否统计数据(-2 餐饮商圈,-1 大宗商圈,0大客户商圈,1普通商圈,2原点计划商圈)”,
o_tra_statistics_type_code bigint(20) NULL COMMENT “是否统计数据(-2 餐饮商圈,-1 大宗商圈,0大客户商圈,1普通商圈,2原点计划商圈)”,
o_tra_statistics_type_name varchar(65533) NULL COMMENT “是否统计数据(-2 餐饮商圈,-1 大宗商圈,0大客户商圈,1普通商圈,2原点计划商圈)”,
o_theory_volume bigint(20) NULL COMMENT “商品体积”,
o_packet_type_code varchar(65533) NULL COMMENT “红包类型编号(系统分类)”,
o_packet_type_name varchar(65533) NULL COMMENT “红包类型名称(系统分类)”,
o_available_pay_type_code varchar(65533) NULL COMMENT “可用支付方式编码”,
o_available_pay_type_name varchar(65533) NULL COMMENT “可用支付方式名称”,
o_refunded varchar(65533) NULL COMMENT “是否已退还”,
o_status varchar(65533) NULL COMMENT “红包状态”,
o_grant_reason_code varchar(65533) NULL COMMENT “平台红包发放原因编码”,
o_grant_reason_name varchar(65533) NULL COMMENT “平台红包发放原因编码”,
o_used varchar(65533) NULL COMMENT “是否已使用”,
o_currency_pay_channel varchar(65533) NULL COMMENT “货币支付-支付渠道:wechat,alipay,cash;原始订单中次字段只会记录下单支付的支付渠道”,
create_time varchar(65533) NULL COMMENT “记录创建时间”,
update_time varchar(65533) NULL COMMENT “记录更新时间”,
date_natural_k bigint(20) NULL COMMENT “”
) ENGINE=HIVE
COMMENT “PARTITION BY (date_natural_k)”
PROPERTIES (
“database” = “dws_test”,
“table” = “dws_fact_trade_suborder_detail_ymd”,
“resource” = “hive_source”,
“hive.metastore.uris” = “thrift://17*...**fe.zip (12.4 MB) 1:9083”
);be (2).zip (41.9 MB)
请问下使用的哪个版本，fe.log中搜下这个表的查询失败的上下文日志
遇到了这个问题，有解决办法吗？