michaelmior

{

  "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",

michaelmior

Verifying my Blockstack ID is secured with the address 19AvsK3Zo1cmFZg4D1c4pDaavHRZKvPEWm https://explorer.blockstack.org/address/19AvsK3Zo1cmFZg4D1c4pDaavHRZKvPEWm

michaelmior

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

#!/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"

michaelmior

#!/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

michaelmior

/*
 * 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
 *

michaelmior

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 EAC5 89C4 44F4 68FE 7E11 3D2D D8D7 2C13 CF2D 8DDB

To claim this, I am signing this object:

michaelmior

Verifying I am +michaelmior on my passcard. https://onename.com/michaelmior

michaelmior

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

michaelmior

• pdf.aminer.org/000/643/318/control_of_an_extensible_query_optimizer_a_planning_based_approach.pdf
• www.dtic.mil/dtic/tr/fulltext/u2/a428473.pdf
• IEEE Xplore Full-Text PDF:
• NoSQL query processing - Google Scholar
• IEEE Xplore Abstract - Scalable Join Queries in Cloud Data Stores
• IEEE Xplore Abstract - A comparison between several NoSQL databases with comments and notes
• JoCCASA | Abstract | Data management in cloud environments: NoSQL and NewSQL data stores
• [Performance tradeoffs for client-s