I want to port the following SQL statement to Hive from Sybase. What is the best approach to get the below to work in Hive? Hive DML UPDATE syntax doesn't mention support for JOINs or nested SELECT statements. UPDATE table1 SET table1.column1 = table2.column1, table1.column10 = table2.column10 FROM table1, table2 WHERE table1.columnID = table2.columnID After enabling transactional=true on table1 the above produces an error: Error while compiling statement: FAILED: ParseException ... missing EOF at 'FROM' ... ... View more

I'd like Ambari to execute a service check for all installed components that are not in maintenance mode. I couldn't find such an option in the UI so I tried the REST API. I ran the below command and got back an "Accepted" status, but when I look in Ambari UI for a list of executed background operations I only see a single service check when I expected two service checks. curl -v -u $LOGIN:$PASSWORD -H "X-Requested-By:X-Requested-By" -X POST "http://$AMBARI_HOST:8080/api/v1/clusters/$cluster_name/requests" --data '[ {"RequestInfo":{"context":"HIVE Service Check","command":"HIVE_SERVICE_CHECK"},"Requests/resource_filters":[{"service_name":"HIVE"}]}, {"RequestInfo":{"context":"MAPREDUCE2 Service Check","command":"MAPREDUCE2_SERVICE_CHECK"},"Requests/resource_filters":[{"service_name":"MAPREDUCE2"}]} ]' ... View more

I stopped a running process in NiFi 0.4.1 to make a configuration change, but I am unable to make an edit or re-start the process. It seem stuck waiting for a thread to finish. How do I debug this situation? I've looked at nifi-app.log, searched for that process name, but did not see anything of value. I ran ps -eLf hoping to see a thread with Solr in the name, but I didn't find that either. Here is a picture showing the lack of a "start" or "edit configuration" options. What else can I do to troubleshoot this problem before restarting the nifi process on this machine? ... View more

I am trying to enable Kerberos on an HDP 2.3.2 Sandbox using FreeIPA on a standalone VM. After stopping all of the HDP services the Kerberos wizard has a "prepare" task and that task is failing with this error message: 13 Jan 2016 04:56:25,610 WARN [Server Action Executor Worker 495] ServerActionExecutor:479 - Task #495 failed to complete execution due to thrown exception: java.lang.IllegalArgumentException:Attempted to add a rule for a principal with no realm: ambari-qa java.lang.IllegalArgumentException: Attempted to add a rule for a principal with no realm: ambari-qa at org.apache.ambari.server.controller.AuthToLocalBuilder.addRule(AuthToLocalBuilder.java:147) at org.apache.ambari.server.controller.KerberosHelperImpl.addIdentities(KerberosHelperImpl.java:1671) at org.apache.ambari.server.controller.KerberosHelperImpl.setAuthToLocalRules(KerberosHelperImpl.java:403) at org.apache.ambari.server.serveraction.kerberos.PrepareKerberosIdentitiesServerAction.processAuthToLocalRules(PrepareKerberosIdentitiesServerAction.java:177) at org.apache.ambari.server.serveraction.kerberos.PrepareEnableKerberosServerAction.execute(PrepareEnableKerberosServerAction.java:82) at org.apache.ambari.server.serveraction.ServerActionExecutor$Worker.execute(ServerActionExecutor.java:537) at org.apache.ambari.server.serveraction.ServerActionExecutor$Worker.run(ServerActionExecutor.java:474) at java.lang.Thread.run(Thread.java:745) ambari-qa was not mentioned in the CSV file that the wizard generated, but after seeing the above error I created a service for it, but I'm still getting the same error. Added service "ambari-qa/sandbox.hortonworks.com@HORTONWORKS.COM" ----------------------------------------------------------------- Principal: ambari-qa/sandbox.hortonworks.com@HORTONWORKS.COM Managed by: sandbox.hortonworks.com What does the error message mean and what can I do to resolve it? ... View more