zenmyo

zenmyo / hive on spark

Created May 24, 2016 07:15

	- sudo ln -s /usr/lib/spark/lib/spark-assembly.jar /usr/lib/hive/lib/spark-assembly.jar
	- sudo -u hdfs hdfs dfs -mkdir /user/vagrant
	- sudo -u hdfs hdfs dfs -chown vagrant /user/vagrant

zenmyo / gist:260d0e388d5f06ed4a00

Created May 12, 2015 09:09

sqlmode

	mysql> select @@GLOBAL.sql_mode;
	+--------------------------------------------+
	\| @@GLOBAL.sql_mode \|
	+--------------------------------------------+
	\| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION \|
	+--------------------------------------------+
	1 row in set (0.00 sec)

	mysql> SET @@GLOBAL.sql_mode=''
	-> ;

zenmyo / gist:d848339562c468daaaea

Created November 17, 2014 04:17

git checkout by date

 git checkout `git log -1 --oneline --no-abbrev-commit --until=2014-11-01 |cut -d ' ' -f 1`

zenmyo / hadoop_kill_task

Created October 19, 2012 07:11

hadoop task kill one liner

for i in `seq -f %02g 1 99` ; do hadoop job -kill-task attempt_<job_id>_r_0000${i}_0; done