- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Phoenix secondary indexes failing on hbase.regionserver.wal.codec
- Labels:
-
Apache HBase
-
Apache Phoenix
Created ‎10-14-2016 01:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have followed directions here on enabling phoenix secondary indexes and restarted all of hbase (master/Region Servers) and phoenix. It continues to fail during secondary index creation
Error: Error -1 (00000) : Error while executing SQL "CREATE INDEX orig_airlineix ON airline (origin) ASYNC": Remote driver error: RuntimeException: java.sql.SQLException: ERROR 1029 (42Y88): Mutable secondary indexes must have the hbase.regionserver.wal.codec property set to org.apache.hadoop.hbase.regionserver.wal.IndexedWALEditCodec in the hbase-sites.xml of every region server. tableName=ORIG_AIRLINEIX -> SQLException: ERROR 1029 (42Y88): Mutable secondary indexes must have the hbase.regionserver.wal.codec property set to org.apache.hadoop.hbase.regionserver.wal.IndexedWALEditCodec in the hbase-sites.xml of every region server. tableName=ORIG_AIRLINEIX (state=00000,code=-1)
I have verified in hbase-site.xml
<property> <name>hbase.regionserver.wal.codec</name> <value>org.apache.hadoop.hbase.regionserver.wal.IndexedWALEditCodec</value> </property>
Any insights would be appreciated.
Created ‎10-14-2016 03:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I found the issue. I was using PQS on node which is did not install PQS. I created secondary index pointing to PQS installed by ambari and all is good.
Created ‎10-14-2016 03:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I found the issue. I was using PQS on node which is did not install PQS. I created secondary index pointing to PQS installed by ambari and all is good.
