Package org.apache.hadoop.chukwa.util

Examples of org.apache.hadoop.chukwa.util.DatabaseWriter.query()

118
119
120
121
122
123
124
125
126
127
128
  if (timestamp != null) {
      // get simple value
            try {
    String query = getSingleQuery(SystemMetricsHome.table,"timestamp",timestamp);
        ResultSet rs = dbw.query(query);
        if (rs.next()) {
        SystemMetrics obj = createSystemMetrics(rs);
        return obj;
    }
      } catch (Exception e) {
View Full Code Here
147
148
149
150
151
152
153
154
155
156
157
    Map<String, String> criteriaMap = new HashMap<String,String>();
    criteriaMap.put("timestamp",convertLongToDateString(Long.parseLong(timestamp)));
    criteriaMap.put("host",host);

    String query = getCriteriaQuery(SystemMetricsHome.table,criteriaMap);
        ResultSet rs = dbw.query(query);
        if (rs.next()) {
        SystemMetrics obj = createSystemMetrics(rs);
        return obj;
    }
      } catch (Exception e) {
View Full Code Here
172
173
174
175
176
177
178
179
180
181
182
  Collection<SystemMetrics> collection = new Vector<SystemMetrics>();

  try {
      String query = getTimeBetweenQuery(SystemMetricsHome.table,starttime,endtime);     
      ResultSet rs = dbw.query(query);
      while (rs.next()) {
    SystemMetrics obj = createSystemMetrics(rs);
    collection.add(obj);
      }
  } catch (Exception e) {
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
  if (timestamp != null) {
      // get simple value
            try {
    String query = getSingleQuery(DfsFsNameSystemHome.table,"timestamp",timestamp);
        ResultSet rs = dbw.query(query);
        if (rs.next()) {
        DfsFsNameSystem obj = createDfsFsNameSystem(rs);
        return obj;
    }
      } catch (Exception e) {
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
    Map<String, String> criteriaMap = new HashMap<String,String>();
    criteriaMap.put("timestamp",convertLongToDateString(Long.parseLong(timestamp)));
    criteriaMap.put("host",host);

    String query = getCriteriaQuery(DfsFsNameSystemHome.table,criteriaMap);
        ResultSet rs = dbw.query(query);
        if (rs.next()) {
        DfsFsNameSystem obj = createDfsFsNameSystem(rs);
        return obj;
    }
      } catch (Exception e) {
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
  Collection<DfsFsNameSystem> collection = new Vector<DfsFsNameSystem>();

  try {
      String query = getTimeBetweenQuery(DfsFsNameSystemHome.table,starttime,endtime);     
      ResultSet rs = dbw.query(query);
      while (rs.next()) {
    DfsFsNameSystem obj = createDfsFsNameSystem(rs);
    collection.add(obj);
      }
  } catch (Exception e) {
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
  if (task_id != null) {
      // get simple value
            try {
    String query = getSingleQuery(MrTaskHome.table,"task_id",task_id);
        ResultSet rs = dbw.query(query);
        if (rs.next()) {
        MrTask obj = createMrTask(rs);
        return obj;
    }
      } catch (Exception e) {
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
  if (job_id != null) {
      // get simple value
            try {
    String query = getSingleQuery(MrJobHome.table,"job_id",job_id);
        ResultSet rs = dbw.query(query);
        if (rs.next()) {
        MrJob obj = createMrJob(rs);
        return obj;
    }
      } catch (Exception e) {
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
 
  if (job_id != null) {
      // get simple value
            try {
    String query = getSingleQuery(MrJobConfHome.table,"job_id",job_id);
        ResultSet rs = dbw.query(query);
        if (rs.next()) {
        MrJobConf obj = createMrJobConf(rs);
        return obj;
    }
      } catch (Exception e) {
View Full Code Here
230
231
232
233
234
235
236
237
238
239
240
      fail(e.toString());
    }
    DatabaseWriter db = null;
    try {
      db = new DatabaseWriter(cluster);
      ResultSet rs = db.query("show tables");
      ArrayList<String> list = new ArrayList<String>();
      while(rs.next()) {
        String table = rs.getString(1);
        list.add(table);
      }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.