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 ...