A copy of my local apache zeppelin instance notebooks
Apache Hive:
- Chicago City Crime Data Analysis
- Retail Data Analysis - Uses Apache Sqoop to import all tables into Apache Hive
Apache Pig:
MySQL:
LeetCode SQL Solutions:
- 614: Second Degree Follower
- 178: Rank Scores
- 176: Second Highest Salary
- 627: Swap Salary
- 180: Consecutive Numbers
- 585: Investments in 2016
- 610: Triangle Judgement
- 596: Classes More than 5 Students
- 175: Combine two tables
- 579: Find Cumulative Salary of an Employee
- 184: Department Highest Salary
- 183: Customers who never order
- 570: Managers with at least 5 Direct Reports
- 602: Friend Requests II
- 574: Winning Candidate
- 571: Find Median given a frequency of numbers
- 578: Get highest answer rate question
- 577: Employee Bonus
- 569: Median Employee Salary
- 615: Average Salary
- 580: Count student number in departments
- 603: Consecutive available seats
- 620: Not Boring Movies
- 584: Find Customer Referee
- 613: Shortest Distance in a Line
- 181: Employees Earning more than their Managers
- 619: Biggest single number
- 185: Department top 3 Salaries
- 197: Rising Temperature
- 597: Friend Requests I
- 618: Students report by Geography
- 586: Customer placing the Largest Number of Orders
- 182: Duplicate emails
- 612: Shortest distance in a plane
- 196: Delete duplicate emails
- 262: Trips and Users
- 601: Human Traffic of Stadium
- 608: Tree Node
- 177: Nth Highest Salary
- 607: Salesperson
- 626: Exchange Seats
- 595: Big Countries
Work in Progress:
- Yelp Data Preparation using Apache Spark and Apache Hive
- Real-time Web-log analysis using Apache Kafka and Apache Spark