Skip to content

Instantly share code, notes, and snippets.

View galanteh's full-sized avatar

Hernan Galante galanteh

  • Cloudera
  • Mexico City
View GitHub Profile
@galanteh
galanteh / gist:861d47ac9aafe45389c5f72d568f34a4
Created July 27, 2018 14:55
Get the raspberry temperature
pi@raspberrypi:~ $ /opt/vc/bin/vcgencmd measure_temp
temp=56.9'C
docker pull ubuntu # downloads image from Docker repository
docker ps -a # shows all available containers
docker ps -as # shows all containers with the actual size of the rw-layer
docker exec -ti ceb1be03097d /bin/bash # run bash on running container
docker commit ceb1be03097d /: # create image based on container
@galanteh
galanteh / sh
Created July 12, 2019 14:48
Installing Python3.6 in Centos7
#! /bin/bash
sudo yum install -y epel-release
sudo yum install -y python36
sudo yum install -y python36-devel
sudo yum install -y python36-pip
sudo yum install -y python36-setuptools
sudo easy_install-3.6 pip
sudo python3.6 -m pip install --upgrade pip setuptools wheel
@galanteh
galanteh / install.sh
Last active July 12, 2019 14:57
Installing CSV Faker on a CFM (Cloudera NiFi) node
#! /bin/bash
sudo yum install -y epel-release
sudo yum install -y python36
sudo yum install -y python36-devel
sudo yum install -y python36-pip
sudo yum install -y python36-setuptools
sudo easy_install-3.6 pip
sudo python3.6 -m pip install --upgrade pip setuptools wheel
sudo python3 -m pip install faker
sudo python3 -m pip install ipaddress
@galanteh
galanteh / temp_table_logs.sql
Last active July 13, 2019 23:43
Get the temp table logs from Vertica for Navigator Optimizer
/* Temp table logs */
SELECT anchor_table_schema || '.' || anchor_table_name as TABLE_NAME,
projection_column_count as AVG_ROW_LEN,
SUM(row_count) as NUM_ROWS,
CASE
WHEN row_count<=99999 THEN 'x-small'
WHEN row_count<=999999 THEN 'small'
WHEN row_count<=99999999 THEN 'medium'
WHEN row_count<=999999999 THEN 'large'
WHEN row_count>999999999 THEN 'x-large'
@galanteh
galanteh / compile_apache_livy.txt
Created September 9, 2019 22:31
Compilation of Cloudera Apache Livy 0.3.0 on CentOS 7.5
# Choose an Edge node. Login as root.
# This recipe works to compile Apache Livy 0.3.0 from Cloudera repo.
yum -y install maven
cd /opt
wget https://github.com/cloudera/livy/archive/v0.3.0.zip
unzip v0.3.0.zip
cd livy-0.3.0
yum -y install python-pip
python -m pip install --upgrade pip setuptools wheel
@galanteh
galanteh / install_sqlserver_2017_ubuntu.txt
Last active October 22, 2019 15:29
Install Script SQLServer 2017 SP1 on Ubuntu 16.04
wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)"
sudo apt-get update
sudo apt-get install -y mssql-server
sudo /opt/mssql/bin/mssql-conf setup
sudo systemctl enable mssql-server
sudo systemctl start mssql-server
@galanteh
galanteh / install.sh
Created November 5, 2019 18:27
Installation of Graphite App over CentOS 7.5 on 80 port
# Install EPEL Repo
sudo yum install -y epel-release
# Update the OS
sudo yum -y update
# Install HTOP to monitor processes
sudo yum install -y htop
# Install Graphite and Carbon
sudo yum install -y graphite-web python-carbon
# Configuration - Change TimeZone and Security
@galanteh
galanteh / install.sh
Created November 5, 2019 20:43
Install Grafana over CentOS7.5 on Port 80
sudo bash -c "cat << EOF > /etc/yum.repos.d/grafana.repo
[grafana]
name=grafana
baseurl=https://packages.grafana.com/oss/rpm
repo_gpgcheck=1
enabled=1
gpgcheck=1
gpgkey=https://packages.grafana.com/gpg.key
sslverify=1
sslcacert=/etc/pki/tls/certs/ca-bundle.crt
@galanteh
galanteh / install_ora_19c.sh
Last active February 3, 2024 12:34
Installing Oracle 19c on Centos 7.7
#!/bin/bash
# ORACLE 19c Install Script by Hernan Galante <hernan_galante@hotmail>
# ------------------------------------------------------------------
# First, go to the Oracle Downloads website and try to download your RPM. You will ACCEPT the Terms.
# This will generate a cookie than you can export from your browser with any add-on for Chrome or Firefox.
# Copy this cookie.txt to your server. This script assumes that you have this file.
#
# TROUBLESHOOTING
# ------------------------------------------------------------------
# If you receive this error message [FATAL] [DBT-06103] The port (1,521) is already in use.