yes, I have restored the tables using the backup I have taken before I stopped old PostgreSQL(8.4). reinitializing it with option 4 solved the issue. Thank you. ... View more

@vinay kumar Very late to answer but this may help others.Can you please post where you stand with your cluster now? Is it advisable to have Ambari server and name-node on the same node? Ambari being a administration tool is recommended to be on Edge node(if you configure one). Even if we handle the name-node disaster using HA enabled for name-node. As Ambari don't have HA. How do we handle the situation, if a node with Ambari server install go down ? While you work on restoring Ambari service,the individual services grouped into Ambari are accessible with their corresponding port numbers. Is it advisable to have a edge node ? What are the advantages of having it ? Edge node is usually neglected in design discussion but it is recommended to have as -it ensures less load/resource competition to name node as client applications & admin tools are usually configured to run here. -They act as a staging area during data transfers in & out of cluster. Can edge node have different OS than the cluster OS ? I think that its not possible to have edge node with different version of OS as the clients need to installed in it. But the situation is that, we are using Red hat 7 for cluster and we want to use HUE. Hue being incompatible with Red hat 7, only option we can think of is, having an edge node with Cent-OS 6 and installing hue in it. Is there any other way to achieve this ? Edge nodes usually have different H/W requirements than master/slave nodes so I think it can be done(I'm not sure) ... View more

For the Hue example, you have to create a Hue user in AD and then create a keytab file for Hue. This is where I am stuck. How do you create the keytab file for the Hue user? ... View more

@Robert Levas Thanks Robert. Regarding this Question How does Kerberos work?, could you please answer it here. ... View more

@Kuldeep Kulkarni Add "deploy JCE policies" steps as prerequisites. I tried without JCE and it fails for me. Let me know if i am missing anything. ... View more

Symptom Not able to use reflect function using beeline, but the query works OK with Hvi CLI. Error Message: Error while compiling statement: FAILED: SemanticException UDF reflect is not allowed (state=42000,code=40000) Cause When running set hive.server2.builtin.udf.blacklist from beeline, it will return the following as blacklisted: jdbc:hive2://localhost:10000/default> set hive.server2.builtin.udf.blacklist; +------------------------------------------------------------------+--+ | set | +------------------------------------------------------------------+--+ | hive.server2.builtin.udf.blacklist=reflect,reflect2,java_method | +------------------------------------------------------------------+--+ Reflect UDF is blacklisted by default when running queries through HiveServer2 (beeline, ODBC, JDBC connections), as it was found to be a security risk. The code was modified so if the parameter hive.server2.builtin.udf.blacklist has not been configured or it is blank, its default value will be "reflect,reflect2,java_method". Resolution 1. Open the Ambari UI 2. Add the custom property in Ambari hive.server2.builtin.udf.blacklist under Hive / Configs / Advanced / Custom hive-site and give it any value, for example "empty_blacklist". 3. Restart services as requested by Ambari. 4. Connect again with beeline and verify that blacklist only includes the dummy value now. 0: jdbc:hive2://localhost:10000/default> set hive.server2.builtin.udf.blacklist; +-------------------------------------------+--+ | hive.server2.builtin.udf.blacklist=empty_blacklist | +-------------------------------------------+--+ 5. Reflect should work now without issues. ... View more

Hi @vinay kumar, I think your partitioning is wrong you are not using "/" for hdfs directory. If you want use full disk capacity, you can create any folder name under "/" example /data/1 on every data node using command "#mkdir -p /data/1" and add to it dfs.datanode.data.dir. restart the hdfs service. You should get the desired output. ... View more

how to increase it for no vm please @Neeraj Sabharwal ... View more