Search by 
qieangel2013 / hbase-parser
Hbase php library
dev-master
2019-09-05 10:24 UTC
Requires
- php: >=5.3
This package is not auto-updated.
Last update: 2024-05-09 10:27:27 UTC
README
php的操作类库，通过写sql来来查询Hbase
composer使用
{
"require": {
"qieangel2013/hbase-parser": "dev-master"
}
}
composer install
require __DIR__.'/vendor/autoload.php';
// $sql= 'insert into ThridPlatform(pay_time,APP_ID,MCH_ID,IMEI,order_sn_no,order_sn_sh,user_tag,pay_type,app_type,pay_status,bank,money_type,total_amount,mach_total_amount,coupon_amount,refund_number_orderno,refund_number_sh,refund_amount,coupon_refund_amount,refund_type,refund_status,goods_name,service_charge,rate)values("2018-10-22 00:16:56","","","","20181022220014075510051173","1165640138859051","*nwt)","交易","0","SUCCESS","","","35.00","35.00","0.00","",""," 35.00","0.00","","","ORACLE触发器视频课程","-0.19","")';
$sql='select * from students' ;
$result = HbaseClient::getMethod(['HbaseParseModel','QuerySinTable'],$sql,'cf1');//需要传column family ，统一方法调用
var_dump($result);//打印结果
普通调用
require_once __DIR__ .'/src/HbaseClient.php';
// $sql= 'insert into ThridPlatform(pay_time,APP_ID,MCH_ID,IMEI,order_sn_no,order_sn_sh,user_tag,pay_type,app_type,pay_status,bank,money_type,total_amount,mach_total_amount,coupon_amount,refund_number_orderno,refund_number_sh,refund_amount,coupon_refund_amount,refund_type,refund_status,goods_name,service_charge,rate)values("2018-10-22 00:16:56","","","","20181022220014075510051173","1165640138859051","*nwt)","交易","0","SUCCESS","","","35.00","35.00","0.00","",""," 35.00","0.00","","","ORACLE触发器视频课程","-0.19","")';
$sql='select * from students' ;
$result = HbaseClient::getMethod(['HbaseParseModel','QuerySinTable'],$sql,'cf1');//需要传column family ，统一方法调用
var_dump($result);//打印结果
目前支持的sql函数
* SQL Insert
* SQL Select
TODO
* SQL Delete
* SQL Update
* SQL Where
* SQL Order By
* SQL Group By
* SQL AND
* SQL OR (多重or如:((a=1 and b=2) or (c=3 and d=4)) and e=5)
* SQL Like
* SQL Not Like
* SQL Is NULL
* SQL Is Not NULL
* SQL COUNT distinct
* SQL In
* SQL Not In
* SQL =
* SQL !=
* SQL <>
* SQL avg()
* SQL count()
* SQL max()
* SQL min()
* SQL sum()
* SQL Between
* SQL Aliases
* SQL concat_ws
* SQL DATE_FORMATE
* SQL Having
交流使用
qq群：578276199
项目地址
github：https://github.com/qieangel2013/hbase-parser
oschina：https://gitee.com/qieangel2013/hbase-parser
