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?
Please sign in to leave a comment.
What DataGrip version do you use?
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
Please, try an EAP build with Hive support: https://www.jetbrains.com/datagrip/nextversion/
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!
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
@Dsidlo
Could you try to invoke the following sequence?
If there are any errors or missing objects - let us know.
EAP 2019.1 of DataGrip works.
Just needed to turn off `Introspect using JDBC metadata`
Thanks!