160 List<TDBInfo> dbs = client.get_databases(session);
162 for (TDBInfo db : dbs) {
163 logger.info(
"db is " + db.toString());
167 List<String>
tables = client.get_tables(session);
169 for (String tab : tables) {
170 logger.info(
"Tables is " + tab);
174 logger.info(
"Version " + client.get_version());
177 TTableDetails table_details = client.get_table_details(session,
"flights");
178 for (TColumnType col : table_details.row_desc) {
179 logger.info(
"col name :" + col.col_name);
180 logger.info(
"\tcol encoding :" + col.col_type.encoding);
181 logger.info(
"\tcol is_array :" + col.col_type.is_array);
182 logger.info(
"\tcol nullable :" + col.col_type.nullable);
187 logger.info(
" -- before query -- ");
189 TQueryResult sql_execute = client.sql_execute(session,
190 "Select uniquecarrier,flightnum from flights LIMIT 3;",
199 logger.info(
" -- after query -- ");
201 logger.info(
"TQueryResult execution time is " + sql_execute.getExecution_time_ms());
202 logger.info(
"TQueryResult is " + sql_execute.toString());
203 logger.info(
"TQueryResult getFieldValue is "
204 + sql_execute.getFieldValue(TQueryResult._Fields.ROW_SET));
206 TRowSet row_set = sql_execute.getRow_set();
207 Object fieldValue = sql_execute.getFieldValue(TQueryResult._Fields.ROW_SET);
209 logger.info(
"fieldValue " + fieldValue);
211 logger.info(
"TRowSet is " + row_set.toString());
213 logger.info(
"Get rows size " + row_set.getRowsSize());
214 logger.info(
"Get col size " + row_set.getRowsSize());
216 List<TRow> rows = row_set.getRows();
218 for (TRow row : rows) {
219 List<TDatum> cols = row.getCols();
221 for (TDatum dat : cols) {
222 logger.info(
"ROW " +
count +
" " + dat.getFieldValue(TDatum._Fields.VAL));
228 List<TColumn> columns = row_set.getColumns();
230 logger.info(
"columns " + columns);
232 for (TColumn col : columns) {
233 TColumnData data = col.getData();
235 logger.info(
"COL " + count +
" " + data.toString());