How fast is Drill actually .Is it good for interactive queries .
Our current environment is HDP 2.4 ,Hive 1.0 with TEZ execution engine .Interactive queries are quite slow .
Are we going to get any significant improvement by moving in to Drill or HDP 2.5 with Hive 2.0 would be a better option .
Please give me your valuable inputs.
HDP 2.5 comes with LLAP in tech preview. We got some significant performance improvements with LLAP for interactive queries at one customer implementation. My suggestion is to give it a try with LLAP since you already have data in Hive and you won't need much work to get LLAP working.