> I have a query that hangs (never returns). However, when i turn on >logging to DEBUG level it works. I'm stumped.
Slowing down things does make a lot of stuff work - logging does something more than slow things down, it actually introduces a synchronization point (global lock) for each log.<level> call that makes it to the final output. Running with the extra locked sections might be avoiding a race condition - that worries me. But the plans are different - very different. > Stage: Stage-0 > Fetch Operator > limit: 1 > Processor Tree: > ListSink Crucial bit - the debug logging produces a 2 stage query. No reason why logging should change the plan there. > any insights greatly appreciated. set hive.fetch.task.conversion=none; I'm guessing that the whole data partition is < 1Gb? Cheers, Gopal
