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 .

CURRENT SUBMISSIONS✦ @svignesh.8397Outbreak Analysis✦ @ramrajArt Provenance Agent✦ @serah.elrashidiGraphImmune Trust Agent✦ @anudhyandatta2021MovieGraph Agent✦ @sadashivbAthlete Nutrition Intelligence✦ @agung_sidharta_gungzSybil-Hunter Fraud Agent✦ @bhattacharya.ananya0OSS Sentinel✦ @abimael.carrasquilloJibarito Agent✦ @leongkwokhingTabletopGameRecommender✦ @strawberrychewyMental Health Assistant✦ @bruno.henrique.britoNeoSmith✦ @kitushenoyLifeGraph✦ @neerajchormale39GymBuddy✦ @neeraj42888Movie Graph Agent✦ @martynscnNaijaHealth✦ @rishabhprsd7Wortgraph Coach✦ @Rodrigo-TenorioChess Analytics Assistant✦ @priyagijainIPL Cricket Intelligence Agent✦ @joslatMarketMind✦ @ayushdeosinghHostLens AI✦ @hellopriyanshu4FraudGraph Sentinel✦ @winleexzCPF Customer Agent✦ @vinod.nageshwarGeospatial Supply Chain Agent✦ @jakub.kierznowskiiiDrugPath✦ @kumar20051020shivamVibeGraph AI✦ @wanga.15065M-Pesa (Kenya) Insight Agent✦ @epiphanyanEarnings Call Graph Analyst✦ @tarunnarang1992ReviewGraph AI✦ @violet.ols.devRecallScope Agent✦ @shrikantbhadaneAura-Health-Bot✦ @mabu.mateApple HealthGraph Agent✦ @ochiengokumu482VAT-TaxGraph AI✦ @mahanteshimathFinSight✦ @prashant7090Detect Cyber Attack✦ @jonas.koennerConspiracyGraph Agent✦ @deanfouldsJapan Seismic Risk Intelligence Graph✦ @jevlachovKorca Triage Agent✦ @shantanunitw01CineGraph AI✦ @dhiraj.patraRegulatoryRisk GraphAgent✦ @venkatasaiprasadpDepGraph Agent✦ Submissions are now closed

Learn graphs.
Score for your country.

Represent your country in the GraphAcademy Cup.
Complete courses, earn points, and win weekly prizes.

🏆 Join the Cup 📊 Final 16

GROUP STAGE • WEEK 3 ENDS IN

00 DAYS

00 HRS

00 MIN

00 SEC

Neo4j Online Community

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	3712	January 9, 2019
Connect Impala and Import data from it Import / Export apoc , jdbc , cypher , import , knowledge-base	1	1238	December 4, 2018
Data import from EDL 1.0 to Neo4j Import / Export	12	1630	November 6, 2018
How to connect jdbc impala/hive/cloudera to neo4j with karberos Desktop apoc , browser , cypher	0	297	May 19, 2022
Unable to connect RDBMS with Neo4j using JDBC Procedures & APOC apoc , cypher , import	3	282	March 22, 2023

Take the Course Then Join The Aura Agent Hackathon

Load data from impala to neo4j

Related topics

Take the Course Then Join
The Aura Agent Hackathon