1 Reply Latest reply on Oct 23, 2018 12:55 AM by JAUMIER Sébastien

    Profiling a hive table failed

    JAUMIER Sébastien Active Member

      When profiling a Hive table using Informatica Analyst or Developper, profiling is empty.

       

      The log file shows the following error :

       

      [LDTM_0072] RR_4035 SQL Error [

      FnName: Prepare -- [unixODBC][Hortonworks][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: ParseException line 1:7 cannot recognize input near '[' 'pe001cpe_gesphy' ']' in select clause].

       

      I use an ODBC Driver to connect to Hive Table.

      When I use Hive table in a mapping, I can run the data viewer and execute the mapping without problem.

       

      Is there something particular to do for profiling a hive table ?

       

      Thanks for your help !

       

      Sébastien