161 List<TDBInfo> dbs = client.get_databases(session);
163 for (TDBInfo db : dbs) {
164 logger.info(
"db is " + db.toString());
168 List<String>
tables = client.get_tables(session);
170 for (String tab : tables) {
171 logger.info(
"Tables is " + tab);
175 logger.info(
"Version " + client.get_version());
178 TTableDetails table_details = client.get_table_details(session,
"flights");
179 for (TColumnType col : table_details.row_desc) {
180 logger.info(
"col name :" + col.col_name);
181 logger.info(
"\tcol encoding :" + col.col_type.encoding);
182 logger.info(
"\tcol is_array :" + col.col_type.is_array);
183 logger.info(
"\tcol nullable :" + col.col_type.nullable);
188 logger.info(
" -- before query -- ");
190 TQueryResult sql_execute = client.sql_execute(session,
191 "Select uniquecarrier,flightnum from flights LIMIT 3;",
200 logger.info(
" -- after query -- ");
202 logger.info(
"TQueryResult execution time is " + sql_execute.getExecution_time_ms());
203 logger.info(
"TQueryResult is " + sql_execute.toString());
204 logger.info(
"TQueryResult getFieldValue is "
205 + sql_execute.getFieldValue(TQueryResult._Fields.ROW_SET));
207 TRowSet row_set = sql_execute.getRow_set();
208 Object fieldValue = sql_execute.getFieldValue(TQueryResult._Fields.ROW_SET);
210 logger.info(
"fieldValue " + fieldValue);
212 logger.info(
"TRowSet is " + row_set.toString());
214 logger.info(
"Get rows size " + row_set.getRowsSize());
215 logger.info(
"Get col size " + row_set.getRowsSize());
217 List<TRow> rows = row_set.getRows();
219 for (TRow row : rows) {
220 List<TDatum> cols = row.getCols();
222 for (TDatum dat : cols) {
223 logger.info(
"ROW " + count +
" " + dat.getFieldValue(TDatum._Fields.VAL));
229 List<TColumn> columns = row_set.getColumns();
231 logger.info(
"columns " + columns);
233 for (TColumn col : columns) {
234 TColumnData data = col.getData();
236 logger.info(
"COL " + count +
" " + data.toString());