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 !
If someone have the same problem :
In the ODBC.ini file, I changed the UseNativeQuery Property from 1 to 0 and my profiling is OK.
The driver is also used with Powercenter and some requests take a very long time with the property on 0.
We have to use two different drivers if we want to make profiling with Analyst and mapping with PWC...