Yes, it's the better way to solve problems 🙂 ... View more

@Geoffrey Shelton Okot The table was filled in the previous actions, but the Ambari platform throws me the specified error above. Now I would need to specify the values into file ruiz.txt as proper key-value pairs, and not inserting null after the file rows. I'll look how to do it. Thank you very much for your patience ... View more

@Geoffrey Shelton Okot Yes I know about putty, but it is possible to do also from Ambari. I will try to do it from putty. The version of the sandbox is 2.6.1 for VirtualBox. It's available here: https://es.hortonworks.com/downloads/#sandbox ... View more

@Geoffrey Shelton Okot In Ambari I have no terminal client, I upload files through a visual interface and the permissions for the file and folder are all enabled. I though the same, a problem with the permissions, but not. I don't know if the Sandbox is limited in some Hive operations ... View more

@Geoffrey Shelton Okot I have repeated your steps in Ambari and it throws me an error (below). I have checked the community entries and it's something repeated. I don't know if there is a solution yet for this issue. java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask ... View more

@Jagruti Varia I've just tried your command and it returns an error. I'm using the Hortonworks Sandbox, and I don't understand why it throws that error. org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:52 Failed to recognize predicate '<EOF>'. Failed rule: 'regularBody' in statement ... View more