[KYLIN-3145] Support Kafka JSON message whose property name includes "_"

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v2.3.0
• Component/s: NRT Streaming
• Assignee: Shao Feng Shi
• Reporter: Shao Feng Shi
• Created: 02/Jan/18 07:43
• Updated: 02/Apr/18 13:42
• Resolved: 09/Feb/18 02:21

Description

So far Kylin doesn't support JSON message which has property name with "_", because that would be conflict with Kylin's logic.

For example, the JSON message is :

{ 
 "user" : {
  "first_name" : "Tom",
  "age" : "20"
  }

}

When map this topic to a table, the "first_name" is mapped to "user_first_name"; When Kylin parse the message, it separates by "_" and then try to find "user" -> "first" -> "name"; as there is no "first" property, an error is reported.