You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by GitBox <gi...@apache.org> on 2020/06/15 13:59:44 UTC
[GitHub] [airflow] DanilBaibak opened a new issue #9309: Bug / ThresholdCheckOperator Does Not Work
DanilBaibak opened a new issue #9309:
URL: https://github.com/apache/airflow/issues/9309
**Apache Airflow version**: 1.10.10
**Environment**:
- **Cloud provider or hardware configuration**:
- **OS**: Debian GNU/Linux 10 (buster)
- **Kernel**: Linux b62a643fb26c 4.9.184-linuxkit #1 SMP Tue Jul 2 22:58:16 UTC 2019 x86_64 GNU/Linux
- **Install tools**: pip
**What happened**:
I tried to use [ThresholdCheckOperator](https://airflow.apache.org/docs/stable/_api/airflow/operators/check_operator/index.html#airflow.operators.check_operator.ThresholdCheckOperator):
```
check_amount_value = ThresholdCheckOperator(
task_id='check_amount_value',
sql='SELECT MAX(amount) FROM interaction WHERE interaction_date=CURRENT_DATE',
max_threshold=1500,
min_threshold=1100,
conn_id=CONN_ID
)
```
I caught such error:
```
[2020-06-15 13:49:25,639] {taskinstance.py:1145} ERROR - 'int' object is not subscriptable
Traceback (most recent call last):
File "/usr/local/lib/python3.7/site-packages/airflow/models/taskinstance.py", line 983, in _run_raw_task
result = task_copy.execute(context=context)
File "/usr/local/lib/python3.7/site-packages/airflow/operators/check_operator.py", line 375, in execute
result = hook.get_first(self.sql)[0][0]
TypeError: 'int' object is not subscriptable
```
**What you expected to happen**:
I expected that the check will be passed without any error.
**How to reproduce it**:
Here is the [dockerized application](https://github.com/DanilBaibak/ml-in-production), where I played around with all available checks. All [check operators](https://github.com/DanilBaibak/ml-in-production/blob/master/dags/ml_project/dag_ml_project.py) work correctly except **ThresholdCheckOperator**.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [airflow] DanilBaibak closed issue #9309: Bug / ThresholdCheckOperator Does Not Work
Posted by GitBox <gi...@apache.org>.
DanilBaibak closed issue #9309:
URL: https://github.com/apache/airflow/issues/9309
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [airflow] boring-cyborg[bot] commented on issue #9309: Bug / ThresholdCheckOperator Does Not Work
Posted by GitBox <gi...@apache.org>.
boring-cyborg[bot] commented on issue #9309:
URL: https://github.com/apache/airflow/issues/9309#issuecomment-644152476
Thanks for opening your first issue here! Be sure to follow the issue template!
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [airflow] DanilBaibak commented on issue #9309: Bug / ThresholdCheckOperator Does Not Work
Posted by GitBox <gi...@apache.org>.
DanilBaibak commented on issue #9309:
URL: https://github.com/apache/airflow/issues/9309#issuecomment-652225005
Fixed!
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org