thiverow component can't execute UDTF functions like lateral view explode(split(<column>,<seperator>)) and throws syntax error

[mitulvyas]

Dear Team,

I have been trying to execute a query which uses the UDTF function as below:

lateral view explode(split(<column>,<seperator>))

This query works fine on Hive Editor. However, the same query throws an error (stating syntax error), while running inside thiverow component.

Can you please advise the solution?

Please provide the resolution at the earliest.

P.S.:

I'm using Talend Real-Time Big Data Enterprise Platform v 6.4.1.

I have been using basic connection settings for hive connection, consisting of Login-Password, etc. and have not specified any Hive / Hadoop specific properties.

Regards,

Mitul Vyas

[Anonymous]

Hello,

It seems to be a new feature and we don't find any related UDFT jira issue on talend bug tracker.

Could you please create a new one?

Best regards

Sabrina