Based on the error it does seem that the principal already exists. I would have the AD admin look in that OU to confirm that the user is not there. ... View more

That database exists. User is able to use that database and also manually verified that in the metastore. ... View more

Terry - Are you using Ambari Wizard for kerberizing the cluster? If so, passwords are randomly generated. Here are the pointers to code that does it - Password is generated here - https://github.com/hortonworks/ambari/blob/d4edf4619c1c0bb309920ba86e66012a2a2e7090/ambari-server/src/main/java/org/apache/ambari/server/security/SecurePasswordHelper.java#L123-L190 The above function is called from here - https://github.com/hortonworks/ambari/blob/d4edf4619c1c0bb309920ba86e66012a2a2e7090/ambari-server/src/main/java/org/apache/ambari/server/serveraction/kerberos/CreatePrincipalsServerAction.java#L150 And then passed to this method for creating principal in KDC / AD - https://github.com/hortonworks/ambari/blob/8967ed9bc8967f6f6783c16f6403a3de0a0b2792/ambari-server/src/main/java/org/apache/ambari/server/serveraction/kerberos/ADKerberosOperationHandler.java#L241 ... View more

Can you tell if both these env using same KDC server? DistCP (which is what is used by Falcon for data replication) supports copying data between two kerberos environments so its a matter of making sure that the clusters can communicate correctly. ... View more

Hey Chakra - You need to provide the Java class name for "Database Driver Class NameInfo" and not the jar file path. The jar file path goes in Database Driver Jar UrlInfo. ... View more

Thanks David, for some reason the 3rd statement to alter the table to rename it fails with following error message - metastore.RetryingHMSHandler (RetryingHMSHandler.java:invoke(159)) - InvalidOperationException(message:Unable to change partition or table. Database th_ti_hit_src does not exist Check metastore logs for detailed stack.junk_th) at org.apache.hadoop.hive.metastore.HiveAlterHandler.alterTable(HiveAlterHandler.java:253) Looks like we will have to clean the table up manually from metastore and then delete the partitions manually. ... View more

How about - ConvertCSVToAvro - & then - ConvertAvroToJSON ? Alternatively, You can use ExtractText with regex to convert CSV to JSON. ... View more

Thanks David, will try that and let you know how it goes. ... View more

Also, Since the DROP table command just hangs, what will be a good work around to completely removing this table and partitions? ... View more