Hello! Thanks for the help :) So, with '=' operator, all queries killed drill. *like '%' limit 10 *worked. *like '%[email protected] <[email protected]>'* crashed but *like '%*[email protected] *'* returned answers. Something with the %le(..) messes things up it seems. (yes, it's 'le' at the end; didn't want to share too much sensitive information). Now, I can move up to ~limit 100 and above that, drill is killed again. Maybe this is memory related or a corrupted file is still an option?
Thanks! On Fri, Mar 4, 2016 at 9:22 PM, Jacques Nadeau <[email protected]> wrote: > Hey Assaf, is there anything in the logs? Can you email me them directly or > put on gist (can't attach to mailing list emails). > > If nothing there, can you enable Java assertions by adding -ea to > drill-env.sh and see if we get a more helpful log or error messages? > > thanks, > Jacques > > > -- > Jacques Nadeau > CTO and Co-Founder, Dremio > > On Fri, Mar 4, 2016 at 2:46 AM, Assaf Lowenstein <[email protected]> > wrote: > > > Hello Drillers! > > My Drill setup is very simple, querying static gz files that hold jsons. > > Everything was running smooth but we're now seeing what seems to be a > crash > > with a very simple query. here are the details. > > > > This query works > > *select `column1`, column2, myTable.`user`, column3 from > dfs.drill.myTable > > limit 10;* > > > > but this one crashes drill for some reason: > > *select `column1 `, column2, myTable.`user`, column3 from > > dfs.drill. myTable where myTable.`user` = '[email protected] > > <[email protected]>' limit 10;* > > > > I'm using web UI and in console I simply see - > > [..] > > 0: jdbc:drill:zk=local> SLF4J: Failed to load class > > "org.slf4j.impl.StaticLoggerBinder". > > SLF4J: Defaulting to no-operation (NOP) logger implementation > > SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for > further > > details. > > *Killed* > > [..] > > and prompt returns at this stage and I need to restart drill. > > > > Am I doing anything wrong? missing anything? > > Thanks! > > > > Assaf > > > -- *Assaf Lowenstein*, *QA Manager, Totango* http://www.totango.com | Contact me @ cell: +(972) 052-4235550
