Untitled

mail@pastecode.io avatar
unknown
python
a year ago
2.2 kB
7
Indexable
Never
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'