SQREAM S3 테스트

테스트 환경

S3 환경

URI(us-east-1 S3) : s3://xxxxxxxxx/toCSV/

URI(ap-northeast-2 S3) : s3://xxxxxxxx/toCSV/

Access key : {S3ID}                     

Secret key : {S3PW}

SQREAM 환경

V100 : v2021.2.1.23_test

테스트 요약

현재 버전에선 Us-east-1 리전에 생성된 S3 버킷만 사용 가능함

S3에 접근을 위해 S3 URI, S3 Account(Access Key, Secret Key)이 필요로함

S3에 Copy From, Copy To, CREATE OR REPLACE FOREIGN TABLE 쿼리가 작동함을 확인함

테스트 결과

V100 -> S3버킷(us-east-1), Copy To 쿼리 테스트(성공)

$ COPY (SELECT * FROM case01) TO WRAPPER csv_fdw OPTIONS (LOCATION = 's3://xxxxxxxxx/toCSV/nba_export.csv', AWS_ID = '{S3ID}', AWS_SECRET = '{S3PW}');

S3버킷(us-east-1)  -> V100, Copy From 쿼리 테스트(성공)

$ COPY case02 FROM WRAPPER csv_fdw OPTIONS (LOCATION = 's3://xxxxxxxxx/toCSV/nba_export.csv', AWS_ID = '{S3ID}', AWS_SECRET = '{S3PW}');

S3버킷(us-east-1)  -> V100, CREATE OR REPLACE FOREIGN TABLE  쿼리 테스트(성공)

$ CREATE OR REPLACE FOREIGN TABLE f_case01 (text01 TEXT, int01 INT) WRAPPER csv_fdw OPTIONS (LOCATION = 's3://xxxxxxxxx/toCSV/nba_export.csv', AWS_ID = '{S3ID}', AWS_SECRET = '{S3PW}');

V100 -> S3버킷(ap-northeast-2), Copy To 쿼리 테스트(실패)

$  COPY (SELECT * FROM case01) TO WRAPPER csv_fdw OPTIONS (LOCATION = 's3://xxxxxxxx/toCSV/nba_export.csv', AWS_ID = '{S3ID}', AWS_SECRET = '{S3PW}');

S3버킷(ap-northeast-2)  -> V100, Copy From 쿼리 테스트(실패)

$ COPY case02 FROM WRAPPER csv_fdw OPTIONS (LOCATION = 's3://xxxxxxxx/toCSV/nba_export.csv', AWS_ID = '{S3ID}', AWS_SECRET = '{S3PW}');

S3버킷(ap-northeast-2)  -> V100, CREATE OR REPLACE FOREIGN TABLE  쿼리 테스트(실패)

$ CREATE OR REPLACE FOREIGN TABLE f_case02 (text01 TEXT, int01 INT) WRAPPER csv_fdw OPTIONS (LOCATION = 's3://xxxxxxxx/toCSV/nba_export.csv', AWS_ID = '{S3ID}', AWS_SECRET = '{S3PW}');