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 . could you all please help me and tell me the steps how i can do it. i have millions of records in my tables and i know there is a apoc procedure apoc.load.jdbc b…

Hi, Firstly you need to put the JDBC driver of impala into the plugin directory of Neo4j, and restart it. Then, register the driver in neo4j with this query : CALL apoc.load.driver("com.cloudera.impala.jdbc41.Driver"); And now you can use the apoc JDNC procedure like that : CALL apoc.load.jdbc…

Hi Benoit, thanks for your reply. may i know please from where i can download this driver ?? is it opensource ??

Here : Download Impala JDBC Connector 2.6.4 | Cloudera

Hi Benoit, i tried as you suggested but getting below error. Neo.ClientError.Procedure.ProcedureCallFailed: Failed to invoke procedure `apoc.load.jdbc`: Caused by: java.lang.ClassNotFoundException: org.apache.hive.service.cli.thrift.TCLIService$Client i am using below query CALL apoc.load.jdbc(…

Can you download this version of the driver instead : Download Impala JDBC Connector 2.5.43

Is this because of impala driver ?? Do we need more jars for this like thrift,metastore, hive service ,http client etc ??

Hey Benoit, Getting below error now :frowning: Neo.ClientError.Procedure.ProcedureCallFailed: Failed to invoke procedure `apoc.load.jdbc`: Caused by: org.apache.thrift.transport.TTransportException one more question where i need to set my username and password for impala ?? please help me

Yes it seems that the JDBC jar requires some additionals libraries ... byt I have found any trace of that in the cloudera documentation .... But the version 2.5.45 includes a lot of jars ... that's why I have asked you to try it.

@Benoit , i ahve added all these jars from this version after adding these jar my error messages is as in above comment. could you please let me know what am i missing here .

Load data from impala to neo4j

Neo4j Graph Platform Import / Export

12kunal34 (Kunal Goyal) November 21, 2018, 4:15am 11

Hi @stefan.armbruster @andrew_bowman @michael.hunger

Couuld you please help me in above issue
i need this for mu POC.

Create dynamic Json with neo4j path nodes

Topic		Replies	Views
Connect impala with neo4j and compatible impala jdbc driver Procedures & APOC apoc , cypher , import , java-driver	14	3735	January 9, 2019
Connect Impala and Import data from it Import / Export apoc , jdbc , cypher , import , knowledge-base	1	1245	December 4, 2018
Data import from EDL 1.0 to Neo4j Import / Export	12	1651	November 6, 2018
How to connect jdbc impala/hive/cloudera to neo4j with karberos Desktop apoc , browser , cypher	0	303	May 19, 2022
Unable to connect RDBMS with Neo4j using JDBC Procedures & APOC apoc , cypher , import	3	286	March 22, 2023

Load data from impala to neo4j

Related topics