You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Mike Friedman <Mi...@ds-iq.com> on 2014/08/27 21:54:48 UTC
sqlline error with Phoenix 4.1
Hi,
We are wondering if anyone has seen this error running sqlline of Phoenix 4.1RC and what a solution or workaround might be. Thanks. - Mike
14/08/27 09:09:59 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
14/08/27 09:10:00 WARN impl.MetricsConfig: Cannot locate configuration: tried hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties
14/08/27 09:10:01 WARN query.ConnectionQueryServicesImpl: addColumnsIfNotExists failed due to:org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): Undefined column. columnName=IS_VIEW_REFERENCED
Error: ERROR 504 (42703): Undefined column. columnName=IS_VIEW_REFERENCED (state=42703,code=504)
org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): Undefined column. columnName=IS_VIEW_REFERENCED
at org.apache.phoenix.schema.PTableImpl.getColumn(PTableImpl.java:516)
at org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.resolveColumn(FromCompiler.java:264)
at org.apache.phoenix.compile.UpsertCompiler.compile(UpsertCompiler.java:332)
at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:448)
at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:439)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:255)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:248)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:246)
at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:192)
at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:147)
at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:152)
at org.apache.phoenix.schema.MetaDataClient.addColumnMutation(MetaDataClient.java:391)
at org.apache.phoenix.schema.MetaDataClient.addColumn(MetaDataClient.java:1732)
at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableAddColumnStatement$1.execute(PhoenixStatement.java:689)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:256)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:248)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:246)
at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:960)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.addColumnsIfNotExists(ConnectionQueryServicesImpl.java:1465)
at org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1526)
at org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1489)
at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1489)
at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:162)
at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:129)
at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:133)
at sqlline.SqlLine$DatabaseConnection.connect(SqlLine.java:4650)
at sqlline.SqlLine$DatabaseConnection.getConnection(SqlLine.java:4701)
at sqlline.SqlLine$Commands.connect(SqlLine.java:3942)
at sqlline.SqlLine$Commands.connect(SqlLine.java:3851)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at sqlline.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2810)
at sqlline.SqlLine.dispatch(SqlLine.java:817)
at sqlline.SqlLine.initArgs(SqlLine.java:633)
at sqlline.SqlLine.begin(SqlLine.java:680)
at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
at sqlline.SqlLine.main(SqlLine.java:424)
sqlline version 1.1.2
Re: sqlline error with Phoenix 4.1
Posted by James Taylor <ja...@apache.org>.
Sounds like you may have an out-of-sync issue with your
SYSTEM.CATALOG. What version of Phoenix were you using before you
tried the 4.1 RC? Is this the 4.1 RC1? Did you upgrade from an earlier
Phoenix version, as the IS_VIEW_REFERENCED was added in the 3.0/4.0
release, I believe? If you upgraded, did you upgrade to each minor
release in order so that the SYSTEM.CATALOG table was upgraded.
One workaround (if this is feasible for you) is to disable and drop
the SYSTEM.CATALOG table from an HBase shell, and then re-run your DDL
command to re-create your tables again. This won't affect your HBase
data, though your indexes would be rebuilt from scratch.
Thanks,
James
On Wed, Aug 27, 2014 at 12:54 PM, Mike Friedman <Mi...@ds-iq.com> wrote:
> Hi,
>
>
>
> We are wondering if anyone has seen this error running sqlline of Phoenix
> 4.1RC and what a solution or workaround might be. Thanks. - Mike
>
>
>
>
>
> 14/08/27 09:09:59 WARN util.NativeCodeLoader: Unable to load native-hadoop
> library for your platform... using builtin-java classes where applicable
>
> 14/08/27 09:10:00 WARN impl.MetricsConfig: Cannot locate configuration:
> tried hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties
>
> 14/08/27 09:10:01 WARN query.ConnectionQueryServicesImpl:
> addColumnsIfNotExists failed due
> to:org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703):
> Undefined column. columnName=IS_VIEW_REFERENCED
>
> Error: ERROR 504 (42703): Undefined column. columnName=IS_VIEW_REFERENCED
> (state=42703,code=504)
>
> org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703):
> Undefined column. columnName=IS_VIEW_REFERENCED
>
> at
> org.apache.phoenix.schema.PTableImpl.getColumn(PTableImpl.java:516)
>
> at
> org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.resolveColumn(FromCompiler.java:264)
>
> at
> org.apache.phoenix.compile.UpsertCompiler.compile(UpsertCompiler.java:332)
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:448)
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:439)
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:255)
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:248)
>
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:246)
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:192)
>
> at
> org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:147)
>
> at
> org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:152)
>
> at
> org.apache.phoenix.schema.MetaDataClient.addColumnMutation(MetaDataClient.java:391)
>
> at
> org.apache.phoenix.schema.MetaDataClient.addColumn(MetaDataClient.java:1732)
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement$ExecutableAddColumnStatement$1.execute(PhoenixStatement.java:689)
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:256)
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:248)
>
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:246)
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:960)
>
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.addColumnsIfNotExists(ConnectionQueryServicesImpl.java:1465)
>
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1526)
>
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1489)
>
> at
> org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77)
>
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1489)
>
> at
> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:162)
>
> at
> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:129)
>
> at
> org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:133)
>
> at sqlline.SqlLine$DatabaseConnection.connect(SqlLine.java:4650)
>
> at
> sqlline.SqlLine$DatabaseConnection.getConnection(SqlLine.java:4701)
>
> at sqlline.SqlLine$Commands.connect(SqlLine.java:3942)
>
> at sqlline.SqlLine$Commands.connect(SqlLine.java:3851)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>
> at java.lang.reflect.Method.invoke(Method.java:606)
>
> at
> sqlline.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2810)
>
> at sqlline.SqlLine.dispatch(SqlLine.java:817)
>
> at sqlline.SqlLine.initArgs(SqlLine.java:633)
>
> at sqlline.SqlLine.begin(SqlLine.java:680)
>
> at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
>
> at sqlline.SqlLine.main(SqlLine.java:424)
>
> sqlline version 1.1.2
>
>