QuestionQ160
Data Store ManagementA data engineer creates an AWS Glue Data Catalog table by using an AWS Glue crawler named Orders. The data engineer needs to add these new partitions:
s3://transactions/orders/order_date=2023-01-01s3://transactions/orders/order_date=2023-01-02
The data engineer must update the metadata to include the new partitions in the table without scanning every folder and file in the table location.
Which data definition language (DDL) statement should the data engineer use in Amazon Athena?
- A ALTER TABLE Orders ADD PARTITION(order_date=’2023-01-01’) LOCATION ‘s3://transactions/orders/order_date=2023-01-01’;ALTER TABLE Orders ADD PARTITION(order_date=’2023-01-02’) LOCATION ‘s3://transactions/orders/order_date=2023-01-02’;
- B MSCK REPAIR TABLE Orders;
- C REPAIR TABLE Orders;
- D ALTER TABLE Orders MODIFY PARTITION(order_date=’2023-01-01’) LOCATION ‘s3://transactions/orders/2023-01-01’;ALTER TABLE Orders MODIFY PARTITION(order_date=’2023-01-02’) LOCATION ‘s3://transactions/orders/2023-01-02’;
Community Discussion