Yes. On Apr 13, 2016, at 5:26 PM, Samarth Jain <samarth.j...@gmail.com<mailto:samarth.j...@gmail.com>> wrote:
Srinivas, Are you trying to create a phoenix view over an existing HBase table? On Wed, Apr 13, 2016 at 11:47 AM, Pindi, Srinivas <srinivas.pi...@epsilon.com<mailto:srinivas.pi...@epsilon.com>> wrote: Problem Statement: While we are trying to create a phoenix view and we are getting the following exception. When I looked at the source code here is what I found: if (currentServerSideTableTimeStamp < MetaDataProtocol.MIN_SYSTEM_TABLE_TIMESTAMP_4_6_0) { columnsToAdd += PhoenixDatabaseMetaData.IS_ROW_TIMESTAMP + " " + PBoolean.INSTANCE.getSqlTypeName(); } Version: Server phoenix-4.6.1-HBase-1.0-1.17.0.21 Client phoenix-4.6.1-HBase-1.0-1.17.0.21 Error: Caused by: java.sql.SQLException: Error running CREATE VIEW XYZ ("A" VARCHAR, "B" VARCHAR) AS SELECT * FROM HBASE_TABLE_1 WHERE (KEY >= '0-02UsG-0' AND KEY <= '0-02UsG-g') AND UPDATED_DATE IS NOT NULL … … ... 90 more Caused by: org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): Undefined column. columnName=IS_ROW_TIMESTAMP at org.apache.phoenix.schema.PTableImpl.getColumn(PTableImpl.java:647) at org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.resolveColumn(FromCompiler.java:361) at org.apache.phoenix.compile.UpsertCompiler.compile(UpsertCompiler.java:386) at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:553) at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:541) at org.apache.phoenix.jdbc.PhoenixPreparedStatement.getParameterMetaData(PhoenixPreparedStatement.java:246) at org.apache.phoenix.schema.MetaDataClient.addColumnMutation(MetaDataClient.java:707) at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1943) ________________________________ This e-mail and files transmitted with it are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you are not one of the named recipient(s) or otherwise have reason to believe that you received this message in error, please immediately notify sender by e-mail, and destroy the original message. Thank You. ________________________________ This e-mail and files transmitted with it are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you are not one of the named recipient(s) or otherwise have reason to believe that you received this message in error, please immediately notify sender by e-mail, and destroy the original message. Thank You.