DEBUG:botocore.endpoint:Sending http request: <AWSPreparedRequest stream_output=False, method=POST, url=https://athena.us-east-2.amazonaws.com/, headers={'X-Amz-Target': b'AmazonAthena.GetQueryResults', 'Content-Type': b'application/x-amz-json-1.1', 'User-Agent': b'Boto3/1.10.34 Python/3.7.4 Windows/10 Botocore/1.13.50', 'X-Amz-Date': b'20200212T134450Z', 'Authorization': b'AWS4-HMAC-SHA256 Credential=XXXXXXXX/XXXXX/athena/aws4_request, SignedHeaders=content-type;host;x-amz-date;x-amz-target, Signature=XXXXXXXXXXXXXXXXXXXXXXXXXXXXX', 'Content-Length': '80'}>
DEBUG:urllib3.connectionpool:https://athena.us-east-2.amazonaws.com:443 "POST / HTTP/1.1" 200 4931
DEBUG:botocore.parsers:Response headers: {'Content-Type': 'application/x-amz-json-1.1', 'Date': 'Wed, 12 Feb 2020 13:44:49 GMT', 'x-amzn-RequestId': '65XXX7f-cXX1-4XXb-9XX8-aXXXXXXXXf5', 'Content-Length': '4931', 'Connection': 'keep-alive'}
DEBUG:botocore.parsers:Response body:
b'{"ResultSet":{"ColumnInfos":[{"CaseSensitive":true,"CatalogName":"hive","Label":"table_schema","Name":"table_schema","Nullable":"UNKNOWN","Precision":2147483647,"Scale":0,"SchemaName":"","TableName":"","Type":"varchar"},{"CaseSensitive":true,"CatalogName":"hive","Label":"table_name","Name":"table_name","Nullable":"UNKNOWN","Precision":2147483647,"Scale":0,"SchemaName":"","TableName":"","Type":"varchar"},{"CaseSensitive":true,"CatalogName":"hive","Label":"column_name","Name":"column_name","Nullable":"UNKNOWN","Precision":2147483647,"Scale":0,"SchemaName":"","TableName":"","Type":"varchar"}],"ResultRows":[{"Data":["table_schema","table_name","column_name"]},{"Data":["sampledb","elb_logs","request_timestamp"]},{"Data":["sampledb","elb_logs","elb_name"]},{"Data":["sampledb","elb_logs","request_ip"]},{"Data":["sampledb","elb_logs","backend_ip"]},{"Data":["sampledb","elb_logs","elb_response_code"]},{"Data":["sampledb","elb_logs","backend_response_code"]},{"Data":["sampledb","elb_logs","request_verb"]},{"Data":["sampledb","elb_logs","url"]},{"Data":["sampledb","elb_logs","protocol"]},{"Data":["sampledb","elb_logs","user_agent"]},{"Data":["sampledb","elb_logs","ssl_cipher"]},{"Data":["sampledb","elb_logs","ssl_protocol"]},{"Data":["temp","pii_data","phone"]},{"Data":["temp","pii_data","email"]},{"Data":["temp","pii_data","credit_card"]},{"Data":["temp","pii_data","address"]},{"Data":["temp","pii_data","person"]},{"Data":["temp","pii_data","location"]},{"Data":["temp","pii_data","gender"]},{"Data":["temp","pii_data","nationality"]},{"Data":["temp","pii_data","ip_address"]},{"Data":["temp","pii_data","ssn"]},{"Data":["testdb","test5","tst6"]},{"Data":["testdb","test6","tst7"]},{"Data":["testdb","test8","tst2"]},{"Data":["testdb","test9","tst11"]}],"ResultSetMetadata":{"ColumnInfo":[{"CaseSensitive":true,"CatalogName":"hive","Label":"table_schema","Name":"table_schema","Nullable":"UNKNOWN","Precision":2147483647,"Scale":0,"SchemaName":"","TableName":"","Type":"varchar"},{"CaseSensitive":true,"CatalogName":"hive","Label":"table_name","Name":"table_name","Nullable":"UNKNOWN","Precision":2147483647,"Scale":0,"SchemaName":"","TableName":"","Type":"varchar"},{"CaseSensitive":true,"CatalogName":"hive","Label":"column_name","Name":"column_name","Nullable":"UNKNOWN","Precision":2147483647,"Scale":0,"SchemaName":"","TableName":"","Type":"varchar"}]},"Rows":[{"Data":[{"VarCharValue":"table_schema"},{"VarCharValue":"table_name"},{"VarCharValue":"column_name"}]},{"Data":[{"VarCharValue":"sampledb"},{"VarCharValue":"elb_logs"},{"VarCharValue":"request_timestamp"}]},{"Data":[{"VarCharValue":"sampledb"},{"VarCharValue":"elb_logs"},{"VarCharValue":"elb_name"}]},{"Data":[{"VarCharValue":"sampledb"},{"VarCharValue":"elb_logs"},{"VarCharValue":"request_ip"}]},{"Data":[{"VarCharValue":"sampledb"},{"VarCharValue":"elb_logs"},{"VarCharValue":"backend_ip"}]},{"Data":[{"VarCharValue":"sampledb"},{"VarCharValue":"elb_logs"},{"VarCharValue":"elb_response_code"}]},{"Data":[{"VarCharValue":"sampledb"},{"VarCharValue":"elb_logs"},{"VarCharValue":"backend_response_code"}]},{"Data":[{"VarCharValue":"sampledb"},{"VarCharValue":"elb_logs"},{"VarCharValue":"request_verb"}]},{"Data":[{"VarCharValue":"sampledb"},{"VarCharValue":"elb_logs"},{"VarCharValue":"url"}]},{"Data":[{"VarCharValue":"sampledb"},{"VarCharValue":"elb_logs"},{"VarCharValue":"protocol"}]},{"Data":[{"VarCharValue":"sampledb"},{"VarCharValue":"elb_logs"},{"VarCharValue":"user_agent"}]},{"Data":[{"VarCharValue":"sampledb"},{"VarCharValue":"elb_logs"},{"VarCharValue":"ssl_cipher"}]},{"Data":[{"VarCharValue":"sampledb"},{"VarCharValue":"elb_logs"},{"VarCharValue":"ssl_protocol"}]},{"Data":[{"VarCharValue":"temp"},{"VarCharValue":"pii_data"},{"VarCharValue":"phone"}]},{"Data":[{"VarCharValue":"temp"},{"VarCharValue":"pii_data"},{"VarCharValue":"email"}]},{"Data":[{"VarCharValue":"temp"},{"VarCharValue":"pii_data"},{"VarCharValue":"credit_card"}]},{"Data":[{"VarCharValue":"temp"},{"VarCharValue":"pii_data"},{"VarCharValue":"address"}]},{"Data":[{"VarCharValue":"temp"},{"VarCharValue":"pii_data"},{"VarCharValue":"person"}]},{"Data":[{"VarCharValue":"temp"},{"VarCharValue":"pii_data"},{"VarCharValue":"location"}]},{"Data":[{"VarCharValue":"temp"},{"VarCharValue":"pii_data"},{"VarCharValue":"gender"}]},{"Data":[{"VarCharValue":"temp"},{"VarCharValue":"pii_data"},{"VarCharValue":"nationality"}]},{"Data":[{"VarCharValue":"temp"},{"VarCharValue":"pii_data"},{"VarCharValue":"ip_address"}]},{"Data":[{"VarCharValue":"temp"},{"VarCharValue":"pii_data"},{"VarCharValue":"ssn"}]},{"Data":[{"VarCharValue":"testdb"},{"VarCharValue":"test5"},{"VarCharValue":"tst6"}]},{"Data":[{"VarCharValue":"testdb"},{"VarCharValue":"test6"},{"VarCharValue":"tst7"}]},{"Data":[{"VarCharValue":"testdb"},{"VarCharValue":"test8"},{"VarCharValue":"tst2"}]},{"Data":[{"VarCharValue":"testdb"},{"VarCharValue":"test9"},{"VarCharValue":"tst11"}]}]},"UpdateCount":0}'
DEBUG:botocore.hooks:Event needs-retry.athena.GetQueryResults: calling handler <botocore.retryhandler.RetryHandler object at 0x00000212E5B93388>
DEBUG:botocore.retryhandler:No retry needed.
DEBUG:root:Count Query: select count(*) from temp.pii_data
DEBUG:pyathena.common:select count(*) from temp.pii_data
DEBUG:botocore.hooks:Event before-parameter-build.athena.StartQueryExecution: calling handler <function generate_idempotent_uuid at 0x00000212E55A0C18>
DEBUG:botocore.handlers:injecting idempotency token (eXXXXXe-831f-4XX0-8XXf-2XXXXXXf2) into param 'ClientRequestToken'.
DEBUG:botocore.hooks:Event before-call.athena.StartQueryExecution: calling handler <function inject_api_version_header_if_needed at 0x00000212E55A3708>
DEBUG:botocore.endpoint:Making request for OperationModel(name=StartQueryExecution) with params: {'url_path': '/', 'query_string': '', 'method': 'POST', 'headers': {'X-Amz-Target': 'AmazonAthena.StartQueryExecution', 'Content-Type': 'application/x-amz-json-1.1', 'User-Agent': 'Boto3/1.10.34 Python/3.7.4 Windows/10 Botocore/1.13.50'}, 'body': b'{"QueryString": "select count(*) from temp.pii_data", "QueryExecutionContext": {"Database": "default"}, "ResultConfiguration": {"OutputLocation": "s3://pii-logs-test/piitest/2/1/"}, "ClientRequestToken": "eXXXXX1f-4XX0-8DDDf-2XXXXXXX1f2"}', 'url': 'https://athena.us-east-2.amazonaws.com/', 'context': {'client_region': 'us-east-2', 'client_config': <botocore.config.Config object at 0x00000212E5B79808>, 'has_streaming_input': False, 'auth_type': None}}
DEBUG:botocore.hooks:Event request-created.athena.StartQueryExecution: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x00000212E5B797C8>>
DEBUG:botocore.hooks:Event choose-signer.athena.StartQueryExecution: calling handler <function set_operation_specific_signer at 0x00000212E55A0168>
DEBUG:botocore.auth:Calculating signature using v4 auth.
DEBUG:botocore.auth:CanonicalRequest: