# Load data from impala to neo4j **URL:** \ **Category:** Import / Export\ **Tags:** apoc, cypher\ **Created:** [November 19, 2018, 9:29am UTC](https://community.neo4j.com/t/load-data-from-impala-to-neo4j/3093 "2018-11-19T09:29:10Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![12kunal34](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/12kunal34/32/2617_2.png) [@12kunal34](https://community.neo4j.com/u/12kunal34)\ **Post date:** [November 19, 2018, 9:29am UTC](https://community.neo4j.com/t/load-data-from-impala-to-neo4j/3093/1 "2018-11-19T09:29:10Z")
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 but i dont know how to use it. i had a look into APOC document as well but no clear understanding for me please help Thanks in advance. ---
**Author:** ![Benoit](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/benoit/32/551_2.png) [@Benoit](https://community.neo4j.com/u/Benoit)\ **Post date:** [November 19, 2018, 10:01am UTC](https://community.neo4j.com/t/load-data-from-impala-to-neo4j/3093/2 "2018-11-19T10:01:03Z")
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("jdbc:impala://MY_SERVER_IP:PORT/MY_DB","SELECT * FROM table" YIELD row ...` ---
**Author:** ![12kunal34](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/12kunal34/32/2617_2.png) [@12kunal34](https://community.neo4j.com/u/12kunal34)\ **Post date:** [November 19, 2018, 11:25am UTC](https://community.neo4j.com/t/load-data-from-impala-to-neo4j/3093/3 "2018-11-19T11:25:37Z")
Hi Benoit, thanks for your reply. may i know please from where i can download this driver ?? is it opensource ?? ---
**Author:** ![Benoit](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/benoit/32/551_2.png) [@Benoit](https://community.neo4j.com/u/Benoit)\ **Post date:** [November 19, 2018, 11:29am UTC](https://community.neo4j.com/t/load-data-from-impala-to-neo4j/3093/4 "2018-11-19T11:29:43Z")
Here : [Download Impala JDBC Connector 2.6.4 | Cloudera](https://www.cloudera.com/downloads/connectors/impala/jdbc/2-6-4.html) ---
**Author:** ![12kunal34](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/12kunal34/32/2617_2.png) [@12kunal34](https://community.neo4j.com/u/12kunal34)\ **Post date:** [November 19, 2018, 2:34pm UTC](https://community.neo4j.com/t/load-data-from-impala-to-neo4j/3093/5 "2018-11-19T14:34:39Z")
Hi Benoit, i tried as you suggested but getting below error. ```auto 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 ```auto CALL apoc.load.jdbc("jdbc:impala://internal-edl-dev-ifgfgh-2.elb.amazbgff.com:21050/publish_test","SELECT * FROM student") YIELD row RETURN row ``` please help me in this ---
**Author:** ![Benoit](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/benoit/32/551_2.png) [@Benoit](https://community.neo4j.com/u/Benoit)\ **Post date:** [November 19, 2018, 3:36pm UTC](https://community.neo4j.com/t/load-data-from-impala-to-neo4j/3093/6 "2018-11-19T15:36:41Z")
Can you download this version of the driver instead : [Download Impala JDBC Connector 2.5.43](https://www.cloudera.com/downloads/connectors/impala/jdbc/2-5-45.html) ---
**Author:** ![12kunal34](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/12kunal34/32/2617_2.png) [@12kunal34](https://community.neo4j.com/u/12kunal34)\ **Post date:** [November 19, 2018, 6:50pm UTC](https://community.neo4j.com/t/load-data-from-impala-to-neo4j/3093/7 "2018-11-19T18:50:51Z")
Is this because of impala driver ?? Do we need more jars for this like thrift,metastore, hive service ,http client etc ?? ---
**Author:** ![12kunal34](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/12kunal34/32/2617_2.png) [@12kunal34](https://community.neo4j.com/u/12kunal34)\ **Post date:** [November 20, 2018, 6:08am UTC](https://community.neo4j.com/t/load-data-from-impala-to-neo4j/3093/8 "2018-11-20T06:08:15Z")
Hey Benoit, Getting below error now ☹ ```auto 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 ---
**Author:** ![Benoit](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/benoit/32/551_2.png) [@Benoit](https://community.neo4j.com/u/Benoit)\ **Post date:** [November 20, 2018, 9:33am UTC](https://community.neo4j.com/t/load-data-from-impala-to-neo4j/3093/9 "2018-11-20T09:33:50Z")
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. ---
**Author:** ![12kunal34](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/12kunal34/32/2617_2.png) [@12kunal34](https://community.neo4j.com/u/12kunal34)\ **Post date:** [November 20, 2018, 10:26am UTC](https://community.neo4j.com/t/load-data-from-impala-to-neo4j/3093/10 "2018-11-20T10:26:57Z")
@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 . ---
**Author:** ![12kunal34](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/12kunal34/32/2617_2.png) [@12kunal34](https://community.neo4j.com/u/12kunal34)\ **Post date:** [November 21, 2018, 4:15am UTC](https://community.neo4j.com/t/load-data-from-impala-to-neo4j/3093/11 "2018-11-21T04:15:51Z")
Hi @stefan.armbruster @andrew_bowman @michael.hunger Couuld you please help me in above issue i need this for mu POC.