About aervits

aervits · ‎05-12-2016

@Amar ch please accept one of the answers to close the thread.

aervits · ‎05-12-2016

He's using IBM BigInsights

aervits · ‎05-11-2016

@vshukla

aervits · ‎05-11-2016

Another option is to try Phoenix, in Phoenix you can create a table and ensure a good key distribution. There is also Pig integration https://phoenix.apache.org/pig_integration.html Bottom line, Phoenix makes working with HBase easy, still uses all HBase APIs underneath and has a familiar SQL syntax.

aervits · ‎05-11-2016

The only way is to make sure you have good rowkey. Pre-splitting will help on initial load but good design will be essential in the long run. Play around with keys until you get it right, Java's UUID also similar to Pig's uniqueID will ensure good key distribution but you will lose ability to do lookups. It all depends on the type of access patterns your application requires.

aervits · ‎05-10-2016

Youbare experiencing hotspotting, thats when all regions reside on one RS. Use move command in CLI to move regions around https://learnhbase.wordpress.com/2013/03/02/hbase-shell-commands/ Also consider another rowkey as that's what impacts all rows going to same RS.

aervits · ‎05-09-2016

I gave user admin rights but that does not have any impact on user being able to copy export snapshots hbase(main):001:0> user_permission 'vagrant' User Namespace,Table,Family,Qualifier:Permission vagrant default,vagrant,,: [Permission: actions=READ,WRITE,EXEC,CREATE,ADMIN] still getting Caused by: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.AccessControlException): Permission denied: user=vagrant, access=EXECUTE, inode="/apps/hbase/data/.hbase-snapshot/vagrantsnap":hbase:hdfs:drwx------ would labels and scopes help in this case? What are my options at this point?

aervits · ‎05-09-2016

Local user on OS

aervits · ‎05-08-2016

No you need to implement that yourself.

aervits · ‎05-08-2016

Make sure sqoop metastore service is up. If it goes down, you need to have a way to bring it up or at least alert you. In my days, I wrote a script that would check whether mestore service was up every few minutes or so and alert if down.

Online	Offline
Last Visited	‎08-15-2019 06:35 AM

Member Since	‎10-01-2015 11:46 AM
Last Visited	‎08-15-2019 06:35 AM
Posts	3,933
Kudos received	1074

Cloudera Community

Re: Where can I get latest resource_management.c...

Re: How to Kerberize Flume?

Re: Load Hive Table form Pig Output File.

Re: HDP 2.6 Cluster Issues with Hive Metastore

Re: which HDP release will storm 1.1.0 be packaged...

Re: Is it possible to perform bulk insert to ES w...

Re: Knox - wrong mapping? help will be appriciated

Re: Default Spark env config error in HDP2.4 insta...

Re: Improve performance in loading Hbase table usi...

Re: Improve performance in loading Hbase table usi...

Re: Improve performance in loading Hbase table usi...

Is there a way a user other than hbase can export ...

Re: Automated Kerberos Installation and Configurat...

Re: sqoop job -list command

Re: sqoop job -list command