开源软件名称:hbase-parser
开源软件地址:https://gitee.com/qieangel2013/hbase-parser
开源软件介绍:
hbase-parserphp的操作类库,通过写sql来来查询Hbase composer使用{ "require": { "qieangel2013/hbase-parser": "dev-master" }}composer installrequire __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函数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 交流使用项目地址github:https://github.com/qieangel2013/hbase-parseroschina:https://gitee.com/qieangel2013/hbase-parser 如果你对我的辛勤劳动给予肯定,请给我捐赠,你的捐赠是我最大的动力项目捐赠列表 |
请发表评论