convert sql to elasticsearch DSL in golang(go)

select * from aaa where remote_addr="111.206.36.1" limit 10; 转换为: {"query" : {"bool" : {"must" : [{"match" : {"remote_addr" : {"query" : "111.206.36.1", "type" : "phrase"}}}]}},"from" : 0,"size" : 10}

用该dsl语句查询的时候: { "error": { "root_cause": [ { "type": "parsing_exception", "reason": "[match] query does not support [type]", "line": 1, "col": 84 } ], "type": "parsing_exception", "reason": "[match] query does not support [type]", "line": 1, "col": 84 }, "status": 400 }

必须要删除 "type" : "phrase" 才行

原始sql

SELECT
    `familyCode`
FROM
    `myTable`
WHERE
    (`admin` LIKE '%v!_xxx%' ESCAPE '!')
ORDER BY
    `updateTime` DESC
LIMIT
    10

其中要对admin字段双侧LIKE字符串v_xxx。 输出的结果：

{
    "query": {
        "bool": {
            "must": [
                {
                    "match_phrase": {
                        "admin": {
                            "query": "v!_xxx"
                        }
                    }
                }
            ]
        }
    },
    "from": 0,
    "size": 10,
    "sort": [
        {
            "updateTime": "desc"
        }
    ]
}

其中query.bool.must[0].match_phrase.admin.query字段的值中，! 没有去掉。

Hello i need to know when we make it large query have alot of join inside SQL possible to make by your Go solution to Elastic Query match ?

Thanks, George

First of all thanks for the great work!

The functionality check-list mentions that like operator is implemented for phrase search.

However, in the example, although the strict equality = is used, the generated elasticsearch query is a phrase match. In that case, as far as I understood, shouldn't it generate a term search instead?

If the example is correct, what is the way to generate a term search query?

	if Pretty {
		var prettyJSON bytes.Buffer
		err = json.Indent(&prettyJSON, []byte(dsl), "", "  ")
		if err != nil {
			dsl = ""
		} else {
			dsl = string(prettyJSON.Bytes())
		}
	}

elaticsearch sql have below dsl, { "aggs" : { "articles_over_time" : { "date_histogram" : { "field" : "date", "interval" : "1.5h" } } } }

is it possible?

使用例程转换下列语句为DSL的时候，来源
select * from table_name group by date_histogram(field='create_time', interval='1h') 报错 syntax error at position 81

interval要改成value么？

original SQL :

select title, price from products where title = '%A%'

expect like that :

{
    "_source": [
        "title",
        "price",
    ],
    "query": {
        "bool": {
            "must": [
                {
                    "match_phrase": {
                        "title": {
                            "query": "%A%"
                        }
                    }
                }
            ]
        }
    },
    "from": 0,
    "size": 1
} 

actually, elasticsql.Convert(sql) didn't generate "_source":["title", "price"]

sql like : select count(id) from A where A.id > 5 group by A.a, A.b; because of innerMap["terms"] = msi{ "field": colName.Name.String(), "size": 0, } will gen the dsl like: "terms":{"field":"field2","size":0} and then make a error: "reason":"[size] must be greater than 0 using es7.X