Question

phoenix 语句where后面可以加行健吗？

0: jdbc:phoenix:114.215.102.22> select "id" from "invest" limit 5;
+------------------+
| id |
+------------------+
| 000070421093521 |
| 000143657002783 |
| 000180265418839 |
| 000203119495268 |
| 000240331051699
但是数据在mysql中为 0000070421093521 始终少最左边的那一位
而且 select * from "invest" where "id"='0000070421093521';或者 select * from "invest" where "id"='000070421093521'
为空，查不到数据

Answer 1

select id,money,[day],case when a_money>5 then 公式1 when a_money>=0 then 公式2 end as a_money from talbe1