System.out.println("Look deep into the JSON data for all records of VoltDB Forum logins who have downloaded version v3.0 and have specified a client language of Java. ");
SQL = "SELECT username, json_data FROM user_session_table WHERE field(field(json_data, 'props'), 'download_version')='v3.0' and field(field(json_data, 'props'), 'client_language')='Java' ORDER BY username LIMIT 10";
resp = client.callProcedure("@AdHoc", SQL);
System.out.println("SQL query: " + SQL);
System.out.println();
<BUG>printResults(resp.getResults()[0]);
System.out.println();</BUG>
System.out.println("User pattern matching (SQL LIKE) to look for all records of VoltDB Forum logins who have downloaded version v2.x. ");
SQL = "SELECT username, json_data FROM user_session_table WHERE field(field(json_data, 'props'), 'download_version') LIKE 'v2%' ORDER BY username LIMIT 10";
resp = client.callProcedure("@AdHoc", SQL);

System.out.println("Look deep into the JSON data for all records of VoltDB Forum logins who have downloaded version v3.0 and have specified a client language of Java. ");
SQL = "SELECT username, json_data FROM user_session_table WHERE field(field(json_data, 'props'), 'download_version')='v3.0' and field(field(json_data, 'props'), 'client_language')='Java' ORDER BY username LIMIT 10";
resp = client.callProcedure("@AdHoc", SQL);
System.out.println("SQL query: " + SQL);
System.out.println();
System.out.println(resp.getResults()[0].toFormattedString());
System.out.println();
System.out.println("User pattern matching (SQL LIKE) to look for all records of VoltDB Forum logins who have downloaded version v2.x. ");
SQL = "SELECT username, json_data FROM user_session_table WHERE field(field(json_data, 'props'), 'download_version') LIKE 'v2%' ORDER BY username LIMIT 10";
resp = client.callProcedure("@AdHoc", SQL);
