Create an external table while specifying the object storage path to LOCATION.
While creating the external table we need to specify the location outside the managed storage location wherein data is stored.
Below syntax is used to create external table assuming here cloud-based object storage as AWS S3.
CREATE TABLE table1
LOCATION 's3://<bucket_path>/<table_directory>
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
d046bc0
7 months agoAyush24
7 months, 2 weeks ago