Connect Impala and Import data from it

apoc
jdbc
cypher
import
knowledge-base

(12kunal34) #1

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

let's suppose i have the data for connection string as below

impalaurl:21050=xyz.com
authmech=;AuthMech=1;
KrbRealm=HADOOP.abc.COM
KrbHostFQDN=ashasdjhjkfh.com
KrbServiceName=impala
UseNativeQuery=1

what would be the connection string for CALL apoc.load.jdbc ??

if i am using myDatabase as a database and myTable as a table , what would be thefinal cypher using apoc ??

i tried below Url

CALL apoc.load.jdbc("jdbc:impala://internal-edl-impala-qual-1334063328.us-west-2.elb.nvbn.com:21050/my_db;AuthMech=1;KrbRealm=HADOOP.xyz.COM;KrbHostFQDN=sdfsdhcvsdh;KrbServiceName=impala",'SELECT * FROM my_Db.my_Table') YIELD row
RETURN row.my_column

then getting bekow error

Neo.ClientError.Procedure.ProcedureCallFailed: Failed to invoke procedure `apoc.load.jdbc`: Caused by: javax.security.auth.login.LoginException: Unable to obtain Principal Name for authentication 

could you please let me know , what is wrong here .

Thanks in advance


(12kunal34) #2

Do we need to add some login.conf or any other file for this ???
please suggest