智能问数

1{
2  "messages": [
3    // 对话信息
4    {
5      "role": "user",
6      "content": "华北地区2019年的销售额"
7    },
8    {
9      "role": "assistant",
10      "content": "```json\n{\n  \"dimensions\": [\n    \"产品名称\"\n  ],\n  \"measures\": [\n    \"销售额\"\n  ],\n  \"filters\": [\n    {\n      \"k\": \"订单日期\",\n      \"op\": \"between\",\n      \"v\": [\n        \"2019-04-01\",\n        \"2019-04-30\"\n      ]\n    }\n  ],\n  \"filtersRate\": [\n    {\n      \"k\": \"订单日期\",\n      \"op\": \"between\",\n      \"v\": [\n        \"2019-03-01\",\n        \"2019-03-31\"\n      ]\n    }\n  ],\n  \"aggregator\": [\n    {\n      \"type\": \"SUM\",\n      \"field\": \"销售额\"\n    }\n  ]\n}\n```"
11    },
12    {
13      "role": "user",
14      "content": "各省份2019年各月的销售额"
15    }
16  ],
17  "dataModelHash": "mld_ada15-9c2ccod1-46jxow4" // 数据模型hash
18}

1{
2    "status": 0,
3    "msg": "",
4    "data": {
5        "messages": [
6            {
7                "role": "user",
8                "content": "华北地区2019年的销售额"
9            },
10            {
11                "role": "assistant",
12                "content": "```json\n{\n  \"dimensions\": [\n    \"省份\"\n  ],\n  \"measures\": [\n    \"销售额\"\n  ],\n  \"filters\": [\n    {\n      \"k\": \"地区\",\n      \"op\": \"=\",\n      \"v\": \"华北\"\n    },\n    {\n      \"k\": \"订单日期\",\n      \"op\": \"between\",\n      \"v\": [\n        \"2019-01-01\",\n        \"2019-12-31\"\n      ]\n    }\n  ]\n}\n```"
13            }
14        ],
15        "result": {        // 智能问数结果
16            "dimensions": [  // 维度信息
17                "省份"
18            ],
19            "measures": [   // 度量信息
20                "销售额"
21            ],
22            "filters": [   // 筛选条件
23                {
24                    "k": "订单日期",  // 字段信息
25                    "op": "between", // 连接方式（>、<、>=、<=、=、!=、between、in、notIn）
26                    "v": [           // 过滤条件取值
27                        "2019-01-01",
28                        "2019-12-31"
29                    ]
30                },
31                {
32                    "k": "地区",
33                    "op": "equal",
34                    "v": [
35                        "华北"
36                    ]
37                }
38            ],
39            "sort": "desc",          // 排序方式，asc(正序)|desc(倒序)
40            "limit": 10,             // limit取值
41            "aggregator": [          // 聚合信息
42                {
43                    "type": "SUM|AVG|MAX|MIN|COUNT", // 聚合方式，SUM(求和)|AVG(均值)|MAX(最大值)|MIN(最小值)|COUNT(计数)
44                    "fileld": ""                     // 字段信息
45                }
46            ],
47            "dateAggregation": [      // 日期聚合
48                {
49                    "type": "YEAR-MONTH",  // 类型，YEAR(年)、YEAR-QUARTER(年-季度)、YEAR-MONTH(年-月)、YEAR-WEEK(年-周)、YEAR-MONTH-DAY(年-月-日)、QUARTER(季度)、MONTH(月)、WEEK(周)、DAYOFWEEK(星期)、DAY(日)、YEAR-MONTH-DAY-HOUR(年-月-日-小时)、YEAR-MONTH-DAY-HOUR-MINUTE(年-月-日 小时-分)
50                    "field": "订单日期"
51                }
52            ],
53            "rateConfig": [          // 同环比相关信息
54                {
55                    "type": "环比",  // 类型，环比、周同比、月同比、季同比、年同比
56                    "field": "销售额"
57                }
58            ]
59        },
60        // sql 语句
61        "sql": "SELECT                
62                    SUM(`sale_order`.`价格`) AS FLWQ5ZQSX183UWIRL
63                FROM
64                    `sale_order`
65                WHERE
66                      ((`sale_order`.`订单日期` >= '2019-01-01' AND `sale_order`.`订单日期` <= '2019-12-31') AND             `sale_order`.`地区` = '华北')
67                ORDER BY
68                    SUM(`sale_order`.`价格`) desc
69                LIMIT 0, 10000",
70        "fields": {                        // 字段信息
71            "FLWQ5ZQSX183UWIRL": {
72                "alias": "销售额",          // 字段别名
73                "calculated": false,       // 是否计算字段
74                "tableCal": false,         // 是否表计算字段，只有度量字段才会有表计算字段
75                "dataType": "float",       // 数据类型，string|float|int|date|datetime|timestamp
76                "expression": "",          // 计算字段表达式|表计算字段表达式
77                "field": "价格",           // 字段信息
78                "isAggregated": false,     // 是否聚合字段
79                "isHidden": false,         // 是否隐藏字段
80                "table": "sale_order",     // 表信息
81                "type": "measure"          // 字段类型，measure(度量)、dimension(维度)
82            }
83        }
84    }
85}

1{
2  "msg": "错误详情",
3  "status": 499
4}