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 at fi-ware.org> escribió: > > [ >https://jira.fiware.org/browse/HELP-3579?page=com.atlassian.jira.plugin.sy >stem.issuetabpanels:all-tabpanel ] > >Manuel Escriche reassigned HELP-3579: >------------------------------------- > > Assignee: Francisco Romero > >> [Fiware-lab-help] COSMOS - Query returned non-zero code - Table not >>found... >> >>------------------------------------------------------------------------- >>--- >> >> Key: HELP-3579 >> URL: https://jira.fiware.org/browse/HELP-3579 >> Project: Help-Desk >> Issue Type: extRequest >> Components: FIWARE-TECH-HELP >> Reporter: Pasquale Andriani >> Assignee: Francisco Romero >> >> 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 at 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 >> _______________________________________________ >> Fiware-lab-help mailing list >> Fiware-lab-help at lists.fi-ware.org >> https://lists.fi-ware.org/listinfo/fiware-lab-help > > > >-- >This message was sent by Atlassian JIRA >(v6.4.1#64016) ________________________________ 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
You can get more information about our cookies and privacy policies clicking on the following links: Privacy policy Cookies policy