Please help me on how to execute multiple query and capture the output in a file on e2 **Tried with :** `aws athena start-query-execution --query-string " " > query_output.sql` But above statement is giving only key in the file query_output.sql but I want the output to be capture in a file, please help

Athena - Execute multiple query and capture output in a file on e2

Please help me on how to execute multiple query and capture the output in a file on e2

Tried with :

aws athena start-query-execution --query-string "<select query>" > query_output.sql

But above statement is giving only key in the file query_output.sql but I want the output to be capture in a file, please help

주제

분석

태그

아마존 Athena

언어

English

AWS-User-Jame

질문됨 2년 전645회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

Hi,

If I understand correctly you would like to be able to save the result set,

the start-query-execution, will only return the query ID, you can use the query ID to check the status of a query (QUEUED,RUNNING, FAILED, SUCCEEDED) and retrieving the query result sets with different commands:

get-query-execution

get-query-results

hope this helps,

전문가

Fabrizio@AWS

답변함 2년 전

Athena - Execute multiple query and capture output in a file on e2

관련 콘텐츠