- get the column count
- create a new table with encodings you want to test
- insert the same column to all the column in new table
- Query the STV_BLOCKLIST system table
- encoding with lowest storage block count is the best encoding.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
* get current sort and dist keys | |
* Materialize a single column to check distribution | |
* Identify the table OID | |
* get skewed data stats |
style | use case |
---|---|
key | same value same slice, for joins |
all | dimension small table for frequent joins, data is copied to all nodes first slice |
even | unknown cases |
- Set DISTKEY to the column most used in a JOIN
- Set SORTKEY to the column(s) most used in a WHERE
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Redshift usefull queries |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import requests | |
import json | |
import time | |
import csv | |
import pandas as pd | |
# step 1: get all followers html content manually from insta page. in one line keep only one username (without quotes and comma.) | |
def get_usernames(): |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
A pottery teacher split her class into two halves. | |
To the first half she said, “You will spend the semester studying pottery, planning, designing, and | |
creating your perfect pot. At the end | |
of the semester, there will be a competition to see whose pot is the best”. | |
To the other half she said, “You will spend your semester making lots of pots. Your grade will be | |
based on the number of completed pots you | |
finish. At the end of the semester, you’ll also have the opportunity to enter your best pot into a | |
competition.” |
sudo bash ./entermedia-docker.sh alchemy-dam 100
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
module.exports.objectLeveller = (obj, outputObj, outputPath) => { | |
var outputAccObj = outputObj || {}; | |
var outputAccPath = outputPath || []; | |
return Object.getOwnPropertyNames(obj).reduce(function (outputAccObj, key) { | |
outputAccPath.push(key); | |
if (typeof obj[key] === 'object' && !!obj[key]) { | |
objectLeveller(obj[key], outputAccObj, outputAccPath); | |
} else { | |
outputAccObj[outputAccPath.join('_')] = obj[key]; |
-
http://archive.apache.org/dist/zeppelin/zeppelin-0.7.3/zeppelin-0.7.3-bin-all.tgz
-
https://www.oracle.com/technetwork/java/javaee/downloads/jdk8-downloads-2133151.html
-
export JAVA_HOME=`/usr/libexec/java_home -v 1.8`
-
bin/zeppelin-daemon.sh start
NewerOlder