Re: Error when try to create mutable secondary index...

2014-08-12 Thread Saravanan A
Issue resolved...added the property hbase.regionserver.wal.codec org.apache.hadoop.hbase.regionserver.wal.IndexedWALEditCodec in CDH UI under the following value"RegionServer Configuration Safety Valve for hbase-site.xml"..Thanks for your help,,.[?] On Mon, Aug 11, 2014 at 11:05 PM, Sarav

Re: Error when try to create mutable secondary index...

2014-08-11 Thread Saravanan A
yes.. On Mon, Aug 11, 2014 at 10:59 PM, Jesse Yates wrote: > That seems correct. I'm not sure where the issue is either. It seems like > the property isn't in the correct config files (also, you don't need it on > the master configs, but it won't hurt). > > Is the property there when you dump t

Re: Error when try to create mutable secondary index...

2014-08-11 Thread Saravanan A
its for Non secure cluster... On Mon, Aug 11, 2014 at 11:01 PM, James Taylor wrote: > Are you running against a secure cluster? If so, you'd need to compile > Phoenix yourself as the jars in our distribution is for a non secure > cluster. > > On Mon, Aug 11, 2014 at 10:29 AM, Jesse Yates > wro

Re: Error when try to create mutable secondary index...

2014-08-11 Thread James Taylor
Are you running against a secure cluster? If so, you'd need to compile Phoenix yourself as the jars in our distribution is for a non secure cluster. On Mon, Aug 11, 2014 at 10:29 AM, Jesse Yates wrote: > That seems correct. I'm not sure where the issue is either. It seems like > the property isn'

Re: Error when try to create mutable secondary index...

2014-08-11 Thread Jesse Yates
That seems correct. I'm not sure where the issue is either. It seems like the property isn't in the correct config files (also, you don't need it on the master configs, but it won't hurt). Is the property there when you dump the config from the RS's UI page? --- Jesse Yates @jesse

Re: Error when try to create mutable secondary index...

2014-08-11 Thread Saravanan A
No am not sure where the issue is... Procedure i did for installation for Phoenix installation: 1.Extracted Phoenix-3.0. 2.Added Phoenix core.jar in all region servers and in master.. 3. Added this hbase.regionserver.wal.codec org.apache.hadoop.hbase.regionserver.wal.IndexedWALEditCodec p

Re: Error when try to create mutable secondary index...

2014-08-11 Thread Jesse Yates
Well now, that is strange. Maybe its something to do with CDH? Have you talked to those fellas? Or maybe someone from Cloudera has an insight? Seems like it should work On Aug 11, 2014 9:55 AM, "Saravanan A" wrote: > *bin/hbase classpath:* > > > */opt/cloudera/parcels/CDH-4.7.0-1.cdh4.7.0.p0.40/

Re: Error when try to create mutable secondary index...

2014-08-11 Thread Saravanan A
*bin/hbase classpath:* */opt/cloudera/parcels/CDH-4.7.0-1.cdh4.7.0.p0.40/lib/hbase/bin/../conf:/usr/java/default/lib/tools.jar:/opt/cloudera/parcels/CDH-4.7.0-1.cdh4.7.0.p0.40/lib/hbase/bin/..:/opt/cloudera/parcels/CDH-4.7.0-1.cdh4.7.0.p0.40/lib/hbase/bin/../hbase-0.94.15-cdh4.7.0-security.jar:/op

Re: Error when try to create mutable secondary index...

2014-08-11 Thread Jesse Yates
The classpath you are using above doesn't include the HBase config files, so the code executed will correctly tell you that the class exists, but is not configured. Have you tried running "bin/hbase classpath" to see what you're classpath is at RS startup? If its the same as the -cp argument, its

Re: Error when try to create mutable secondary index...

2014-08-11 Thread Saravanan A
*This is the command i run in hbase classpath (test1.jar is my jar file)*: hbase -cp .:hadoop-common-2.0.0-cdh4.7.0.jar:commons-logging-1.1.1.jar:hbase-0.94.15-cdh4.7.0-security.jar:com.google.collections.jar:commons-collections-3.2.1.jar:phoenix-core-3.0.0-incubating.jar:com.google.guava_1.6.0.jar

Re: Error when try to create mutable secondary index...

2014-08-09 Thread Jesse Yates
When you run $ bin/hbase classpath What do you get? Should help illuminate if everything is setup right. If the phoenix jar is there, then check the contents of the jar ( http://docs.oracle.com/javase/tutorial/deployment/jar/view.html) and make sure the classes are present. On Aug 9, 2014 1:03

Re: Error when try to create mutable secondary index...

2014-08-09 Thread Saravanan A
Hi Jesse, I ran the following code to test the existence of the classes you asked me to check. I initialized the two constants to the following values. === public static final String INDEX_WAL_EDIT_CODEC_CLASS_NAME = "org.apache.hadoop.hbase.regionserver.wal.IndexedWALEditCodec"; public stat

Re: Error when try to create mutable secondary index...

2014-08-08 Thread Jesse Yates
This error is thrown when on the server-side, the following code returns false (IndexManagementUtil#isWALEditCodecSet): public static boolean isWALEditCodecSet(Configuration conf) { > // check to see if the WALEditCodec is installed > try { > // Use reflection to lo

Re: Error when try to create mutable secondary index...

2014-08-08 Thread Saravanan A
This is my Hbase-site.xml file... hbase.regionserver.wal.codec org.apache.hadoop.hbase.regionserver.wal.IndexedWALEditCodec hbase.region.server.rpc.scheduler.factory.class org.apache.phoenix.hbase.index.ipc.PhoenixIndexRpcSchedulerFactory Factory to create the Phoeni

Re: Error when try to create mutable secondary index...

2014-08-08 Thread Saravanan A
I already included this property in hbase-site.xml in all region servers..but still am getting that error...If i define my view as IMMUTABLE_ROWS = true, then i can able to create view..but i want to create index for mutable.. On Fri, Aug 8, 2014 at 2:10 PM, Abhilash L L wrote: > Really sorry,

Re: Error when try to create mutable secondary index...

2014-08-08 Thread Abhilash L L
Really sorry, shared the wrong config hbase.regionserver.wal.codec org.apache.hadoop.hbase.regionserver.wal.IndexedWALEditCodec Regards, Abhilash L L Capillary Technologies M:919886208262 abhil...@capillarytech.com | www.capillarytech.com Email from people at capillarytech.com may not r

Re: Error when try to create mutable secondary index...

2014-08-08 Thread Saravanan A
Hi Abhilash, Thanks for the replay...i included above property and restarted the region servers but still am getting the same error... On Fri, Aug 8, 2014 at 12:39 PM, Abhilash L L wrote: > Hi Saravanan, > > Please check the Setup section here > > http://phoenix.apache.org/secondary_index

Re: Error when try to create mutable secondary index...

2014-08-08 Thread Abhilash L L
Hi Saravanan, Please check the Setup section here http://phoenix.apache.org/secondary_indexing.html You will need to add this config to all Region Servers in hbase-site. xml, as the error says as well (You will need to restart the servers after the change) hbase.region.server.rpc.sch

Error when try to create mutable secondary index...

2014-08-07 Thread Saravanan A
Hi, I have a table in hbase and created view in phoenix and try to create index on a column on the view..but i got following error.. Error: ERROR 1029 (42Y88): Mutable secondary indexes must have the hbase.regionserver.wal.codec property set to org.apache.hadoop.hbase.regionserver.wal.Indexed