Uploaded image for project: 'Help-Desk'
  1. Help-Desk
  2. HELP-3579

FIWARE.Request.Tech.Data.BigData-Analysis.HiveTableNotFound

    Details

    • Type: extRequest
    • Status: Closed
    • Priority: Major
    • Resolution: Done
    • Fix Version/s: 2021
    • Component/s: FIWARE-TECH-HELP
    • Labels:
      None
    • HD-Chapter:
      Data
    • HD-Enabler:
      Cosmos

      Description

      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

      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@lists.fi-ware.org
      https://lists.fi-ware.org/listinfo/fiware-lab-help

        Activity

        fla Fernando Lopez made changes -
        Fix Version/s 2021 [ 12600 ]
        mev Manuel Escriche made changes -
        HD-Enabler Cosmos [ 10872 ]
        HD-Chapter Data [ 10838 ]
        mev Manuel Escriche made changes -
        Summary FIWARE.Request.Lab.Data.BigData-Analysis.HiveTableNotFound FIWARE.Request.Tech.Data.BigData-Analysis.HiveTableNotFound
        frb Francisco Romero made changes -
        Resolution Done [ 10000 ]
        Status Answered [ 10104 ] Closed [ 6 ]
        frb Francisco Romero made changes -
        Summary [Fiware-lab-help] COSMOS - Query returned non-zero code - Table not found... FIWARE.Request.Lab.Data.BigData-Analysis.HiveTableNotFound
        frb Francisco Romero made changes -
        Status In Progress [ 3 ] Answered [ 10104 ]
        frb Francisco Romero made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        mev Manuel Escriche made changes -
        Assignee Francisco Romero [ frb ]
        mev Manuel Escriche made changes -
        Field Original Value New Value
        Component/s FIWARE-TECH-HELP [ 10278 ]
        pandriani Pasquale Andriani created issue -

          People

          • Assignee:
            frb Francisco Romero
            Reporter:
            pandriani Pasquale Andriani
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: