We've always asked in the past that you upgrade separately from one minor release to the next (i.e. from 4.0.0 to 4.1.0 and then to 4.2.1), but I like Jeffrey's idea to improve this. Thanks, James
On Fri, Nov 21, 2014 at 5:37 PM, Jeffrey Zhong <[email protected]> wrote: > > Actually this is a serious bug and we break the upgrade path from 4.0 > directly to 4.2. As a workaround, you can try to download Phoenix 4.1 to > connect your cluster once. At that time, Phoenix 4.1 client will create > "INDEX_TYPE" column. > > On 11/19/14, 2:42 PM, "Ahmed Hussien" <[email protected]> wrote: > >>heeeeeeeeeelllllllllllllllllllppppp!!!!! >> >> >>Old evrsion is 4.0.0 >> >>1- I removed all old phoenix from hbase/lib >>2- copied phoenix-4.2.0-server.jar and phoenix-4.2.0-client.jar to the >>same folder >>3- restarted the whole machine. >>4- started hadoop2 successfully >>5- started hbase 0.98.3 successfully >>6- /usr/lib/phoenix/phoenix-4.2.0-bin/bin$ ./sqlline.py localhost >> >> >>I got this Error and no phoenix SQL command is executing : >> >>Setting property: [isolation, TRANSACTION_READ_COMMITTED] >>issuing: !connect jdbc:phoenix:localhost none none >>org.apache.phoenix.jdbc.PhoenixDriver >>Connecting to jdbc:phoenix:localhost >>14/11/20 01:30:58 WARN util.NativeCodeLoader: Unable to load >>native-hadoop library for your platform... using builtin-java classes >>where applicable >>Error: ERROR 504 (42703): Undefined column. columnName=INDEX_TYPE >>(state=42703,code=504) >>org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): >>Undefined column. columnName=INDEX_TYPE >> at >>org.apache.phoenix.schema.PTableImpl.getColumn(PTableImpl.java:545) >> at >>org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.resolveC >>olumn(FromCompiler.java:269) >> at >>org.apache.phoenix.compile.UpsertCompiler.compile(UpsertCompiler.java:337) >> at >>org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compile >>Plan(PhoenixStatement.java:467) >> at >>org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compile >>Plan(PhoenixStatement.java:458) >> at >>org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:259) >> at >>org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:252) >> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) >> at >>org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement. >>java:250) >> at >>org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:196 >>) >> at >>org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedSt >>atement.java:172) >> at >>org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedSt >>atement.java:177) >> at >>org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClien >>t.java:1505) >> at >>org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:5 >>34) >> at >>org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompil >>er.java:184) >> at >>org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:260) >> at >>org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:252) >> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) >> at >>org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement. >>java:250) >> at >>org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.ja >>va:1026) >> at >>org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQuer >>yServicesImpl.java:1532) >> at >>org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQuer >>yServicesImpl.java:1491) >> at >>org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor >>.java:77) >> at >>org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryS >>ervicesImpl.java:1491) >> at >>org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDr >>iver.java:162) >> at >>org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDrive >>r.java:126) >> 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: >>62) >> at >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorIm >>pl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:483) >> 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 >>0: jdbc:phoenix:localhost> >> > > > > -- > CONFIDENTIALITY NOTICE > NOTICE: This message is intended for the use of the individual or entity to > which it is addressed and may contain information that is confidential, > privileged and exempt from disclosure under applicable law. If the reader > of this message is not the intended recipient, you are hereby notified that > any printing, copying, dissemination, distribution, disclosure or > forwarding of this communication is strictly prohibited. If you have > received this communication in error, please contact the sender immediately > and delete it from your system. Thank You.
