queries and sqoop cmds corresponding to memex_small:socal