[Fiware-tech-help] Retrieving data from Cosmos Hive system problem

[Aggelos Groumas]

Hello,

i am providing technical support for FRACTALS accelator project, i am
forwarding an issue i received about Cosmos GEi

---------------
we have following problem with Cosmos Hive. Every SQL query we made on
database table in hive system returns Exception (only query that passes
without exception is "SELECT * FROM TABLE").
Tables are created based on files in Cosmos, created by Cygnus.

An example of Exception for query:

"SELECT * FROM SENSOR_1_1_1 ORDER BY recvTime DESC"

we are getting following exception:

-----
Task ID:
  task_201507101501_18238_m_000000

URL:

http://cosmosmaster-gi:50030/taskdetails.jsp?jobid=job_201507101501_18238&tipi

   d=task_201507101501_18238_m_000000
-----
Diagnostic Messages for this Task:
java.lang.RuntimeException: Error in configuring object
        at
org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.jav

         a:93)
        at
org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:6

         4)
        at
org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.ja

         va:117)
        at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:386)
        at org.apache.hadoop.mapred.MapTask.run(MapTask.java:324)
        at org.apache.hadoop.mapred.Child$4.run(Child.java:266)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:396)
        at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInforma

         tion.java:1278)
        at org.apache.hadoop.mapred.Child.main(Child.java:260)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

         java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

         sorImpl.jav

FAILED: Execution Error, return code 2 from
org.apache.hadoop.hive.ql.exec.mr.MapRedTask
<http://org.apache.hadoop.hive.ql.exec.mr.mapredtask/>

Can you, please, provide us a support for this issue.
----------------------

BR,
Aggelos
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20151020/df0c3d6a/attachment.html>