Michael Mior michaelmior

I hereby claim:

I am michaelmior on github.
I am michaelmior (https://keybase.io/michaelmior) on keybase.
I have a public key whose fingerprint is EAC5 89C4 44F4 68FE 7E11 3D2D D8D7 2C13 CF2D 8DDB

To claim this, I am signing this object:

	{

	"basics": {
	"name": "Michael Mior",
	"email": "[email protected]",
	"phone": "(585) 475-5810",
	"website": "https://michael.mior.ca",
	"location": {
	"address": "102 Lomb Memorial Drive",
	"postalCode": "14623-5608",

	testReduceCompositeInSubQuery
	select * from emp where (empno, deptno) in ( select empno, deptno from ( select empno, deptno from emp group by empno, deptno)) or deptno < 40 + 60
	SELECT * FROM `CATALOG`.`SALES`.`EMP` WHERE (`EMPNO`, `DEPTNO`) IN (SELECT `EMPNO`, `DEPTNO` FROM `CATALOG`.`SALES`.`EMP` GROUP BY `EMPNO`, `DEPTNO`) OR `DEPTNO` < 100

	testReduceNestedCaseWhen
	select sal from emp where case when (sal = 1000) then (case when sal = 1000 then null else 1 end is null) else (case when sal = 2000 then null else 1 end is null) end is true
	SELECT `SAL` FROM `CATALOG`.`SALES`.`EMP` WHERE CASE WHEN `SAL` = 1000 THEN `SAL` = 1000 ELSE `SAL` = 2000 END

	testReduceOrCaseWhen
	select sal from emp where case when sal = 1000 then null else 1 end is null OR case when sal = 2000 then null else 1 end is null

	#!/bin/bash -ex

	SPARK_VERSION="2.1.0-bin-hadoop2.7"
	HADOOP_VERSION="2.7.3"
	SHORT_USER=$(echo $USER \| cut -d \\ -f2)

	function add_to_env {
	host=$1
	value=$2
	ssh $host "echo '$value' \| sudo tee -a /etc/environment > /dev/null"

	#!/bin/bash -e

	SPARK_VERSION="2.1.0-bin-hadoop2.7"
	HADOOP_VERSION="2.7.3"
	SHORT_USER=$(echo $USER \| cut -d \\ -f2)
	DATA_DIR=/var/tmp/$SHORT_USER/hdfs
	IO_BPS=$((50 * 1024 * 1024))

	function add_to_env {
	host=$1

	/*
	* Licensed to the Apache Software Foundation (ASF) under one or more
	* contributor license agreements. See the NOTICE file distributed with
	* this work for additional information regarding copyright ownership.
	* The ASF licenses this file to you under the Apache License, Version 2.0
	* (the "License"); you may not use this file except in compliance with
	* the License. You may obtain a copy of the License at
	*
	* http://www.apache.org/licenses/LICENSE-2.0
	*

	Set-WindowsExplorerOptions -EnableShowHiddenFilesFoldersDrives -EnableShowProtectedOSFiles -EnableShowFileExtensions -EnableShowFullPathInTitleBar
	Set-StartScreenOptions -EnableBootToDesktop
	Install-WindowsUpdate

	cinst 7zip.commandline
	cinst adobereader
	cinst adobeshockwaveplayer
	cinst android-sdk
	cinst AndroidStudio
	cinst binroot