CREATE DATABASE skills_data_db;

CREATE EXTERNAL TABLE IF NOT EXISTS skills_data_db.user_skills ( id STRING, name STRING, age INT, city STRING
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS TEXTFILE
LOCATION 's3://test-hyomin/Data/'

• 설명

SELECT * FROM user_skills
WHERE age >= 25;

SELECT * FROM user_skills
WHERE city = 'Seoul';