Skip to content

Instantly share code, notes, and snippets.

View simongomez95's full-sized avatar

Simón Gómez simongomez95

  • Medellín, Colombia
View GitHub Profile
peliculas = LOAD '/datasets/otros/datapeliculas.csv' USING PigStorage(',')
as (usuario:int, pelicula:int, score:int, genero:chararray, fecha:datetime);
porusuario = GROUP peliculas BY usuario;
-- Número de películas vista por un usuario, valor promedio de calificación
avgscore = FOREACH porusuario GENERATE group AS usuario, AVG(peliculas.score) AS average, COUNT($1) as contador;
porfecha = GROUP peliculas BY fecha;
empresas = LOAD '/datasets/otros/dataempresas.csv' USING PigStorage(',')
as (empresa:chararray, valor:float, fecha:datetime);
agrupadas = GROUP empresas BY empresa;
maximo = FOREACH agrupadas {
sorted = ORDER empresas BY valor DESC;
top = LIMIT sorted 1;
GENERATE group, empresas.empresa, empresas.fecha;
}
empleados = LOAD '/datasets/otros/dataempleados.csv' USING PigStorage(',')
as (sector:int, id:int, salario:int, ano:int);
porempleado = GROUP empleados BY id;
empleadoindiv = DISTINCT porempleado;
sectores = FOREACH empleadoindiv GENERATE empleados.id, COUNT(empleados.sector);
DUMP sectores;
empleados = LOAD '/datasets/otros/dataempleados.csv' USING PigStorage(',')
as (sector:int, id:int, salario:int, ano:int);
porempleado = GROUP empleados BY id;
promedios = FOREACH porempleado GENERATE empleados.id, AVG(empleados.salario);
DUMP promedios;
empleados = LOAD '/datasets/otros/dataempleados.csv' USING PigStorage(',')
as (sector:int, id:int, salario:int, ano:int);
porsector = GROUP empleados BY sector;
promedios = FOREACH porsector GENERATE empleados.sector, AVG(empleados.salario);
DUMP promedios;

Keybase proof

I hereby claim:

  • I am simongomez95 on github.
  • I am simongomez95 (https://keybase.io/simongomez95) on keybase.
  • I have a public key whose fingerprint is 07A9 6A5F F427 6162 73B9 FD2C E417 7E03 5621 C9F2

To claim this, I am signing this object:

start:- sum,nl.
sum:- write('X= '),read(X),
write('Y= '),read(Y),
S is X+Y,
write('Sum is '),write(S).
____
in_mind([c,i,n,c,o]).
@simongomez95
simongomez95 / php_reverse_shell.php
Created March 31, 2016 02:02
Php reverse shell script from pentestmonkey.net
<?php
// php-reverse-shell - A Reverse Shell implementation in PHP
// Copyright (C) 2007 pentestmonkey@pentestmonkey.net
//
// This tool may be used for legal purposes only. Users take full responsibility
// for any actions performed using this tool. The author accepts no liability
// for damage caused by this tool. If these terms are not acceptable to you, then
// do not use this tool.
//
// In all other respects the GPL version 2 applies:
To untrack a single file that has already been added/initialized to your repository, i.e., stop tracking the file but not delete it from your system use: git rm --cached filename
To untrack every file that is now in your .gitignore:
First commit any outstanding code changes, and then, run this command:
git rm -r --cached .
This removes any changed files from the index(staging area), then just run:
package co;
import co.edu.eafit.dis.st027.p2015Dankcompiler.lexer.DankcompilerAntlrLexer;
import co.edu.eafit.dis.st027.p2015Dankcompiler.lexer.DankcompilerJFlexLexer;
import co.edu.eafit.dis.st027.p2015Dankcompiler.tokens.*;
import java.io.IOException;
import org.antlr.v4.runtime.ANTLRFileStream;
import org.antlr.v4.runtime.ANTLRInputStream;
import org.antlr.v4.runtime.Token;
import org.antlr.v4.runtime.*;