Hive connection: org.apache.hadoop.hive.ql.parse.SemanticException: UDF java_method is not allowed

Completed

When I connect to hive, I am getting the following error...

Hive2 (port): ATL HDP via Knox
org.apache.hadoop.hive.ql.parse.SemanticException: UDF java_method is not allowed

Which results in a failure to import database schemas.

Is there a handling for this issue?

0
7 comments

What DataGrip version do you use?

0

DataGrip 2018.3.2
Build #DB-183.5429.24, built on January 22, 2019
JRE: 1.8.0_152-release-1343-b26 x86_64
JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.o
Mac OS X 10.11.6

0

Tried the EAP 2019.1 of DataGrip.

I still get the error if I use the option (introspect using JDBC metadata).

Deleted: ** When I turn that option off, I don't get the error, but, I only get a partial reverse eng of the Schemas. Only 2 over 30 tables are processed. **

Actually: I get all of tables. I was not getting all of them due to an authorization issue.

Never the less, I am getting good results with the EAP (given turning off: Introspect using JDBC metadata.

Thanks!

0

Yes, "I still get the error if I use the option " is liked it worked before :)

So please try everything with this option turned off and if any issues please report to https://youtrack.jetbrains.com/issues/DBE

0

@Dsidlo

Could you try to invoke the following sequence?

  1. Create a  new data source for Hive
  2. Make sure you turned off `Introspect using JDBC metadata
  3. Try to synchronize

If there are any errors or missing objects - let us know.

0

EAP 2019.1 of DataGrip works.

Just needed to turn off `Introspect using JDBC metadata`

 

Thanks!

1

Please sign in to leave a comment.