Hi Pasquale,

This issue is fixed by prepending the default database to the table name. I.e. If you query was "select * from mytable...", then the query must be now "select * from default.mytable...". After last week reboot, this is necessary, we are investigating why. Sorry for the inconveniences.

Regards,
Francisco

De: Pasquale Andriani <pasquale.andriani@eng.it<pasquale.andriani@eng.it>>
Fecha: martes, 14 de julio de 2015, 23:31
Para: "fiware-lab-help@lists.fi-ware.org<fiware-lab-help@lists.fi-ware.org>" <fiware-lab-help@lists.fi-ware.org<fiware-lab-help@lists.fi-ware.org>>, Francisco Romero Bueno <francisco.romerobueno@telefonica.com<francisco.romerobueno@telefonica.com>>
CC: Massimiliano Nigrelli <massimiliano.nigrelli@eng.it<massimiliano.nigrelli@eng.it>>, Pellegrino Dario <dario.pellegrino@eng.it<dario.pellegrino@eng.it>>, Leandro Lombardo <Leandro.Lombardo@eng.it<Leandro.Lombardo@eng.it>>
Asunto: COSMOS - Query returned non-zero code - Table not found...

Dear Francisco,
in FINESCE WP4 we have been facing several issues on COSMOS instance.
Randomly when executing a query the following message is returned:

SEVERE: HIVE Loading Data Error
java.sql.SQLException: Query returned non-zero code: 10, cause: FAILED: Error in semantic analysis: Line 1:14 Table not found 'terni_meterdetail'

It often happens also with all the other existing tables.

What's wrong?

Kind regards,
P.

Pasquale Andriani
Direzione Ricerca e Innovazione - Research & Development Lab
pasquale.andriani@eng.it<pasquale.andriani@eng.it>

Engineering Ingegneria Informatica spa
Via Riccardo Morandi, 32 - 00148 Roma
Tel. +39-06.87594138
Mob. +39 3924698746
Fax. +39-06.83074408
www.eng.it<http://www.eng.it>

Hi Pasquale,

This issue is fixed by prepending the default database to the table name.
I.e. If you query was ³select * from mytableŠ², then the query must be now
³select * from default.mytableŠ². After last week reboot, this is
necessary, we are investigating why. Sorry for the inconveniences.

Regards,
Francisco

El 15/7/15 7:21, "Manuel Escriche (JIRA)" <jira-help-desk@fi-ware.org>

________________________________

Este mensaje y sus adjuntos se dirigen exclusivamente a su destinatario, puede contener información privilegiada o confidencial y es para uso exclusivo de la persona o entidad de destino. Si no es usted. el destinatario indicado, queda notificado de que la lectura, utilización, divulgación y/o copia sin autorización puede estar prohibida en virtud de la legislación vigente. Si ha recibido este mensaje por error, le rogamos que nos lo comunique inmediatamente por esta misma vía y proceda a su destrucción.

The information contained in this transmission is privileged and confidential information intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this transmission in error, do not read it. Please immediately reply to the sender that you have received this communication in error and then delete it.

Esta mensagem e seus anexos se dirigem exclusivamente ao seu destinatário, pode conter informação privilegiada ou confidencial e é para uso exclusivo da pessoa ou entidade de destino. Se não é vossa senhoria o destinatário indicado, fica notificado de que a leitura, utilização, divulgação e/ou cópia sem autorização pode estar proibida em virtude da legislação vigente. Se recebeu esta mensagem por erro, rogamos-lhe que nos o comunique imediatamente por esta mesma via e proceda a sua destruição
_______________________________________________
Fiware-tech-help mailing list
Fiware-tech-help@lists.fi-ware.org
https://lists.fi-ware.org/listinfo/fiware-tech-help

Closing since no more feedback has been received (assuming it was finally fixed).