Skip to content

Latest commit

 

History

History
40 lines (24 loc) · 978 Bytes

README.md

File metadata and controls

40 lines (24 loc) · 978 Bytes

Problems 5 -> CITY names starting with vowels

Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates. The STATION table is described as follows:

Problem Difficulty Level : Easy

Data Structure

  • ID
  • City
  • State
  • Lattitude
  • Longitude

image

Data for station table

In CSV Format

Solving using PySpark

In Spark we will solve this problem using two ways

  1. Using PySpark Functions
  2. Using Spark SQL

Use below notebook for solution

Problem Solution First Part

Solving using PostgreSQL

In Postgre SQL We will load data from CSV using PostgreSQL Import functionality. And then we will solve this problem.

Output Query

Problem Solution

Please also follow below blog for understanding this problem