Untitled
unknown
python
2 years ago
2.2 kB
10
Indexable
File "/mnt/apps/adthena-bi/adthena_bi/apps/laithwaites_brand_activator_dashboard_etl/main.py", line 40, in run_app brand_activator_calculation_tasks.calculate_savings() File "/mnt/apps/adthena-bi/adthena_bi/data_apps/brand_activator/brand_activator_calculation_tasks.py", line 272, in calculate_savings self.get_historical_unit_cost() File "/mnt/apps/adthena-bi/adthena_bi/data_apps/brand_activator/brand_activator_calculation_tasks.py", line 148, in get_historical_unit_cost campaign_id=row["campaign_id"], File "/mnt/apps/adthena-bi/adthena_bi/data_apps/brand_activator/brand_activator_roi_query.py", line 70, in get_brand_activator_historical_unit_cost database=Config.ATHENA_DATABASE, File "/mnt/apps/adthena-bi/py/lib/python3.6/site-packages/awswrangler/_config.py", line 417, in wrapper return function(**args) File "/mnt/apps/adthena-bi/py/lib/python3.6/site-packages/awswrangler/athena/_read.py", line 861, in read_sql_query boto3_session=session, File "/mnt/apps/adthena-bi/py/lib/python3.6/site-packages/awswrangler/athena/_read.py", line 587, in _resolve_query_without_cache boto3_session=boto3_session, File "/mnt/apps/adthena-bi/py/lib/python3.6/site-packages/awswrangler/athena/_read.py", line 497, in _resolve_query_without_cache_regular boto3_session=boto3_session, File "/mnt/apps/adthena-bi/py/lib/python3.6/site-packages/awswrangler/athena/_utils.py", line 167, in _start_query_execution **args, File "/mnt/apps/adthena-bi/py/lib/python3.6/site-packages/awswrangler/_utils.py", line 331, in try_it return f(**kwargs) File "/mnt/apps/adthena-bi/py/lib/python3.6/site-packages/botocore/client.py", line 388, in _api_call return self._make_api_call(operation_name, kwargs) File "/mnt/apps/adthena-bi/py/lib/python3.6/site-packages/botocore/client.py", line 708, in _make_api_call raise error_class(parsed_response, operation_name) botocore.errorfactory.InvalidRequestException: An error occurred (InvalidRequestException) when calling the StartQueryExecution operation: line 8:29: mismatched input 'IN'. Expecting: ')', 'AND', 'EXCEPT', 'GROUP', 'HAVING', 'INTERSECT', 'LIMIT', 'OFFSET', 'OR', 'ORDER', 'UNION'
Editor is loading...