Hey Everyone, i need some help in importing the data from impala to neo4j . i have credentials of impala and i want my data in neo4j i am using below impala jdbc driver ImpalaJDBC:2-5-45 And my cypher is CALL apoc.load.jdbc("jdbc:impala://internal-edl-dev-ifgfgh-2.elb.amazbgff.com:21050/publis…

The stacktrace indicates that the issue is on Impala side and not on Neo4j/APOC. Take a look at https://www.cloudera.com/documentation/other/connectors/impala-jdbc/latest/Cloudera-JDBC-Driver-for-Impala-Install-Guide.pdf - there's documentation how to pass in optional properties to the connect strin…

To figure out the reason I've recommended to increase logging. My glass bowl is kind of dirty, so I cannot take a guess.

Hi Stefan, i am kind of new in these stuff. could you please help me in to this . could you please tell me the steps for this

Make sure that the neo4j server can see the impala server on that port (e.g. check with netcat). And check your aws security rules for ports. Otherwise please do what Stefan suggested and share the extra logs from impala/the driver if they contain additional information.

@michael.hunger could you please guide me that from where i can get these extra logs ?

Read the pdf document I've mentioned above.

Hi @stefan.armbruster i went through the doc and got the section about logging i am using below query for this CALL apoc.load.jdbc("jdbc:impala://internal-edl-impala-qual-1334063328.us-west-2.elb.amazonaws.com:21050/my_Db;LogLevel=6;LogPath=/var/lib;",'SELECT * FROM my_Db.mt_table') YIELD row RET…

Perhaps you have to add authentication?

Hey @stefan.armbruster @michael.hunger i ahve added kerberos authetication on server and now when i am running below query CALL apoc.load.jdbc("jdbc:impala://internal-edl-impala-qual-1334063328.us-west-2.elb.amazonaws.com:21050/my_db;AuthMech=1;KrbRealm=HADOOP.xyz.COM;KrbHostFQDN=sdfsdhcvsdh;KrbSe…

Connect impala with neo4j and compatible impala jdbc driver

Neo4j Graph Platform Procedures & APOC

12kunal34 (Kunal Goyal) November 22, 2018, 8:57am 3

my impala is running on different cluster and neo4j is running on different cluster .
is that can be the problem ??

Topic		Replies	Views
Load data from impala to neo4j Import / Export apoc , cypher	10	2469	November 21, 2018
Connect Impala and Import data from it Import / Export apoc , jdbc , cypher , import , knowledge-base	1	1234	December 4, 2018
How to connect jdbc impala/hive/cloudera to neo4j with karberos Desktop apoc , browser , cypher	0	296	May 19, 2022
Error:While connecting neo4j with Kerberos Procedures & APOC apoc , jdbc , operations , load	0	1199	December 4, 2018
Data import from EDL 1.0 to Neo4j Import / Export	12	1624	November 6, 2018

Connect impala with neo4j and compatible impala jdbc driver

Related topics