sql

sql copied to clipboard

Why nested has a limit of 3?

6

Search for ` "size" : 3,` in the text below. Why this limit? It appears returning only three result top. I tried to look in code but I couldn't find...

FreCap

the websize say support distinct :  but this sql has no result: String sql = "select distinct id, name, .... from table "; jdbcTemplate.queryForList(sql)。 any advice to solve it?

aimerwhy

By submitting this pull request, I confirm that my contribution is made under the terms of the Apache 2.0 license.

cip999

Bumps [moment](https://github.com/moment/moment) from 2.29.1 to 2.29.4. Changelog Sourced from moment's changelog. 2.29.4 Release Jul 6, 2022 #6015 [bugfix] Fix ReDoS in preprocessRFC2822 regex 2.29.3 Full changelog Release Apr 17, 2022...

dependabot[bot]

When executing sql query via opendistro llike: POST /_opendistro/_sql?format=jdbc { "query":"show tables like my_index_prefix%" } This executes successfully at certain time and fails at random intervals? What might be the...

SonalNew

Bumps [async](https://github.com/caolan/async) from 3.2.0 to 3.2.4. Changelog Sourced from async's changelog. v3.2.4 Fix a bug in priorityQueue where it didn't wait for the result. (#1725) Fix a bug where unshiftAsync...

dependabot[bot]

I'm doing a query, but the error response I get is complaining about another field I'm not selecting. SELECT answer AS answer FROM (SELECT answer FROM indexname) AS virtual_table E.g....

gauravgk78

Comparing date, timestamp and string lead to failures and Date formatted as timestamp

16

Version 1.13 (might be a regression from previous versions) The following query: ``` POST my_test_index_date/_doc/ { "field1": { "subFieldA": "2020-02-02" } } ``` generates the following mapping specifying the field...

FreCap

SSL connect error (code:35; schannel: next InitializeSecurityContext failed: SEC_E_INVALID_TOKEN- The token supplied to the function is invalid) when connecting from ODBC Driver

1

**What I tried:** I configured ODBC with this [link](https://www.elastic.co/guide/en/elasticsearch/reference/master/sql-odbc-setup.html). **Error:** when I connect from Power BI it's throwing the following error ``` Details: "ODBC: ERROR [HY000] [Elastic][EsODBC 6.8.3(v6.8.1-2-g3293650+,u,r) Driver]SSL connect...

AathithRajendran

NPE when use where on left join scenario

4

This was on 1.4.0.0, elasticsearch 7.4.2 below query got NPE ``` select t1.domainIdentity AS domainIdentity, from issue* as t1 left join config as dc on t1.id.keyword = dc.id.keyword WHERE tms.issueType...

seraphjiang