Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Hive is case-insensitive, both keywords and functions
You can use both double and single quotes for strings
use = rather than == for equality comparison
but it seems that == also works
use % rather …
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
比如在 LEFT JOIN 中过滤条件写在 ON 和 WHERE 的区别。
Table-value function 和 scalar-valued function 的区别.
char、varchar、nvarchar之间的区别(包括 …
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Avoid implicit data convertion! This might cause full table scan which hurts performance badly. For more discussions, please refer to 一条垃圾SQL，把 64 核 CPU 快 …
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
https://www.virtualbox.org/sdkref/interface_i_mouse.html
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
pyAudioAnalysis is a Python library covering a wide range of audio analysis tasks.
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
python-build-standalone is a better alternative to conda-pack on managing Python dependencies for PySpark. Please refer to Packaging Python Dependencies for PySpark Using python-build-standalone for tutorials on how to use python-build-standalone to …