Skip to content
This repository has been archived by the owner on Sep 20, 2023. It is now read-only.

Athena is expecting an outputLocation ? #71

Closed
soda29 opened this issue Nov 15, 2018 · 1 comment
Closed

Athena is expecting an outputLocation ? #71

soda29 opened this issue Nov 15, 2018 · 1 comment

Comments

@soda29
Copy link

soda29 commented Nov 15, 2018

I have been receiving this error since yesterday:
validation error detected: Value null at 'outputLocation'

This is my connection string:

   conn = connect(
        s3_staging_dir='s3://aws-athena-query-results-{}-us-east-1/'.format(env.get('AWS_ACCOUNT_ID')),
        region_name='us-east-1',
        access_key=kms.decrypt(access_key_encrypted),
        secret_key=kms.decrypt(secret_key_encrypted),
    )
@laughingman7743
Copy link
Owner

laughingman7743 commented Nov 15, 2018

The specification of outputLocation should be fine with s3_staging_dir.
https://github.com/laughingman7743/PyAthenaJDBC/blob/master/pyathenajdbc/connection.py#L127

You may find the cause by setting the Trace log output as follows.

conn = connect(s3_staging_dir='s3://YOUR_S3_BUCKET/path/to/',
               region_name='us-east-1',
               LogLevel='6',
               LogPath='./')

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants