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

mitulvyas — Sat, 16 Nov 2024 04:43:01 GMT

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

Re: thiverow component can't execute UDTF functions like lateral view explode(split(,)) and throws syntax error

Anonymous — Thu, 12 Sep 2019 08:09:02 GMT

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

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

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

Re: thiverow component can't execute UDTF functions like lateral view explode(split(,)) and throws syntax error