package step1;

import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.hbase.Cell;
import org.apache.hadoop.hbase.CellUtil;
import org.apache.hadoop.hbase.TableName;
import org.apache.hadoop.hbase.client.*;
import org.apache.hadoop.hbase.util.Bytes;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class Task {


    /**
     * 生成 RowKey
     *
     * @param sellerId  卖家ID
     * @param timestamp 时间戳
     * @param orderId   订单ID
     * @return RowKey
     */
    public String createRowKey(String sellerId, String timestamp, String orderId) {
        /********** begin **********/
        String rowKey = sellerId + "-" + timestamp + "-" + orderId;  
        return rowKey;  
        /********** end **********/
    }


    /**
     * 查询某个卖家某段时间内的交易记录
     *
     * @param sellerId       卖家ID
     * @param startTimestamp 开始时间戳
     * @param endTimestamp   截止时间戳
     * @return map 存储 (rowkey,value)
     */
    public Map<String, String> findLogByTimestampRange(String sellerId, String startTimestamp, String endTimestamp) throws Exception {
        Map<String, String> map = new HashMap<>();
        /********** begin **********/
        Configuration conf = new Configuration();  
        conf.set("hbase.zookeeper.quorum", "127.0.0.1:2181");  
        Connection connection = ConnectionFactory.createConnection(conf);  
        Scan scan = new Scan();
        String startRow = sellerId + "-" + startTimestamp;  
        String stopRow = sellerId + "-" + (endTimestamp + 1);
        scan.withStartRow(startRow.getBytes());  
        scan.withStopRow(stopRow.getBytes());  
        Table table = connection.getTable(TableName.valueOf("deal"));  
        ResultScanner scanner = table.getScanner(scan);  
        for (Result result : scanner) {  
            String key = Bytes.toString(result.getRow());  
            List<Cell> cells = result.listCells();  
            for (Cell c : cells) {  
                String value = Bytes.toString(CellUtil.cloneValue(c));  
                map.put(key, value);  
            }  
        }    
	   
	   
        /********** end **********/
        return map;
    }


}

第二关

package step2;

import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.hbase.Cell;
import org.apache.hadoop.hbase.CellUtil;
import org.apache.hadoop.hbase.TableName;
import org.apache.hadoop.hbase.client.*;
import org.apache.hadoop.hbase.util.Bytes;

import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class Task {

    static String[] chars = {"0", "1", "2", "3", "4", "5", "6", "7", "8", "9", "a", "b", "c", "d", "e", "f"};

    /**
	 * MD5 加密
     * @param str 需要加密的文本
     * @return 加密后的内容
     */
    public static String StringInMd5(String str) {
        MessageDigest md5 = null;
        try {
            md5 = MessageDigest.getInstance("md5");
            byte[] result = md5.digest(str.getBytes());
            StringBuilder sb = new StringBuilder(32);
            for (int i = 0; i < result.length; i++) {
                byte x = result[i];
                int h = 0x0f & (x >>> 4);
                int l = 0x0f & x;
                sb.append(chars[h]).append(chars[l]);
            }
            return sb.toString();
        } catch (NoSuchAlgorithmException e) {
            throw new RuntimeException(e);
        }
    }


    /**
     * 生成 row
     *
     * @param carId     汽车ID
     * @param timestamp 时间戳
     * @return rowkey
     */
    public String createRowKey(String carId, String timestamp) {
        /********** begin **********/
        String prefix = StringInMd5(carId);
        String rowKey = prefix.substring(0,5) + "-" + carId + "-" + timestamp;
        return rowKey;
        /********** end **********/
    }


    /**
     * 查询某辆车在某个时间范围的交易记录
     *
     * @param carId          车辆ID
     * @param startTimestamp 开始时间戳
     * @param endTimestamp   截止时间戳
     * @return map 存储 (rowkey,value)
     */
    public Map<String, String> findLogByTimestampRange(String carId, String startTimestamp, String endTimestamp) throws Exception {
        Map<String, String> map = new HashMap<>();
        /********** begin **********/
        Configuration conf = new Configuration();
        conf.set("hbase.zookeeper.quorum","127.0.0.1:2181");
        Connection connection = ConnectionFactory.createConnection(conf);
        Scan scan = new Scan();
        String startRow = createRowKey(carId,startTimestamp);
        String stopRow = createRowKey(carId,endTimestamp + 1);
        scan.withStartRow(startRow.getBytes());
        scan.withStopRow(stopRow.getBytes());
        Table table =connection.getTable(TableName.valueOf("deal"));
        ResultScanner scanner = table.getScanner(scan);
        for (Result result : scanner) {
            String key = Bytes.toString(result.getRow());
            List<Cell> cells = result.listCells();
            for (Cell c : cells) {
                String value = Bytes.toString(CellUtil.cloneValue(c));
                map.put(key, value);
            }
        } 


	   
	   
        /********** end **********/
        return map;
    }


}

 

Logo

为开发者提供学习成长、分享交流、生态实践、资源工具等服务,帮助开发者快速成长。

更多推荐