Re: Index on SYSTEM.LOG failed

2019-10-25 Thread Josh Elser
My question was not meant to imply that creating any index should fail in the same manner as what you see here. https://docs.oracle.com/javase/8/docs/api/java/lang/IllegalAccessError.html An IllegalAccessError means that the PQS tried to access this class but it failed (for some reason). Of

Re: Index on SYSTEM.LOG failed

2019-10-25 Thread Aleksandr Saraseka
Hello. Indexes on other tables created without any problems. 0: jdbc:phoenix:thin:url=http://localhost:876> create local index alex_test_data_idx on alex.test (data); No rows affected (10.93 seconds) 0: jdbc:phoenix:thin:url=http://localhost:876> On Thu, Oct 24, 2019 at 8:18 PM Josh Elser wrote:

Re: Index on SYSTEM.LOG failed

2019-10-24 Thread Josh Elser
Do you have a mismatch of Phoenix thinclient jars and Phoenix QueryServer versions? You're getting a classpath-type error, not some Phoenix internal error. On 10/24/19 10:01 AM, Aleksandr Saraseka wrote: Hello. We're logging queries in Phoenix. Main criteria can be a start_time (to

Index on SYSTEM.LOG failed

2019-10-24 Thread Aleksandr Saraseka
Hello. We're logging queries in Phoenix. Main criteria can be a start_time (to investigate possible performance problems in some particular time). Execution plan for the query shows full scan - that could cause problems with a lot of data^ explain select query from system.LOG order by start_time;