解析sql并返回列与标签对应关系
<p><strong>简要描述：</strong></p>
<ul>
<li>解析sql并返回列与标签对应关系</li>
</ul>
<p><strong>请求URL：</strong></p>
<ul>
<li>示例地址</li>
</ul>
<p><code>http://xx.com/indicator/sqlParse/parseAndAssociation</code></p>
<p><strong>请求方式：</strong></p>
<ul>
<li>POST</li>
</ul>
<p><strong>请求参数说明</strong></p>
<table>
<thead>
<tr>
<th style="text-align: left;">参数名</th>
<th style="text-align: left;">必选</th>
<th style="text-align: left;">类型</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">type</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">String</td>
<td>mysql/hive</td>
</tr>
<tr>
<td style="text-align: left;">sql</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">String</td>
<td>sql语句</td>
</tr>
<tr>
<td style="text-align: left;">keyWordLabelIds</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">Map</td>
<td>关键字和标签id数组</td>
</tr>
</tbody>
</table>
<p><strong>请求示例</strong></p>
<pre><code>{
"type":"hive",
"sql":"insert overwrite table riskt_eventpartition partition(year='2019',dt) select t.opt_id as order_no,id_no id_123,concat(t.consumer_no,'aa') dd,'1023' as dt from (select a.opt_id,b.id_no from ods.arc_event a left outer join ods.arc_user b on a.consumer_no = b.consumer_no) t left outer join (select order_no from arc_verify where dt = '20191023') t1 on t.consumer_no = t1.consumer_no",
"keyWordLabelIds":{
"id":[81,82,83],
"opt":[84,85]
}
}</code></pre>
<p><strong>返回参数说明</strong></p>
<table>
<thead>
<tr>
<th style="text-align: left;">参数名</th>
<th style="text-align: left;">类型</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">msg</td>
<td style="text-align: left;">String</td>
<td>返回信息</td>
</tr>
<tr>
<td style="text-align: left;">code</td>
<td style="text-align: left;">int</td>
<td>返回码[0:成功]</td>
</tr>
<tr>
<td style="text-align: left;">columns</td>
<td style="text-align: left;">Map</td>
<td>key:列名，value：标签数组</td>
</tr>
<tr>
<td style="text-align: left;">sourceTables</td>
<td style="text-align: left;">Array</td>
<td>来源表</td>
</tr>
</tbody>
</table>
<p><strong>返回示例</strong></p>
<pre><code>{
"msg": "success",
"code": 0,
"columns": {
"order_no": [],
"id_123": [{
"id": 111,
"parentLabelId": 109,
"labelLayer": 2,
"labelName": "主叫",
"labelDesc": null,
"isRoot": 0,
"addUser": 57,
"addUserName": "陈铁锋",
"addIp": "172.16.157.239",
"addTime": "2019-11-11 10:04:38",
"updateUser": 57,
"updateUserName": "陈铁锋",
"updateIp": "172.16.157.239",
"updateTime": "2019-11-11 10:04:49",
"deleteFlag": 0
},
{
"id": 112,
"parentLabelId": 109,
"labelLayer": 2,
"labelName": "通话时长",
"labelDesc": null,
"isRoot": 0,
"addUser": 57,
"addUserName": "陈铁锋",
"addIp": "172.16.157.239",
"addTime": "2019-11-11 10:05:30",
"updateUser": 57,
"updateUserName": "陈铁锋",
"updateIp": "172.16.157.239",
"updateTime": "2019-11-11 10:05:30",
"deleteFlag": 0
}],
"dd": [],
"dt": []
},
"sourceTables":[
"ods.arc_user",
"ods.arc_event",
"arc_verify"
]
}</code></pre>
<p><strong>备注</strong></p>