阿里安全开放平台-阿里聚安全

请求地址：

环境	HTTP请求地址	HTTPS请求地址
正式环境	http://gw.api.taobao.com/router/rest	https://eco.taobao.com/router/rest

公共请求参数：

名称	类型	是否必须	描述
method	String	是	API接口名称。
app_key	String	是	TOP分配给应用的AppKey。
target_app_key	String	否	被调用的目标AppKey，仅当被调用的API为第三方ISV提供时有效。
sign_method	String	是	签名的摘要算法，可选值为：hmac，md5。
sign	String	是	API输入参数签名结果，签名算法介绍请点击这里。
session	String	否	用户登录授权成功后，TOP颁发给应用的授权信息，详细介绍请点击这里。当此API的标签上注明：“需要授权”，则此参数必传；“不需要授权”，则此参数不需要传；“可选授权”，则此参数为可选。
timestamp	String	是	时间戳，格式为yyyy-MM-dd HH:mm:ss，时区为GMT+8，例如：2015-01-01 12:00:00。淘宝API服务端允许客户端请求最大时间误差为10分钟。
format	String	否	响应格式。默认为xml格式，可选值：xml，json。
v	String	是	API协议版本，可选值：2.0。
partner_id	String	否	合作伙伴身份标识。
simplify	Boolean	否	是否采用精简JSON返回格式，仅当format=json时有效，默认值为：false。

名称	类型	是否必须	示例值	更多限制	描述
sql_similarity_request	SqlSimilarityRequest	必须			sql相似度计算请求
└ sql_b String 必须 select ,'A' from tablea where ds = '20230402' and col1 = 'A' sql相似度比较的sql_b └ table_column_string String 必须 tablea::1##col1##0,2##col2##0,3##col3##0,4##ds##1 表列信息字符串 └ sql_a String 必须 select ,'B' from tablea where ds = '20230401' and col1 = 'A' sql相似度比较的sql_a └ project_name String 必须 data_sec 项目名称

