where clause only support equal condition?

[colorant]

say with following query in wasp shell

query "select * from user where user_id=1" works +----------+-----------+ | user_id | name | +----------+-----------+ | 1 | binlijin | +----------+-----------+

while query "select * from user where user_id>0"

ERROR: java.sql.SQLException: org.apache.wasp.jdbc.JdbcException: Operate a not supported sql: "Don't get a Index!" [90170-1]

[jaywong85]

nope. wasp support range condition. but only in index query. it means we must create a index. such as (user_name and age) then we can : query "select * from user where user_name='abc' and age > 20"

[colorant]

ok i c, though this still seem strange to me, user_id is a primary key, still need index's help...?

[colorant]

And , then if I run

wasp(main):072:0> query "select * from user where name='binlijin'"

ERROR: java.sql.SQLException: org.apache.wasp.jdbc.JdbcException: Operate a not supported sql: "Don't get a Index!" [90170-1]

This is what the following wiki want to explained? :

1 当前版本支持构建索引的查询，即，没有构建索引的查询在本版本中尚不支持.

[jaywong85]

yep. 2 implementation in our design. so. primary key not similar with index

[colorant]

I see that primary key is part of hbase row-key, and this should also be sort able

I can not even create index for PK, then range scan on PK filed is not possilbe?

[jaywong85]

as U say. it is possible, but at the moment wasp not support. may be supported later.

thx for your report