Hi Paul,
I am using Drill v 1.11.0 so I am only seeing sqlline.log and
sqlline_queries.log. hopefully the same.
I am following your instructions and I am not seeing any maxAllocation other
than 10,000,000,000. No other number (or small number) than this. The query
profile reads the following:
Hi Yun,
Sorry, it is a bit confusing. The log will contain two kinds of JSON. One is
the query profile, which is what you found. The other is the physical plan used
to run the query. It is the physical plan you want to find; that is the one
that has the max allocation.
If you can post your log
Hi Yun,
Are you running in Drill embedded mode ? If so , the logs will be available in
sqllline.log and drillbit.log will not be populated. You can enable DEBUG
logging in logback.xml , run the query and share log file as Paul suggested.
Edit $DRILL_HOME/conf/logback.xml to enable DEBUG level
Hi Arjun and Paul,
Yep those are turned and I am reading it from sqlline.log. Only max allocation
number I am reading is 10,000,000,000. Posted the logs in my Dropbox:
https://www.dropbox.com/sh/5akxrzm078jsabw/AADuD92swH6c9jwijTjkkac_a?dl=0
Thank you!
Yun
-Original Message-
From: Arjun
Hi Loubna,
I tried a sample query which returns approximately 10,000 records and it works
for me. I am not familiar with your use case but maybe using LIMIT/OFFSET to
achieve pagination might help instead of requesting the entire data. I am
assuming your data would not be constrained to 100K r
Hi Yun,
Looking at the log shared, You seems to be running below query.
2017-11-06 15:09:37,383 [25ff3e7e-39ef-a175-93e7-e4e62b284add:foreman] INFO
o.a.drill.exec.work.foreman.Foreman - Query text for query id
25ff3e7e-39ef-a175-93e7-e4e62b284add: SELECT * FROM
`dfs`.`Inputs`.`./Compliance.
Hi Andries,
Thanks for the advise .
I am using Drill 1.10 and Tableau version 10.4 .
I am connecting Drill thorugh Apache Drill connector.
By Posting in community I wanted the know whether the issue is at tableau
server or at Apache Drill ?
Thanks,
Divya
On 3 November 2017 at 22:05, Andries Enge