search

apache / airflow

Apache Airflow - A platform to programmatically author, schedule, and monitor workflows
https://airflow.apache.org/
Apache License 2.0
36.16k stars 14.04k forks source link

The query stuck for hive2 #48

Closed griffinqiu closed 9 years ago

griffinqiu commented 9 years ago

I used a simple query for a hive2 connection. It have been sucked. I cannot get the result ;(

2015-06-19 10:20:56,647 - tornado.access - INFO - 200 GET /admin/queryview/ (10.196.11.238) 19.21ms 2015-06-19 10:21:02,962 - root - INFO - Using connection to: localhost 2015-06-19 10:21:02,965 - root - INFO - Using connection to: localhost

mistercrunch commented 9 years ago

Is your hiveserver2 service working properly? Can you telnet into that localhost port? Can you use pyhive directly against it?

griffinqiu commented 9 years ago

I found the reason, it because the authMechanism is NOSASL. My ENV is PLAIN. The issue is strange, there is no error log, no timeout.

griffinqiu commented 9 years ago

Could we have the authMechanism configure in connections setting?

mistercrunch commented 9 years ago

Yes, I'm adding it and refactoring HiveServer2Hook a bit in the process, expect a PR today

mistercrunch commented 9 years ago

https://github.com/airbnb/airflow/pull/71