[
https://issues.apache.org/jira/browse/AIRFLOW-3054?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Siddharth Anand resolved AIRFLOW-3054.
--------------------------------------
Resolution: Fixed
> Show statements don't work in Hive hook
> ----------------------------------------
>
> Key: AIRFLOW-3054
> URL: https://issues.apache.org/jira/browse/AIRFLOW-3054
> Project: Apache Airflow
> Issue Type: Bug
> Components: hive_hooks
> Reporter: Anton Protopopov
> Assignee: Anton Protopopov
> Priority: Minor
>
> Currently in airflow.hooks.hive_hooks.py in HiveServer2Hook class in
> _get_results method there are filter for incoming hql:
> source code:
> https://github.com/apache/incubator-airflow/blob/a79b92ae40c005d8239dfc7711ff44ae69b9c65b/airflow/hooks/hive_hooks.py#L809-L814
> {code:java}
> # we only get results of statements that returns
> lowered_statement = statement.lower().strip()
> if (lowered_statement.startswith('select') or
> lowered_statement.startswith('with') or
> (lowered_statement.startswith('set') and
> '=' not in lowered_statement)):
> {code}
> Queries which starts with show also returning results (like "show tables in
> default", or "show partitions in default.table_name").
> So I'm thinking it worth to add another statement which starts with "show":
> {code:java}
> lowered_statement.startswith('show')
> {code}
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
