Ben Chuanlong Du's Blog

It is never too late to learn.

Tips on AnBox

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

  1. AnBox CANNOT be run on macOS.

  2. There was a limited support of ARM-only app on x86-based Linux OS. However, Android 11+ images are capable of running ARM apps on x86-based machines …

Copy Pictures from an Android Phone to a Computer

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement! Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

You have to have a SSH server installed on the Android phone …

Numpy Arrays in Python

Tips and Traps

  1. The Pythonic way of checking whether a collection (string, list, set, dict, etc.) coll is non-empty is to use if coll. However, do NOT use if arr to check whether a numpy array is non-empty or not. Instead, you shoule use arr.size >0 to check whether a numpy array is non-empty or not.

Hive SQL

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

  1. Hive is case-insensitive, both keywords and functions

  2. You can use both double and single quotes for strings

  3. use = rather than == for equality comparison but it seems that == also works

  4. use % rather …

Questions on SQL

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

  1. 比如在 LEFT JOIN 中过滤条件写在 ON 和 WHERE 的区别。

  2. Table-value function 和 scalar-valued function 的区别.

  3. char、varchar、nvarchar之间的区别(包括 …