Hive exception: UDFArgumentTypeException No argument is expected, argumentexpected

Hive exception: UDFArgumentTypeException No argument is expected, argumentexpected

Background:

Run hivesql in a market today. SQL is normal and there is no problem in data warehouse execution.

However, after running in a market, the system always promptsUDFArgumentTypeException No argument is expectedIt hurts a lot.

Specifically, this SQL involves row_number (), regexp_replace, and other functions.

Analysis:

After SQL segmentation troubleshooting, an error is reported only when the row_number () function is used.

It can be determined that if a udf has a problem, this exception will be reported: UDFArgumentTypeException No argument is expected

Solution:

Reload available udf packages.

Upload the udf package to the bastion host (for example, the path is add jar/home/dd_sdm/udf/RowNumberUDF1.jar)

Hive> add jar/home/dd_sdm/udf/RowNumberUDF1.jar;

Hive> create temporary function row_number as 'com. example. hive. udf. rownumberudf ';

Hive> your hivesql

The above experiences are for reference.