Let's try and isolate where the issue is. On the same setup, what is the performance you see with Text / Parquet files? Also, do share the query profile.
________________________________ From: Sanjiv Kumar C <[email protected]> Sent: Friday, February 17, 2017 5:17:18 PM To: [email protected] Subject: Drill taking more time to show output Drill Environment:- Version: 1.9 Operating System: Linux Mode: Embedded mode. I have table in sql server having 16 lakh of data. While query through drill having limit 5 but still drill take more time to show output (more than 15 min) Ex:- select * from <pluginName).<schemaName>.<tableName> limit 5; What should i do? -- Thanks & Regards * Sanjiv Kumar*
