Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
yegor_kiryanov
Contributor
Contributor

Direct Discovery. Tablebox component produces wrong queries

Hello,

I'm trying to setup direct discovery feature for accessing Elasticsearch via ODBC connector. My connection script is the following:

ODBC CONNECT TO [ES1 Sys];

DIRECT QUERY

  DETAIL "text1", "text2"

  DIMENSION "code"

  FROM ...;

I've added tablebox component with the following fields: "code", "text1", "text2"

2018-02-06_1736.png

According to log in ODBC connector, tablebox component produces the following query:

SELECT "code", "text1", "text2" FROM ... GROUP BY "code", "text1", "text2"

It adds field into "group by" section for each field in "select" section. As a result, elasticsearch receives wrong query:

{

    "from": 0,

    "size": 0,

    "aggregations": {

        "code": {

            "terms": {

                "field": "code",

                "size": 2147483647,

                "min_doc_count": 1,

                "shard_min_doc_count": 0,

                "show_term_doc_count_error": false,

                "order": [

                    {

                        "_count": "desc"

                    },

                    {

                        "_key": "asc"

                    }

                ]

            },

            "aggregations": {

                "text1": {

                    "terms": {

                        "field": "text1",

                        "size": 2147483647,

                        "min_doc_count": 1,

                        "shard_min_doc_count": 0,

                        "show_term_doc_count_error": false,

                        "order": [

                            {

                                "_count": "desc"

                            },

                            {

                                "_key": "asc"

                            }

                        ]

                    },

                    "aggregations": {

                        "text2": {

                            "terms": {

                                "field": "text2",

                                "size": 2147483647,

                                "min_doc_count": 1,

                                "shard_min_doc_count": 0,

                                "show_term_doc_count_error": false,

                                "order": [

                                    {

                                        "_count": "desc"

                                    },

                                    {

                                        "_key": "asc"

                                    }

                                ]

                            }

                        }

                    }

                }

            }

        }

    }

}

Could you please explain what I'm doing wrong? It's a weird behavior, I expect simple "select" with "where" clause.

Thanks in advance.

0 Replies