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:
I hereby claim:
To claim this, I am signing this object:
{ | |
"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", |
Verifying my Blockstack ID is secured with the address 19AvsK3Zo1cmFZg4D1c4pDaavHRZKvPEWm https://explorer.blockstack.org/address/19AvsK3Zo1cmFZg4D1c4pDaavHRZKvPEWm |
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 -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 |
#!/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" |
/* | |
* 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 | |
* |
- (NSMutableURLRequest *)requestWithMethod:(NSString *)method path:(NSString *)path parameters:(NSDictionary *)parameters | |
{ | |
NSURL *url = [NSURL URLWithString:path relativeToURL:self.baseURL]; | |
OAConsumer *consumer = [[OAConsumer alloc] initWithKey:OAUTH_CONSUMER_KEY secret:OAUTH_CONSUMER_SECRET]; | |
OAHMAC_SHA1SignatureProvider *provider = [[OAHMAC_SHA1SignatureProvider alloc] init]; | |
OAMutableURLRequest *request = [[OAMutableURLRequest alloc] initWithURL:url consumer:consumer token:self.token realm:@"Bunch API" signatureProvider:provider]; | |
[request setHTTPMethod:method]; | |
[request setAllHTTPHeaderFields:self.defaultHeaders]; | |
if ([method isEqualToString:@"GET"] || [method isEqualToString:@"HEAD"]) { |
javascript:(function(){window.notifications={notifications_support:function(){return%20true;},notify:function(obj){if(obj.title%20!=window.notifications.prevmsg.title%20%26%26%20obj.description%20!=window.notifications.prevmsg.description){var%20not=window.webkitNotifications.createNotification('http://talkerapp.com/images/favicon.png',obj.title,obj.description);not.show();window.setTimeout(function(){not.cancel();},5000);}window.notifications.prevmsg=obj;},prevmsg:{}};})(); |
#!/bin/sh | |
OLD_DB=$1 | |
NEW_DB=$2 | |
TABLES=`echo "SHOW TABLES IN $1;" | mysql -NB` | |
IFS=" | |
" |