• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

hbase-parser: php的操作类库,通过写sql来来查询Hbase

原作者: [db:作者] 来自: 网络 收藏 邀请

开源软件名称:

hbase-parser

开源软件地址:

https://gitee.com/qieangel2013/hbase-parser

开源软件介绍:

hbase-parser

php的操作类库,通过写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函数

*  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-parseroschina:https://gitee.com/qieangel2013/hbase-parser

如果你对我的辛勤劳动给予肯定,请给我捐赠,你的捐赠是我最大的动力

项目捐赠列表


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
热门推荐
热门话题
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap