[GitHub] kkhatua commented on issue #1608: DRILL-6960: Auto Limit Wrapping should not apply to non-select query

[GitBox]

kkhatua commented on issue #1608: DRILL-6960: Auto Limit Wrapping should not 
apply to non-select query
URL: https://github.com/apache/drill/pull/1608#issuecomment-456217715
 
 
   Screenshot for profile when query is submitted via WebUI with autoLimiting 
to 23 rows:
   Pinned message at Query Text
   
![image](https://user-images.githubusercontent.com/4335237/51502352-9b514e00-1d8a-11e9-91a9-92021d30915f.png)
   
   Pinned message at Operator Overview (since rows are shown here)
   
![image](https://user-images.githubusercontent.com/4335237/51502390-c2a81b00-1d8a-11e9-8dfd-ff913de1f883.png)
   
   Screenshot of profile where non-select query was submitted with auto-limit 
of 3 (no pinned messages):
   
![image](https://user-images.githubusercontent.com/4335237/51502415-de132600-1d8a-11e9-8487-be7a3243549b.png)
   
   Console output
   ```
   2019-01-21 13:26:09,432 kk127.lab 
[23b9c70d-cb96-dd12-26b7-1380e3544bda:foreman] INFO  
o.a.drill.exec.work.foreman.Foreman - Query text for query with id 
23b9c70d-cb96-dd12-26b7-1380e3544bda issued by mapr: show databases
   2019-01-21 13:26:09,436 kk127.lab 
[23b9c70d-cb96-dd12-26b7-1380e3544bda:foreman] DEBUG  
o.a.d.e.planner.sql.DrillSqlWorker - Disabled Auto limit for show databases
   2019-01-21 13:26:09,744 kk127.lab 
[23b9c70d-cb96-dd12-26b7-1380e3544bda:frag:0:0] INFO  
o.a.d.e.w.fragment.FragmentExecutor - 23b9c70d-cb96-dd12-26b7-1380e3544bda:0:0: 
State change requested AWAITING_ALLOCATION --> RUNNING
   2019-01-21 13:26:09,766 kk127.lab 
[23b9c70d-cb96-dd12-26b7-1380e3544bda:frag:0:0] INFO  
o.a.d.e.w.fragment.FragmentExecutor - 23b9c70d-cb96-dd12-26b7-1380e3544bda:0:0: 
State change requested RUNNING --> FINISHED
   2019-01-21 13:26:09,777 kk127.lab 
[23b9c70d-cb96-dd12-26b7-1380e3544bda:frag:0:0] DEBUG 
o.a.drill.exec.work.foreman.Foreman - 23b9c70d-cb96-dd12-26b7-1380e3544bda: 
cleaning up.
   2019-01-21 13:26:09,779 kk127.lab 
[23b9c70d-cb96-dd12-26b7-1380e3544bda:frag:0:0] INFO  query.logger - 
{"queryId":"23b9c70d-cb96-dd12-26b7-1380e3544bda","schema":"","queryText":"show 
databases","start":1548105969411,"finish":1548105969778,"outcome":"COMPLETED","username":"mapr","remoteAddress":"172.30.11.185:58039"}
   ```
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services