Tag Archives: sql

mysql tricks: do instant table swap to mitigate mysql deadlock error.

Posted on May 19, 2017 by mx

mysql tricks: do instant table swap to mitigate mysql deadlock error. Continue reading →

Posted in etl, relational databases, Uncategorized | Tagged , , , , | Leave a comment

Slide Share’s full of useful knowledge

Posted on February 20, 2017 by mx

Best practices for PySpark programming Programming in Spark using PySpark from Mostafa Elzoghbi History of SQL and all the advanced features over the last 30 years among big vendors. Modern SQL in Open Source and Commercial Databases from Markus Winand

Posted in spark, Uncategorized | Tagged , , , | Leave a comment

Amazon Redshift’s Unsupported Features of PostGres

Posted on November 14, 2016 by mx

Redshift is based off branch of PostGreSQL 8.0.2 [ PostgreSQL 8.0.2 was released in 2005] here’s all the unsupported fancy PostGres Stuff: taken directly from amazon’s manual. The bigs ones are: No Store Procedures, No Constraints enforcement, No triggers and no … Continue reading →

Posted in data wrangling, mpp databases | Tagged , , , | Leave a comment

basic database table creation and load from csv using mysql and postgres

Posted on September 22, 2016 by mx

Basic database table creation with MySql and PostGreSQL. The starting point to most data applications is getting the data feeds and populating the tables. here’s an example of the process I’m loading a stock_history table from yahoo finance api source. … Continue reading →

Posted in data wrangling, relational databases | Tagged , , , , | Leave a comment

SQL tip: To get first 10 Rows from a Table and profile the columns

Posted on August 25, 2016 by mx

For people working with database tables: Most will want to check out the columns in the table and do a quick scan to get 10 rows to sample data in the table. Here’s the SQL syntax for doing that with … Continue reading →

Posted in data wrangling | Tagged , , | Leave a comment