Hi @suno bella, edge node refers to a dedicated node (machine) where no Hadoop services are running, and where you install only so-called Hadoop clients (hdfs, Hive, HBase etc. clients). In your case your BI tool will also play a role of a Hadoop client. A client means that only respective component client libraries and scripts will be installed, together with its config files. If you change config through Ambari, then Ambari will automatically refresh config files on the edge node as well. In a small, test cluster without an edge node you can select one node where Hadoop services are running (for example, a master node) to play a role of your edge node. (In a large cluster with many users there are usually multiple edge nodes.) As the "edge node folder" you can use any folder on the edge node you decide to use. Hope this helps. ... View more

Hi @Przemysław Rząd, It looks like Ambari is not running. Can you try to login into your instance and run /root/start_ambari.sh script. Or you can try to restart your instance, Ambari is supposed to start on instance startup. ... View more

Hi @Adi Jabkowsky, the balancer is running in the background and it's slow by design. No need to worry. You can keep on using the cluster, running jobs, etc. Increasing the balancer bandwidth to 100M/s is good, and running from command line instead from Ambari is also a good choice. To have a better sense of completion, and better insight into required time, you can run next time first with 20% threshold and then run again reducing it to 15% and 10%. ... View more

Are you using an existing Mysql DB? This often happens when the Hive DB user doesn't have privileges to access Hive DB from another host. If you let Ambari install and create new Hive DB then Ambari will set them. You can inspect your current users and give privileges using following commands (assuming your Hive user is called 'hive'): SELECT User,Host FROM mysql.user; SHOW GRANTS FOR 'hive'@'%'; -- Possibly returns nothing GRANT ALL PRIVILEGES ON hive.* TO 'hive'@'%'; The last command will solve all your troubles, but you can also replace '%' with the host name of the node where Hive Metastore is running. ... View more

Hi @John Garrigan, your specs are a little imprecise, but can you try this: select count(distinct Z) from t1 where locate(Y, X)>0; -- for example: select count(distinct Z) from t1 where locate("Java", X)>0; Note that, as stated, your condition on "Y^" (usually expressed as "Y*") is superfluous, since if Y is there then any superstring of Y will be there too. ... View more

@Mohamed Ashiq, If your topics look like above (old ones refer to brokers 0,1,2,... and new ones to 1001, 1002, ...) then the solution is to visit meta.properties files on each disk of each broker and edit "broker.id" property, changing it from 1001, 1002, ... to 0, 1, 2, ... ... View more