hbase-parser

{  
    "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 Insert  
*  SQL Select  

*  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