Re: Phoenix ignoring index and index hint with some queries over mapped hbase tables.

2017-03-03 Thread James Taylor
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

Re: Phoenix Query Server query logging

2017-03-03 Thread Josh Elser
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

Re: Squirrel SQL Client doesnt work with phoenix-4.9.0-HBase-1.2

2017-03-03 Thread Josh Elser
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

Phoenix ignoring index and index hint with some queries over mapped hbase tables.

2017-03-03 Thread Marcin Januszkiewicz
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",