Hi Marcin,
There's a few things going on here:
1) An index created on a view over HBase data won't be maintained by
Phoenix. You'd need to maintain it yourself through some other external
means. If you create a table that maps to your HBase data, then it will be
maintained.
2) An index would only
https://github.com/apache/calcite/blob/master/avatica/server/src/main/java/org/apache/calcite/avatica/jdbc/JdbcMeta.java
This is ultimately where the requests from the client using the thin
JDBC driver get executed inside of PQS. The API's aren't 100%, but it
should be obvious what is getting
You're using the wrong jar, Cheyenne.
The client.jar is for the "thick" JDBC driver. The thin-client.jar is
for the "thin" JDBC driver.
Cheyenne Forbes wrote:
I've used Squirrel SQL Client before but now I'm trying Squirrel'
snapshot-20170214_2214 with phoenix-4.9.0-HBase-1.2-client.jar it
Hi,
I have a table in hbase and created a view of it in phoenix, along
with a local index:
create view "traces" (rowkey VARCHAR PRIMARY KEY, "cf"."time" VARCHAR,
"cf"."number" VARCHAR, "cf"."class" VARCHAR);
create local index idxf on "dmstab_vehicle_traces" ("cf"."number",
"cf"."class",