morellana88

# adduser username --disabled-password
# usermod -aG sudo username
$ sudo su username
$ ssh-keygen

# Sudo without password
$ sudo visudo

# Add this to the end of the file 
username     ALL=(ALL) NOPASSWD:ALL

morellana88

set @dag_id = 'my_dag_id';

delete from xcom where dag_id = @dag_id;
delete from task_instance where dag_id = @dag_id;
delete from task_fail where dag_id = @dag_id;
delete from sla_miss where dag_id = @dag_id;
delete from log where dag_id = @dag_id;
delete from job where dag_id = @dag_id;
delete from dag_run where dag_id = @dag_id;
delete from dag where dag_id = @dag_id;

morellana88

package prueba_spark_marco_orellana


import org.apache.spark.sql.SparkSession
import org.apache.spark.sql.functions._
import org.apache.spark.sql.expressions.Window
import java.util.Calendar

object PruebaSpark {
def main(args: Array[String]){

morellana88

bq query \
--format=none 
--allow_large_results 
--replace 
--noflatten_results 
--use_legacy_sql=false 
--destination_table tie_rol.rol_ml_dataset$20170814 
--parameter="date_partition::2017-08-14" 
< somequery.sql

morellana88

[program:realtime-daemon]
command=/usr/local/bin/mono RealTimeDaemon.exe
process_name=%(program_name)s  ; process_name expr (default %(program_name)s)
numprocs=1
directory=/home/ec2-user/BeyondGames.Data/src/AnalyticsDashboard/RealTimeDaemon/bin/Debug
autostart=true
autorestart=true
stdout_logfile=/home/ec2-user/BeyondGames.Data/src/AnalyticsDashboard/RealTimeDaemon/bin/Debug/stdout_logfile.log
stderr_logfile=/home/ec2-user/BeyondGames.Data/src/AnalyticsDashboard/RealTimeDaemon/bin/Debug/stderr_logfile.log
stdout_logfile_backups=5

morellana88

[program:analytics-dashboard]
command=/usr/local/bin/xsp4 --port 8080 --root /home/ec2-user/BeyondGames.Data/src/AnalyticsDashboard/AnalyticsDashboard/
process_name=%(program_name)s
directory=/home/ec2-user/BeyondGames.Data/src/AnalyticsDashboard/AnalyticsDashboard/
autostart=true
autorestart=true
priority=100
stdout_logfile=/home/ec2-user/BeyondGames.Data/src/AnalyticsDashboard/AnalyticsDashboard/stdout_logfile.log
stderr_logfile=/home/ec2-user/BeyondGames.Data/src/AnalyticsDashboard/AnalyticsDashboard/stderr_logfile.log
stdout_logfile_backups=5

morellana88

namespace test

open System
open System.Data
open FsSql
open Npgsql

module test = 

    let connectionString = "Host=127.0.0.1;Port=5432;Database=analytics_dashboard;Username=analytics_dashboard;Password=postgresp44s"

morellana88

morellana88

let firstSelect (data: string list) =
    selectAttr[
        attr.id "first-combo"
        attr.``class`` "form-control"
        on.change(fun _ e ->
            e.PreventDefault()
            let selectedOption = JQuery.Of("#first-combo").Val() |> string
            updateSecondSelect selectedOption "#second-combo"
        )
    ](