phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josh Elser <els...@apache.org>
Subject Re: Index on SYSTEM.LOG failed
Date Thu, 24 Oct 2019 17:18:49 GMT
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 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
> <tel:380997600401> *•* asaraseka@eztexting.com 
> <mailto: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