You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "yyzzjj (JIRA)" <ji...@apache.org> on 2017/11/07 06:15:00 UTC

[jira] [Created] (IMPALA-6167) update StringColumn like json result error

yyzzjj created IMPALA-6167:
------------------------------

             Summary: update StringColumn  like  json  result error    
                 Key: IMPALA-6167
                 URL: https://issues.apache.org/jira/browse/IMPALA-6167
             Project: IMPALA
          Issue Type: Bug
          Components: Frontend
    Affects Versions: Impala 2.10.0
            Reporter: yyzzjj
            Priority: Blocker


update wx_recommend_sku_user_test set message_body_json = "{'first':{'value':'您管理的微信群中有最新的咨询问题'}, 'keyword1':{'color':'#0000ff','value':'京哥测试群'},'keyword2':{ 'value':'群咨询问题回复'}, 'keyword3':{ 'value':'2017-10-13 11:01:26'}, 'remark':{'value':'请您及时转发消息到目标群中'}}" where  ts = 1483607857103;


select message_body_json from wx_recommend_sku_user_test where ts = 1483607857103;

result:
+-----------------------------------+
| message_body_json                 |
+-----------------------------------+
| {:{:}, :{:,:},:{ :}, :{ :}, :{:}} |
+-----------------------------------+
print  TPlanExecInfo

https://github.com/cloudera/Impala/blob/dea12897af0e18f04eee507d25dd7902fb27ce7e/fe/src/main/java/org/apache/impala/service/Frontend.java#L1162

plan_exec_info:[TPlanExecInfo(fragments:[TPlanFragment(idx:0, display_name:F00, plan:TPlan(nodes:[TPlanNode(node_id:0, node_type:KUDU_SCAN_NODE, num_children:0, limit:-1, row_tuples:[0], nullable_tuples:[false], disable_codegen:false, kudu_scan_node:TKuduScanNode(tuple_id:0, use_mt_scan_node:false), label:00:SCAN KUDU, label_detail:jingo_recommendation.wx_recommend_sku_user_test, estimated_stats:TExecStats(cardinality:1646420, memory_used:0), resource_profile:TBackendResourceProfile(min_reservation:0, max_reservation:0))]), output_exprs:[TExpr(nodes:[TExprNode(node_type:SLOT_REF, type:TColumnType(types:[TTypeNode(type:SCALAR, scalar_type:TScalarType(type:BIGINT))]), num_children:0, is_constant:false, slot_ref:TSlotRef(slot_id:0))]), TExpr(nodes:[TExprNode(node_type:SLOT_REF, type:TColumnType(types:[TTypeNode(type:SCALAR, scalar_type:TScalarType(type:STRING))]), num_children:0, is_constant:false, slot_ref:TSlotRef(slot_id:1))]), TExpr(nodes:[TExprNode(node_type:STRING_LITERAL, type:TColumnType(types:[TTypeNode(type:SCALAR, scalar_type:TScalarType(type:STRING))]), num_children:0, is_constant:true, string_literal:TStringLiteral(value:{:{:}, :{:,:},:{ :}, :{ :}, :{:}}))])], output_sink:TDataSink(type:TABLE_SINK, table_sink:TTableSink(target_table_id:0, type:KUDU, action:UPDATE, kudu_table_sink:TKuduTableSink(referenced_columns:[0, 1, 34]))), partition:TDataPartition(type:RANDOM, partition_exprs:[]), min_reservation_bytes:0, initial_reservation_total_claims:0)], per_node_scan_ranges:{0=[TScanRangeLocationList(scan_range:TScanRange(kudu_scan_token:12 19 77 78 5F 72 65 63 6F 6D 6D 65 6E 64 5F 73 6B 75 5F 75 73 65 72 5F 6E 65 77 1A 11 12 03 70 69 6E 18 08 20 01 28 00 40 00 48 00 50 00 1A 10 12 02 74 73 18 07 20 01 28 00 40 00 48 00 50 00 22 10 0A 02 74 73 1A 0A 0A 08 CF 57 EB 6D 59 01 00 00 3A 00 42 04 00 00 00 01 48 FF FF FF FF FF FF FF FF 7F 50 01 68 01 70 00), locations:[TScanRangeLocation(host_idx:0), TScanRangeLocation(host_idx:1), TScanRangeLocation(host_idx:2)])]})]



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)