width_bucket function Invalid when using Hive connector

KNIME Analytics Platform
1

Hi all,

In my former workflow, I got tables from Netezza and I used the width_bucket() function in Database Query. It works fine. Currently I'm getting table from Hive, and running the query gives the following error:

ERROR Database Query       0:338      Execute failed: Error while compiling statement: FAILED: SemanticException [Error 10011]: Line 2:1 Invalid function 'width_bucket'

 

Is there any way that can perform the same function as width_bucket() ? 

 

Thank you so much for your help.

2

Hi codyy,

I guess the width_bucket function is not supported in Hive. Maybe the NTILE function might (help? https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions101.htm)

Hope that helps,

Best,

Vincenzo