名称	类型	示例值	描述
sql_similarity_result	SqlSimilarityResult		sql相似度计算结果
└ format_result String {\"SQLB\":{\"fp\":\"98609D4539042A0A796AAF7F2EEDFB7E\",\"fromatSQL\":\"SELECT 'B' AS __col_0, __ts_0.col1 AS col1, __ts_0.col2 AS col2, __ts_0.col3 AS col3, __ts_0.ds AS ds\\nFROM tablea __ts_0\\nWHERE __ts_0.col1 = 'A'\\n\\tAND __ts_0.ds = '20230401'\",\"sfp\":\"A25432FB40F32D9CE9D20AA3F43F598B\"},\"SQLA\":{\"fp\":\"D9A9B21D60068B7A2196DD9B5F9F70F2\",\"fromatSQL\":\"SELECT 'A' AS __col_0, __ts_0.col1 AS col1, __ts_0.col2 AS col2, __ts_0.col3 AS col3, __ts_0.ds AS ds\\nFROM tablea __ts_0\\nWHERE __ts_0.col1 = 'A'\\n\\tAND __ts_0.ds = '20230402'\",\"sfp\":\"A25432FB40F32D9CE9D20AA3F43F598B\"}} SQL格式化后的结果及指纹信息 └ similar_result String SQLA 与 SQLB 去除常量后完全一致相似性描述结果。包括3个取值，分别是：SQLA 与 SQLB 完全一致，SQLA 与 SQLB 去除常量后完全一致，SQLA 与 SQLB 不一致 └ error String SQL parse failed: ... 若发生异常则包含错误信息，正常情况下不存在此字段

JAVA
.NET
PHP
CURL
Python
C/C++
NodeJS

TaobaoClient client = new DefaultTaobaoClient(url, appkey, secret);
AlibabaDtSqlalgoSimilarityQuerysqlsimilarityRequest req = new AlibabaDtSqlalgoSimilarityQuerysqlsimilarityRequest();
AlibabaDtSqlalgoSimilarityQuerysqlsimilarityRequest.SqlSimilarityRequest obj1 = new AlibabaDtSqlalgoSimilarityQuerysqlsimilarityRequest.SqlSimilarityRequest();
obj1.setSqlB("select *,'A' from tablea where ds = '20230402' and col1 = 'A'");
obj1.setTableColumnString("tablea::1##col1##0,2##col2##0,3##col3##0,4##ds##1");
obj1.setSqlA("select *,'B' from tablea where ds = '20230401' and col1 = 'A'");
obj1.setProjectName("data_sec");
req.setSqlSimilarityRequest(obj1);
AlibabaDtSqlalgoSimilarityQuerysqlsimilarityResponse rsp = client.execute(req);
System.out.println(rsp.getBody());

ITopClient client = new DefaultTopClient(url, appkey, secret);
AlibabaDtSqlalgoSimilarityQuerysqlsimilarityRequest req = new AlibabaDtSqlalgoSimilarityQuerysqlsimilarityRequest();
AlibabaDtSqlalgoSimilarityQuerysqlsimilarityRequest.SqlSimilarityRequestDomain obj1 = new AlibabaDtSqlalgoSimilarityQuerysqlsimilarityRequest.SqlSimilarityRequestDomain();
obj1.SqlB = "select *,'A' from tablea where ds = '20230402' and col1 = 'A'";
obj1.TableColumnString = "tablea::1##col1##0,2##col2##0,3##col3##0,4##ds##1";
obj1.SqlA = "select *,'B' from tablea where ds = '20230401' and col1 = 'A'";
obj1.ProjectName = "data_sec";
req.SqlSimilarityRequest_ = obj1;
AlibabaDtSqlalgoSimilarityQuerysqlsimilarityResponse rsp = client.Execute(req);
Console.WriteLine(rsp.Body);

$c = new TopClient;
$c->appkey = $appkey;
$c->secretKey = $secret;
$req = new AlibabaDtSqlalgoSimilarityQuerysqlsimilarityRequest;
$sql_similarity_request = new SqlSimilarityRequest;
$sql_similarity_request->sql_b="select *,'A' from tablea where ds = '20230402' and col1 = 'A'";
$sql_similarity_request->table_column_string="tablea::1##col1##0,2##col2##0,3##col3##0,4##ds##1";
$sql_similarity_request->sql_a="select *,'B' from tablea where ds = '20230401' and col1 = 'A'";
$sql_similarity_request->project_name="data_sec";
$req->setSqlSimilarityRequest(json_encode($sql_similarity_request));
$resp = $c->execute($req);

curl -X POST 'http://gw.api.taobao.com/router/rest' \
-H 'Content-Type:application/x-www-form-urlencoded;charset=utf-8' \
-d 'app_key=12129701' \
-d 'format=json' \
-d 'method=alibaba.dt.sqlalgo.similarity.querysqlsimilarity' \
-d 'partner_id=apidoc' \
-d 'sign=81CABF839A5EB400A7FEE1C133B2CC4A' \
-d 'sign_method=hmac' \
-d 'timestamp=2026-10-04+20%3A20%3A03' \
-d 'v=2.0' \
-d 'sql_similarity_request=null'

# -*- coding: utf-8 -*-
import top.api

req=top.api.AlibabaDtSqlalgoSimilarityQuerysqlsimilarityRequest(url,port)
req.set_app_info(top.appinfo(appkey,secret))

req.sql_similarity_request="数据结构示例JSON格式"
try:
	resp= req.getResponse()
	print(resp)
except Exception,e:
	print(e)

pTopRequest pRequest = alloc_top_request();
pTopResponse pResponse = NULL;
pTaobaoClient pClient = alloc_taobao_client(url, appkey, appsecret);
set_api_name(pRequest,"alibaba.dt.sqlalgo.similarity.querysqlsimilarity");
add_param(pRequest,"sql_similarity_request","数据结构JSON示例");
pResponse = top_execute(pClient,pRequest,NULL);
printf("ret code:%d\n",pResponse->code);
if(pResponse->code == 0){
	pTopResponseIterator ite = init_response_iterator(pResponse);
	pResultItem pResultItem = alloc_result_item();
	while(parseNext(ite, pResultItem) == 0){
		printf("%s:%s\n",pResultItem->key,pResultItem->value);
	}
	destroy_response_iterator(ite);
	destroy_result_item(pResultItem);
}
destroy_top_request(pRequest);
destroy_top_response(pResponse);
destroy_taobao_client(pClient);

TopClient = require('./topClient').TopClient;
var client = new TopClient({
	'appkey': 'appkey',
	'appsecret': 'secret',
	'url': 'http://gw.api.taobao.com/router/rest'
});

client.execute('alibaba.dt.sqlalgo.similarity.querysqlsimilarity', {
	'sql_similarity_request':'数据结构JSON示例'
}, function(error, response) {
	if (!error) console.log(response);
	else console.log(error);
})

XML示例
JSON示例

<alibaba_dt_sqlalgo_similarity_querysqlsimilarity_response>
    <sql_similarity_result>
        <format_result>{\&quot;SQLB\&quot;:{\&quot;fp\&quot;:\&quot;98609D4539042A0A796AAF7F2EEDFB7E\&quot;,\&quot;fromatSQL\&quot;:\&quot;SELECT &apos;B&apos; AS __col_0, __ts_0.col1 AS col1, __ts_0.col2 AS col2, __ts_0.col3 AS col3, __ts_0.ds AS ds\\nFROM tablea __ts_0\\nWHERE __ts_0.col1 = &apos;A&apos;\\n\\tAND __ts_0.ds = &apos;20230401&apos;\&quot;,\&quot;sfp\&quot;:\&quot;A25432FB40F32D9CE9D20AA3F43F598B\&quot;},\&quot;SQLA\&quot;:{\&quot;fp\&quot;:\&quot;D9A9B21D60068B7A2196DD9B5F9F70F2\&quot;,\&quot;fromatSQL\&quot;:\&quot;SELECT &apos;A&apos; AS __col_0, __ts_0.col1 AS col1, __ts_0.col2 AS col2, __ts_0.col3 AS col3, __ts_0.ds AS ds\\nFROM tablea __ts_0\\nWHERE __ts_0.col1 = &apos;A&apos;\\n\\tAND __ts_0.ds = &apos;20230402&apos;\&quot;,\&quot;sfp\&quot;:\&quot;A25432FB40F32D9CE9D20AA3F43F598B\&quot;}}</format_result>
        <similar_result>SQLA 与 SQLB 去除常量后完全一致</similar_result>
        <error>SQL parse failed: ...</error>
    </sql_similarity_result>
</alibaba_dt_sqlalgo_similarity_querysqlsimilarity_response>

{
    "alibaba_dt_sqlalgo_similarity_querysqlsimilarity_response":{
        "sql_similarity_result":{
            "format_result":"{\\\"SQLB\\\":{\\\"fp\\\":\\\"98609D4539042A0A796AAF7F2EEDFB7E\\\",\\\"fromatSQL\\\":\\\"SELECT 'B' AS __col_0, __ts_0.col1 AS col1, __ts_0.col2 AS col2, __ts_0.col3 AS col3, __ts_0.ds AS ds\\\\nFROM tablea __ts_0\\\\nWHERE __ts_0.col1 = 'A'\\\\n\\\\tAND __ts_0.ds = '20230401'\\\",\\\"sfp\\\":\\\"A25432FB40F32D9CE9D20AA3F43F598B\\\"},\\\"SQLA\\\":{\\\"fp\\\":\\\"D9A9B21D60068B7A2196DD9B5F9F70F2\\\",\\\"fromatSQL\\\":\\\"SELECT 'A' AS __col_0, __ts_0.col1 AS col1, __ts_0.col2 AS col2, __ts_0.col3 AS col3, __ts_0.ds AS ds\\\\nFROM tablea __ts_0\\\\nWHERE __ts_0.col1 = 'A'\\\\n\\\\tAND __ts_0.ds = '20230402'\\\",\\\"sfp\\\":\\\"A25432FB40F32D9CE9D20AA3F43F598B\\\"}}",
            "similar_result":"SQLA 与 SQLB 去除常量后完全一致",
            "error":"SQL parse failed: ..."
        }
    }
}

XML示例
JSON示例

<error_response>
    <code>50</code>
    <msg>Remote service error</msg>
    <sub_code>isv.invalid-parameter</sub_code>
    <sub_msg>非法参数</sub_msg>
</error_response>

{
	"error_response":{
		"msg":"Remote service error",
		"code":50,
		"sub_msg":"非法参数",
		"sub_code":"isv.invalid-parameter"
	}
}

错误码	错误描述	解决方案

API测试工具错误码查询工具 SDK下载

数据API

alibaba.dt.sqlalgo.similarity.querysqlsimilarity (阿里控股.数据技术与产品部.图治SQL算法开放.检查两条SQL的相似性)

公共参数

请求参数

响应参数

请求示例

响应示例

异常示例

错误码解释

API工具

如何获得此API

FAQ

用户导航

用户反馈

用户反馈

用户反馈