phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aleksandr Saraseka <asaras...@eztexting.com>
Subject Index on SYSTEM.LOG failed
Date Thu, 24 Oct 2019 14:01:57 GMT
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;
+------------------------------------------------------------+-----------------+----------------+--------------+
|                            PLAN                            |
EST_BYTES_READ  | EST_ROWS_READ  | EST_INFO_TS  |
+------------------------------------------------------------+-----------------+----------------+--------------+
| CLIENT 32-CHUNK PARALLEL 32-WAY FULL SCAN OVER SYSTEM:LOG  | null
   | null           | null         |
| CLIENT MERGE SORT                                          | null
   | null           | null         |
+------------------------------------------------------------+-----------------+----------------+--------------+
2 rows selected

So I'm trying to create local index on start_time field, but getting an
exception. Is this "by design" that you can not create index on SYSTEM
tables or I need to do this in some another way ?
CREATE LOCAL INDEX "system_log_start_time_idx" ON SYSTEM.LOG ("START_TIME");
Error: Error -1 (00000) : Error while executing SQL "CREATE LOCAL INDEX
"system_log_start_time_idx" ON SYSTEM.LOG ("START_TIME")": Remote driver
error: IndexOutOfBoundsException: Index: 0 (state=00000,code=-1)
org.apache.calcite.avatica.AvaticaSqlException: Error -1 (00000) : Error
while executing SQL "CREATE LOCAL INDEX "system_log_start_time_idx" ON
SYSTEM.LOG ("START_TIME")": Remote driver error: IndexOutOfBoundsException:
Index: 0
        at
org.apache.phoenix.shaded.org.apache.calcite.avatica.Helper.createException(Helper.java:54)
        at
org.apache.phoenix.shaded.org.apache.calcite.avatica.Helper.createException(Helper.java:41)
        at
org.apache.phoenix.shaded.org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:163)
        at
org.apache.phoenix.shaded.org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:217)
        at sqlline.Commands.execute(Commands.java:822)
        at sqlline.Commands.sql(Commands.java:732)
        at sqlline.SqlLine.dispatch(SqlLine.java:813)
        at sqlline.SqlLine.begin(SqlLine.java:686)
        at sqlline.SqlLine.start(SqlLine.java:398)
        at sqlline.SqlLine.main(SqlLine.java:291)
        at
org.apache.phoenix.queryserver.client.SqllineWrapper.main(SqllineWrapper.java:93)
java.lang.IllegalAccessError:
org/apache/phoenix/shaded/org/apache/calcite/avatica/AvaticaSqlException$PrintStreamOrWriter
        at
org.apache.calcite.avatica.AvaticaSqlException.printStackTrace(AvaticaSqlException.java:75)
        at java.lang.Throwable.printStackTrace(Throwable.java:634)
        at sqlline.SqlLine.handleSQLException(SqlLine.java:1540)
        at sqlline.SqlLine.handleException(SqlLine.java:1505)
        at sqlline.SqlLine.error(SqlLine.java:905)
        at sqlline.Commands.execute(Commands.java:860)
        at sqlline.Commands.sql(Commands.java:732)
        at sqlline.SqlLine.dispatch(SqlLine.java:813)
        at sqlline.SqlLine.begin(SqlLine.java:686)
        at sqlline.SqlLine.start(SqlLine.java:398)
        at sqlline.SqlLine.main(SqlLine.java:291)
        at
org.apache.phoenix.queryserver.client.SqllineWrapper.main(SqllineWrapper.java:93)


-- 
Aleksandr Saraseka
DBA
380997600401
 *•*  asaraseka@eztexting.com  *•*  eztexting.com
<http://eztexting.com?utm_source=WiseStamp&utm_medium=email&utm_term=&utm_content=&utm_campaign=signature>
<http://facebook.com/eztexting?utm_source=WiseStamp&utm_medium=email&utm_term=&utm_content=&utm_campaign=signature>
<http://linkedin.com/company/eztexting/?utm_source=WiseStamp&utm_medium=email&utm_term=&utm_content=&utm_campaign=signature>
<http://twitter.com/eztexting?utm_source=WiseStamp&utm_medium=email&utm_term=&utm_content=&utm_campaign=signature>
<https://www.youtube.com/eztexting?utm_source=WiseStamp&utm_medium=email&utm_term=&utm_content=&utm_campaign=signature>
<https://www.instagram.com/ez_texting/?utm_source=WiseStamp&utm_medium=email&utm_term=&utm_content=&utm_campaign=signature>
<https://www.facebook.com/alex.saraseka?utm_source=WiseStamp&utm_medium=email&utm_term=&utm_content=&utm_campaign=signature>
<https://www.linkedin.com/in/alexander-saraseka-32616076/?utm_source=WiseStamp&utm_medium=email&utm_term=&utm_content=&utm_campaign=signature>

Mime
View raw message