Package org.apache.hadoop.chukwa.util

Examples of org.apache.hadoop.chukwa.util.DatabaseWriter

347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
      e.printStackTrace();
      fail("Metric Data Loader Error.");
    }   
   
    // Verify Data
    DatabaseWriter db = null;
    try {
      db = new DatabaseWriter(cluster);
      Macro mp = new Macro(current,current, "select * from [system_metrics]");
      String query = mp.toString();
      ResultSet rs = db.query(query);
      ResultSetMetaData rmeta = rs.getMetaData();
      int size = rmeta.getColumnCount();
      while(rs.next()) {
        for(int i=1;i<=size;i++) {
          int columnType = rmeta.getColumnType(i);
          if(columnType==java.sql.Types.BIGINT ||
             columnType==java.sql.Types.INTEGER) {
            long testValue = rs.getLong(i);
            assertTrue(testValue<1000000000L);
          } else if(columnType==java.sql.Types.FLOAT ||
              columnType==java.sql.Types.DOUBLE) {
            double testValue = rs.getDouble(i);
            assertTrue(testValue<1000000000L);
          }
        }
      }
    } catch(Throwable ex) {
      fail("Data verification failed.");
    } finally {
      if(db!=null) {
        db.close();
      }
    }     
   
  }
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
  return null;
    }

    public static Collection<ClientTrace> findBetween(String starttime, String endtime) {
  String cluster = getCluster();
  DatabaseWriter dbw = new DatabaseWriter(cluster);

  Collection<ClientTrace> collection = new Vector<ClientTrace>();

  try {
      String query = getTimeBetweenQuery(ClientTraceHome.table,starttime,endtime);     
      ResultSet rs = dbw.query(query);
      while (rs.next()) {
    ClientTrace obj = createClientTrace(rs);
    collection.add(obj);
      }
  } catch (Exception e) {
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
    /*
     * find by timestamp
     */
    public static DfsDataNode find(String timestamp) {
  String cluster = getCluster();
  DatabaseWriter dbw = new DatabaseWriter(cluster);

  if (timestamp != null) {
      // get simple value
            try {
    String query = getSingleQuery(DfsDataNodeHome.table,"timestamp",timestamp);
        ResultSet rs = dbw.query(query);
        if (rs.next()) {
        DfsDataNode obj = createDfsDataNode(rs);
        return obj;
    }
      } catch (Exception e) {
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
    /*
     * find by key
     */
    public static DfsDataNode find(String timestamp, String host) {
  String cluster = getCluster();
  DatabaseWriter dbw = new DatabaseWriter(cluster);

  if (timestamp != null) {
      // get simple value
            try {
    Map<String, String> criteriaMap = new HashMap<String,String>();
    criteriaMap.put("timestamp",convertLongToDateString(Long.parseLong(timestamp)));
    criteriaMap.put("host",host);

    String query = getCriteriaQuery(DfsDataNodeHome.table,criteriaMap);
        ResultSet rs = dbw.query(query);
        if (rs.next()) {
        DfsDataNode obj = createDfsDataNode(rs);
        return obj;
    }
      } catch (Exception e) {
View Full Code Here
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
    /*
     * find within the start time and end time
     */
    public static Collection<DfsDataNode> findBetween(String starttime, String endtime) {
  String cluster = getCluster();
  DatabaseWriter dbw = new DatabaseWriter(cluster);

  Collection<DfsDataNode> collection = new Vector<DfsDataNode>();

  try {
      String query = getTimeBetweenQuery(DfsDataNodeHome.table,starttime,endtime);     
      ResultSet rs = dbw.query(query);
      while (rs.next()) {
    DfsDataNode obj = createDfsDataNode(rs);
    collection.add(obj);
      }
  } catch (Exception e) {
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
    /*
     * find by timestamp
     */
    public static HadoopJvm find(String timestamp) {
  String cluster = getCluster();
  DatabaseWriter dbw = new DatabaseWriter(cluster);

  if (timestamp != null) {
      // get simple value
            try {
    String query = getSingleQuery(HadoopJvmHome.table,"timestamp",timestamp);
        ResultSet rs = dbw.query(query);
        if (rs.next()) {
        HadoopJvm obj = createHadoopJvm(rs);
        return obj;
    }
      } catch (Exception e) {
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
    /*
     * find by key
     */
    public static HadoopJvm find(String timestamp, String host, String process_name) {
  String cluster = getCluster();
  DatabaseWriter dbw = new DatabaseWriter(cluster);

  if (timestamp != null) {
      // get simple value
            try {
    Map<String, String> criteriaMap = new HashMap<String,String>();
    criteriaMap.put("timestamp",convertLongToDateString(Long.parseLong(timestamp)));
    criteriaMap.put("host",host);
    criteriaMap.put("process_name",process_name);

    String query = getCriteriaQuery(HadoopJvmHome.table,criteriaMap);
        ResultSet rs = dbw.query(query);
        if (rs.next()) {
        HadoopJvm obj = createHadoopJvm(rs);
        return obj;
    }
      } catch (Exception e) {
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
    /*
     * find within the start time and end time
     */
    public static Collection<HadoopJvm> findBetween(String starttime, String endtime) {
  String cluster = getCluster();
  DatabaseWriter dbw = new DatabaseWriter(cluster);

  Collection<HadoopJvm> collection = new Vector<HadoopJvm>();

  try {
      String query = getTimeBetweenQuery(HadoopJvmHome.table,starttime,endtime);     
      ResultSet rs = dbw.query(query);
      while (rs.next()) {
    HadoopJvm obj = createHadoopJvm(rs);
    collection.add(obj);
      }
  } catch (Exception e) {
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
    /*
     * find by timestamp
     */
    public static DfsNameNode find(String timestamp) {
  String cluster = getCluster();
  DatabaseWriter dbw = new DatabaseWriter(cluster);

  if (timestamp != null) {
      // get simple value
            try {
    String query = getSingleQuery(DfsNameNodeHome.table,"timestamp",timestamp);
        ResultSet rs = dbw.query(query);
        if (rs.next()) {
        DfsNameNode obj = createDfsNameNode(rs);
        return obj;
    }
      } catch (Exception e) {
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
    /*
     * find by key
     */
    public static DfsNameNode find(String timestamp, String host) {
  String cluster = getCluster();
  DatabaseWriter dbw = new DatabaseWriter(cluster);

  if (timestamp != null) {
      // get simple value
            try {
    Map<String, String> criteriaMap = new HashMap<String,String>();
    criteriaMap.put("timestamp",convertLongToDateString(Long.parseLong(timestamp)));
    criteriaMap.put("host",host);

    String query = getCriteriaQuery(DfsNameNodeHome.table,criteriaMap);
        ResultSet rs = dbw.query(query);
        if (rs.next()) {
        DfsNameNode obj = createDfsNameNode(rs);
        return obj;
    }
      } catch (Exception e) {
View Full Code Here
TOP

Related Classes of org.apache.hadoop.chukwa.util.DatabaseWriter

  • org.apache.hadoop.chukwa.analysis.salsa.visualization.Heatmap
  • org.apache.hadoop.chukwa.analysis.salsa.visualization.Swimlanes
  • org.apache.hadoop.chukwa.database.Aggregator
  • org.apache.hadoop.chukwa.database.Consolidator
  • org.apache.hadoop.chukwa.database.DatabaseSetup
  • org.apache.hadoop.chukwa.database.DataExpiration
  • org.apache.hadoop.chukwa.database.Macro
  • org.apache.hadoop.chukwa.database.TableCreator
  • org.apache.hadoop.chukwa.database.TestDatabaseAggregator
  • org.apache.hadoop.chukwa.database.TestDatabaseDataExpiration
    • Copyright © 2018 www.massapicom. 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.