Hive query takes lot of time


#1

Hi Guys,
I am using redash to connect to hive and sql server. I am running same query on both the instances. I get result from sql server instance with in 1 minute but from hive it gets to 40 minutes and sometimes doesn’t even retrieve data. IF i run the query from hive shell it takes 2 mins and same with sqlserver shell.My table size is same on both data sources and same no of columns. Table has 50000 rows and 80 columns. But not able to retreive any data from redash. Also where can i see logs?
Any idea on this??

Debugging
redash store queries and respective data in query_results table in redash. my both queries have same results stored in table, but when i do select data from query_results where id=“given something”, if the table has huge size it dont show anything. Please guide me on this