如何在emr集群上写入presto查询输出到s3 ?

Question

我想从EMR集群写入Presto查询输出到S3位置。我执行以下命令，但它不工作。我需要为此更改EMR集群上的任何配置吗?

INSERT INTO DIRECTORY 's3n://test-bucket/manoj/presto-query-output/' 
select logdate from hive.core.candidates_orc_hr  s WHERE logdate = '2022-05-12' AND loghour = '21'; 

Answer 1

请尝试以下方法:

创建SCHEMA test_hive。s3_write WITH (location = 's3a://parquet-test-bucket/');

创建test_hive.s3_write.my_table表WITH (format = 'PARQUET')从hive.core中选择logdate。WHERE logdate = '2022-05-12' AND loghour = '21';