Hi, Extremely sorry for the delayed response!
Basically , I am experimenting an Apache Solr plugin for Drill and tried to use Tableau. On intial selection of a "Table" , I see these queries from drill webui profile SELECT * FROM (SELECT * FROM `solr`.`CSVStringData`) T LIMIT 0 SELECT * FROM (SELECT SUM(1) AS `COL` FROM `solr`.`CSVStringData` `CSVStringData` HAVING COUNT(1)>0) T LIMIT 0 I have a dataset of 2,297,451,8 and when I try access that,the tableau screen in kind of stuck in "Processing Request" for 5 minutes. Thanks, Sudip -----Original Message----- From: Andries Engelbrecht [mailto:aengelbre...@maprtech.com] Sent: 20 February 2016 AM 03:42 To: dev@drill.apache.org Subject: Re: Optimizing SUM(1) query What are you trying to do in Tableau that generates these queries? Do you have the actual full query that is being generated? Tableau has a number of customization features, wonder if it is possible to optimize those settings to avoid this issue. --Andries > On Feb 19, 2016, at 10:16 AM, Sudip Mukherjee <smukher...@commvault.com> > wrote: > > Hi, > > Have anyone tried optimizing SUM(1) query in drill? Or is it implemented? > Getting these query while using Tableau. Mostly probably it is trying to > figure out NUMBER_OF_RECORDS. > > Thanks, > Sudip > > > > ***************************Legal Disclaimer*************************** > "This communication may contain confidential and privileged material > for the sole use of the intended recipient. Any unauthorized review, > use or distribution by others is strictly prohibited. If you have > received the message by mistake, please advise the sender by reply email and > delete the message. Thank you." > ********************************************************************** ***************************Legal Disclaimer*************************** "This communication may contain confidential and privileged material for the sole use of the intended recipient. Any unauthorized review, use or distribution by others is strictly prohibited. If you have received the message by mistake, please advise the sender by reply email and delete the message. Thank you." **********************************************************************