JacksonKing的专栏

select * from table1 where cast(TO_DATE(start_time,'yyyyMMddHHmmss') as date) between cast(TO_DATE('20200514000000','yyyyMMddHHmmss') as date) and cast(TO_DATE('20200515000000','yyyyMMddHHmmss') as date);

Phoenix中Sequence的用法Phoenix--HBase的JDBC驱动序列（Sequence）是Phoenix提供的允许产生单调递增数字的一个SQL特性，序列会自动生成顺序递增的序列号，以实现自动提供唯一的主键值。使用CREATE SEQUENCE语句建立序列的语法如下：create sequence <deq_name>[start with n]...

AVG ( numericTerm ) COUNT (Term) COUNT (DISTINCT Term)MAX ( term )MIN ( term )SUM ( numericTerm )PERCENTILE_CONT( 0.9 ) WITHIN GROUP (ORDER BY X ASC)PERCENTILE_DISC( 0.9 ) WI...

Error: ERROR 203 (22005): Type mismatch. VARCHAR and INTEGER for PROGRESS (state=22005,code=203)org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): Type mismatch. VARCHAR and INTEGER ...