1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | CREATE HBASE TABLE ORDERS ( O_ORDERKEY BIGINT, O_CUSTKEY INTEGER, O_ORDERSTATUS VARCHAR(1), O_TOTALPRICE FLOAT, O_ORDERDATE TIMESTAMP, O_ORDERPRIORITY VARCHAR(15), O_CLERK VARCHAR(15), O_SHIPPRIORITY INTEGER, O_COMMENT VARCHAR(79) ) column mapping ( key mapped by (O_CUSTKEY,O_ORDERKEY), cf:d mapped by (O_ORDERSTATUS,O_TOTALPRICE,O_ORDERPRIORITY, O_CLERK,O_SHIPPRIORITY,O_COMMENT), cfd mapped by (O_ORDERDATE) ) default encoding binary; |
1 2 | LOAD HBASE DATA INPATH 'tpch/orders.10p.tbl' DELIMITED FIELDS TERMINATED BY '|' INTO TABLE ORDERS; |
1 | 150000 rows affected (total:21.52s) |
1 2 | log com.ibm.Jacl.modules.hcat.mapred.JaclHBaseInputFormat info; log com.ibm.Jacl.modules.hcat.hbase info; |
1 | tail -f /var/ibm/biginsights/bigsql/logs/bigsql.log |
欢迎光临 电子技术论坛_中国专业的电子工程师学习交流社区-中电网技术论坛 (http://bbs.eccn.com/) | Powered by Discuz! 7.0.0 |