# gp-magic-query

**Repository Path**: mirrors_greenplum-db/gp-magic-query

## Basic Information

- **Project Name**: gp-magic-query
- **Description**: Demo and training of Greenplum multi-modal analytics
- **Primary Language**: Unknown
- **License**: MIT
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-09-24
- **Last Updated**: 2025-10-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

This is a demo of advanced analytics queries that can be run using Pivotal Greenplum

# What is the desired outcome?
Teach advanced analytics techniques in one single data set

# Motivation
Greenplum is a multimodal database that can be used for advanced analytics such as Text, Geospatial, Graph and Time Series analytics.  The unique Greenplum platform can combine all of these types of analytical queries on a single data set in order to gain insights on the data.  In this session we will use a single real world data set and show how to start with basic SQL queries, python user defined functions, and then advance to text search, text analytics, geospatial analytics, graph analytics, time series analysis and machine learning with Python.  All of these queries are done in place on a single data set in a single database.  Each discipline of analytics will be covered from basic principles with simple code examples and output.  Users can reproduce the data set and the queries after the session to practice on their own in Greenplum

# Course Slides
Google slides for the course are found [here](https://bit.ly/GPMAGICQUERY)

# Course Flow
Follow the steps below to go through the course:

1. [Deploy Greenplum Env](https://github.com/greenplum-db/gp-magic-query/blob/master/deploy.md)
1. [Load Twitter Data](https://github.com/greenplum-db/gp-magic-query/blob/master/load-data-framework)
1. [Learn to Connect to GPDB with a Python Client](https://github.com/greenplum-db/gp-magic-query/tree/master/pyclient)
1. [Write Server Side Python User Defined Functions](https://github.com/greenplum-db/gp-magic-query/tree/master/pyserver)
1. [Text Search](https://github.com/greenplum-db/gp-magic-query/tree/master/text)
1. [Time Series](https://github.com/greenplum-db/gp-magic-query/tree/master/time_series)
1. [Geospatial](https://github.com/greenplum-db/gp-magic-query/tree/master/geo)
1. [Graph](https://github.com/greenplum-db/gp-magic-query/tree/master/graph)
1. [Putting it all Together](https://github.com/greenplum-db/gp-magic-query/tree/master/putting-it-together)