Skip to content

Instantly share code, notes, and snippets.

/** Error looks like this
Exception (28):
epc1=0x402021ea epc2=0x00000000 epc3=0x00000000 excvaddr=0x000016d0 depc=0x00000000
ctx: cont
sp: 3fff0d10 end: 3fff0f60 offset: 01a0
>>>stack>>>
3fff0eb0: 0000005f 3ffefcd4 0000007e 402021c9
smbutil lookup HOSTNAME
@rexpie
rexpie / gist:fa96a9580192d4a11ec8ce443275bb34
Last active July 6, 2016 03:23
spark sql connect mysql
spark-shell --jars mysql-connector-java-5.1.39-bin.jar
//avg qty, max qty, frequency, total_price recurring product
val order_product = sqlContext.read.format("jdbc").option("url", "jdbc:mysql://localhost/dfrobot").option("driver", "com.mysql.jdbc.Driver").option("dbtable", "order_product").option("user", "root").load()
val order=sqlContext.read.format("jdbc").option("url", "jdbc:mysql://localhost/dfrobot").option("driver", "com.mysql.jdbc.Driver").option("dbtable", "`order`").option("user", "root").load()
val customer=sqlContext.read.format("jdbc").option("url", "jdbc:mysql://localhost/dfrobot").option("driver", "com.mysql.jdbc.Driver").option("dbtable", "customer").option("user", "root").load().select("customer_id","firstname","lastname","email","ip","customer_group_id")
val orderdd = order.filter($"customer_id" > 0).filter($"order_status_id" === 3 || $"order_status_id" === 5).join(order_product.filter($"quantity" > 0), order("order_id")===order_product("order_id")).groupBy(order("customer_id"))
val orde
@rexpie
rexpie / Scratch2 Extension Report
Last active August 29, 2015 14:26
Scratch2 Extension Report
> Written with [StackEdit](https://stackedit.io/).
过往项目总结
---------------------------------
> 原文档请参考DFRobotScratch Kit项目报告
@rexpie
rexpie / weeklyReport150731.md
Last active August 29, 2015 14:26
weeklyReport150731.md
chubby:memcached-1.4.21 chenjing$ sudo ./memcached -p 11211 -m 64 -u root -d
[root@iZ23rkkygsnZ conf]# iptables -A INPUT -i eth1 -p tcp --dport 80 -j ACCEPT
[root@iZ23rkkygsnZ conf]# iptables -A INPUT -i eth1 -p tcp --dport 8080 -j ACCEPT
[root@iZ23rkkygsnZ conf]# iptables -A PREROUTING -t nat -i eth1 -p tcp --dport 80 -j REDIRECT --to-port 8080
[root@iZ23rkkygsnZ conf]# service iptables save
iptables: Saving firewall rules to /etc/sysconfig/iptables:[ OK ]
[root@iZ23rkkygsnZ conf]# service iptables restart
iptables: Setting chains to policy ACCEPT: nat filter [ OK ]
iptables: Flushing firewall rules: [ OK ]
iptables: Unloading modules: [ OK ]
iptables: Applying firewall rules: [ OK ]
@rexpie
rexpie / crop hints
Created September 15, 2014 10:18
crop
self.keepingCropAspectRatio
self.cropView.cropAspectRatio = 3.0f / 5.0f;
http://www.raywenderlich.com/50317/beginning-auto-layout-tutorial-in-ios-7-part-1
http://www.raywenderlich.com/76200/basic-uiview-animation-swift-tutorial