Member since
β06-13-2019
14
Posts
2
Kudos Received
0
Solutions
β08-16-2017
11:55 AM
@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
β08-16-2017
11:32 AM
@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
β08-16-2017
10:31 AM
@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
β08-16-2017
09:51 AM
@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
β08-16-2017
07:27 AM
I'm not completely sure If you asked me for this. I hope so.
... View more
β08-16-2017
07:19 AM
@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
β08-16-2017
07:05 AM
I'm using Virtual Box, and I installed it in the default path established when installing. I don't know what do I have to look for in the host file
... View more
β08-14-2017
12:54 PM
@Geoffrey Shelton Okot I think it will be a problem with the proxy, because the parameters are well-setted, and Hive is up and working. If this is not the cause, maybe the version of the sandbox can be the reason (I have the latest one).
... View more
β08-14-2017
12:35 PM
2 Kudos
I need to create a table with just a field, which is a map of string: string. I have created the table without problems, but when I try to insert the values (they are defined, not in another table) I am not able to achieve it. The code is below. create table comunidades ( codigo MAP<STRING, STRING> );
INSERT INTO TABLE comunidades SELECT 1, {"AND": '01'};
... View more
- Tags:
- Data Processing
- Hive
Labels:
- Labels:
-
Apache Hive
β08-14-2017
11:35 AM
@Geoffrey Shelton Okot I'm getting the same error. I have followed the steps for W8 (because of the similarity between 8 and 10), but it still keeps failing.
... View more
β08-14-2017
10:29 AM
@Geoffrey Shelton Okot That link contains an incorrect URI, which has changed, and it isn't able to me to fix that error.
... View more
β08-14-2017
10:06 AM
I have followed the steps on the Installing and configuring the Hortonworks ODBC driver on Windows 7 guide, but using Windows 10. After setting the parameters to the values specified in the PDF, I try to test the configuration and I get the following error: FAILED!
[Hortonworks][Hardy] (34) Error from server: connect() failed: errno = 10060. I donΒ΄t know the reason why I am getting this message, could it be an effect of the company proxy?
... View more
Labels:
- Labels:
-
Apache Hive