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

Highlighted
Six Stars

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

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

Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Studio Improvements for API Services

Take a look at the Talend Studio improvements for API Services

Watch Now