Skip to content

Instantly share code, notes, and snippets.

Avatar
💭
👨‍💻

Michael Mior michaelmior

💭
👨‍💻
View GitHub Profile
View resume.json
{
"basics": {
"name": "Michael Mior",
"email": "mmior@cs.rit.edu",
"phone": "(585) 475-5810",
"website": "https://michael.mior.ca",
"location": {
"address": "102 Lomb Memorial Drive",
"postalCode": "14623-5608",
View gist:da292dc3b9c9f105bc37e18265453871
Verifying my Blockstack ID is secured with the address 19AvsK3Zo1cmFZg4D1c4pDaavHRZKvPEWm https://explorer.blockstack.org/address/19AvsK3Zo1cmFZg4D1c4pDaavHRZKvPEWm
View calcite-rewrites.txt
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
@michaelmior
michaelmior / start-spark.sh
Created May 3, 2017
Spark installation on YARN
View start-spark.sh
#!/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"
View start-spark.sh
#!/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
View MaterializedViewJoinRule.java
/*
* 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
*
View keybase.md

Keybase proof

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 D833 5C62 4830 813F A8ED 6873 3AF1 2B9F 85C0 A026

To claim this, I am signing this object:

View gist:082cc479893e1efb5be5
Verifying I am +michaelmior on my passcard. https://onename.com/michaelmior
View Boxstarter
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