RE: [HANGOUT] Topics for 10/31/2017
I'd like a talk on 'how to get started debugging Drill.' Without a developer's guide or explicit instructions for getting a debug environment up and running, it's hard for a newcomer to get involved. -Original Message- From: Gautam Parai [mailto:gpa...@mapr.com] Sent: Monday, October 30, 2017 11:27 AM To: dev@drill.apache.org; u...@drill.apache.org Subject: [HANGOUT] Topics for 10/31/2017 Hi, We will have a Drill hangout tomorrow (Tuesday Oct 31) at 10 AM Pacific Time. Please suggest topics by replying to this thread or bring them up during the hangout. Hangout link: https://plus.google.com/hangouts/_/event/ci4rdiju8bv04a64efj5fedd0lc Thanks, Gautam
Re: Newbie: Help debugging Drill
Charles, I'm querying a Parquet file that I created by running a bunch of .json through Kite SDK. The data describes playback of video assets by mobile devices. The exact query that's causing the exception is: select internalsessionid, flatten(playbacksegments['array'])['playbackstarttimestamp'] b from MyTable limit 4097; Where internalsessionid is a Guid represented as a string, and playbacksegments['array'] is an array of complex objects. When my limit is 4096, the query returns successfully. When the limit is 4097 I get the crash. My data file contains company proprietary information, so I'm not able/willing to post it publicly (although I could probably share with the Drill devs). I attempted to create a dummy file with which to repro the problem last night, but the problem doesn't manifest with my dummy data. (argh.) -M HI Matthew, Can you describe the data you are querying and the query you are trying to execute? - C > On Oct 2, 2017, at 17:19, Matthew Mucker <matt...@mucker.net> wrote: > > I became a new Drill user last week only to discover that Drill would crash > with an IndexOutOfBounds exception on one of my queries. Some searching and > testing later, my best guess is that I'm hitting DRILL-5451. > >
Newbie: Help debugging Drill
I became a new Drill user last week only to discover that Drill would crash with an IndexOutOfBounds exception on one of my queries. Some searching and testing later, my best guess is that I'm hitting DRILL-5451. Since this is currently a showstopper for me, and since I might learn something by doing so, I thought I'd give it a go and try to debug this problem and see if I might be able to contribute back. I'm finding that when it comes to debugging, I really don't know what I'm doing, and could use some help. Preferably, help made up of small words. I'm running Drill 1.11.0 on Windows 7. To start Drill in debug mode, my best guess was to edit line 182 of sqlline.bat to read: set DRILL_SHELL_JAVA_OPTS=%DRILL_SHELL_JAVA_OPTS% -Dlog.path="%DRILL_LOG_DIR%\sqlline.log" -Dlog.query.path="%DRILL_LOG_DIR%\sqlline_queries.log" -Xdebug -Xrunjdwp:transport=dt_socket,server=y,suspend=y,address=8000 When I run sqlline.bat -u "jdbc:drill:sz=local" now, I get a message "Listening for transport dt_socket at address: 8000" which, I expect, means that the runtime is waiting for the debugger to attach. I downloaded the Drill source and built with Maven. Using Eclipse Neon, I imported the project. I created a debug configuration for a Remote Java Application for project drill-common, on machine localhost:8000. When I start the debug session, sqlline finishes launching and I get a prompt at which I can enter a SQL command. Which suggests to me that the debugger is in fact attached. Inside Eclipse, I set breakpoints on lines 114 and 122 of drill-java-exec/src/main/java/io.netty.buffer/DrillBuf.java. However, when I repro my issue, I get the IndexOutOfBoundsException in sqlline, but there's no indication in Eclipse that the debugger has broken in, and I see no facilities to examine the stack trace or the local variables. What do I do next?