Question: CREATE table weatherdata.late 2 0 th WITH ( format = 'PARQUET', external _ location = ' s 3 : / / / lab 6 '

CREATE table weatherdata.late20th
WITH (
format='PARQUET', external_location='s3:///lab6'
) AS SELECT date, type, observation FROM by_year
WHERE date/10000 between 1950 and 2015;
The output of this query when run using Athena
Group of answer choices
Error
A table getting created with number of records lesser than that of by_year
A table getting created with 0 records
A table getting created with number of records more than that of by_year

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!