About MasterOfPuppets

MasterOfPuppets · ‎04-12-2017

Even a simple select without any joins does not have any benefits to double the number of workers. Performance remain the same either on 4 nodes or 8 nodes.

MasterOfPuppets · ‎04-10-2017

Yes we have also rebalanced the data.

MasterOfPuppets · ‎04-10-2017

I've added 4 nodes to my 4 nodes cluster and i don't see any benefits. Queries againsts 8 nodes cluster perform the same as against 4 nodes cluster. All datanodes have same specifications.

MasterOfPuppets · ‎04-07-2017

In fact the issue was that hbase was not installed.

MasterOfPuppets · ‎03-31-2017

Still failing using : CREATE TABLE passwd_hbase(userid STRING, uid INT, shell STRING) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ('hbase.columns.mapping' = ':key,passwd:uid,passwd:shell') TBLPROPERTIES("hbase.table.name" = "mytable"); Caused by: java.lang.NullPointerException at org.apache.hadoop.hbase.zookeeper.ZooKeeperWatcher.getMetaReplicaNodes(ZooKeeperWatcher.java:489) at org.apache.hadoop.hbase.zookeeper.MetaTableLocator.blockUntilAvailable(MetaTableLocator.java:549) at org.apache.hadoop.hbase.client.ZooKeeperRegistry.getMetaRegionLocation(ZooKeeperRegistry.java:61) when executing list command in hbase it throws: ERROR: The node /hbase is not in ZooKeeper. It should have been written by the master. Check the value configured in 'zookeeper.znode.parent'. There could be a mismatch with the one configured in the master.

MasterOfPuppets · ‎03-31-2017

Hi there. The following statement fails to create HBASE table on hive: CREATE TABLE passwd_hbase(userid STRING, uid INT, shell STRING) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ('hbase.columns.mapping' = ':key,passwd:uid,passwd:shell'); Error: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:java.lang.RuntimeException: java.lang.NullPointerException at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:208) at org.apache.hadoop.hbase.client.ClientScanner.call(ClientScanner.java:320) Any idea ? Thx

MasterOfPuppets · ‎03-31-2017

Hi. I've 1 Hive Query running on Spark engine and i see such metrics from History Server logs for the related Application Id: What is the reason to get : CANNOT FIND ADDRESS ? Thx

MasterOfPuppets · ‎02-22-2017

Issuse has been fixed by replacing ODBC version 2.5.22 by 2.5.36

MasterOfPuppets · ‎02-21-2017

Hi. If adding 3 nodes to my 3 nodes clusters would obviously increase performance by x2 at least ? or there is more parameters to consider to improve to x2 ? Thanks

MasterOfPuppets · ‎02-21-2017

Hi. I've been facing an issue with the Cloudera Impala ODBC Driver when runing a simple query like: WITH totals AS ( SELECT * FROM dual ) SELECT * FROM totals; The dual table contains 1 record only but it always returns no record when connected through ODBC while the the same Query with JDBC connection returns 1 record. Any idea ?

Online	Offline
Last Visited	‎04-14-2017 09:21 AM

Member Since	‎01-13-2017 01:06 PM
Last Visited	‎04-14-2017 09:21 AM
Posts	40

Cloudera Community

Re: x sRe: Issue: Create HBASE table on Hive

Re: Impala ODBC not returning data when WITH claus...

Re: Adding nodes will improve performance ?

Re: Adding nodes will improve performance ?

Re: Adding nodes will improve performance ?

Re: x sRe: Issue: Create HBASE table on Hive

Re: x sRe: Issue: Create HBASE table on Hive

Issue: Create HBASE table on Hive

Spark : CANNOT FIND ADDRESS

Re: Impala ODBC not returning data when WITH claus...

Adding nodes will improve performance ?

Impala ODBC not returning data when WITH clause in...