1 Reply Latest reply: Sep 3, 2018 3:50 AM by Jian Xu RSS

    why qlik sense generate min/max query in direct query?

    Jian Xu

      I had a direct query script as below in data load editor.

       

      DIRECT QUERY

      DIMENSION

      SESSION_ID as message_session_id

      DETAIL

      DEST_TYPE as dest_type,

      MSG_SUMMARY as message_summary

      FROM `customer_prod`.`messages`;

       

      Then I created a table which has the columns in a sheet. When I reopen my app and open the sheet, qlik sense always send the following sql commands to database.


      SELECT MIN(MSG_SUMMARY) FROM `customer_prod`.`messages`;

      SELECT MIN(DEST_TYPE ) FROM `customer_prod`.`messages`


      Because messages is a huge table, it takes more than 30 seonds to run the sql commands.


      Why qlik sense generate min/max query in direct query? Could we disable the sqls?  becasue I think the sqls with min are not necessary.