Member since
05-08-2019
8
Posts
0
Kudos Received
0
Solutions
05-09-2019
02:46 PM
I know MS stands for Microsoft here. What I am asking is that if I need to request the DBA to take the conf file from us and put it somewhere in the server
... View more
05-09-2019
12:42 PM
@Geoffrey Shelton Okot What do you mean exactly when you say MS SQL server is not in the same Kerberos domain?
... View more
05-09-2019
12:40 PM
@Geoffrey Shelton Okot sqoop import -Dmapred.job.queue.name=fabpops_q1 --connect "jdbc:jtds:sqlserver://XXXXXXXXXXXX;useNTLMv2=true;domain=ms;databaseName=XXXXXX;username=XXXXXXX;password=XXXXXX;encrypt=true;trustServerCertificate=false;trustStore=/mssql.jks" --null-string '' --null-non-string '' --fields-terminated-by --m "1" --query "SELECT * FROM table_name a where \$CONDITIONS" --target-dir XXXXXX
... View more
05-09-2019
11:46 AM
@Geoffrey Shelton Okot I am also using' useNTLMv2=true;domain=ms' options in my sqoop command
... View more
05-09-2019
11:38 AM
@Geoffrey Shelton Okot Please read my latest comment.
... View more
05-09-2019
11:36 AM
Afterwards I tried the third line in the post from the link you gave. It went fine. But the sqoop command which I used gave me an exception 'Error executing statement: java.sql.SQLException: I/O Error: GSS Failed: Invalid name provided (Mechanism level: KrbException: Cannot locate default realm)' even though I modified my sqoop command the same way mentioned in that post. can you help?
... View more
05-09-2019
10:43 AM
When I tried the first line in the mentioned link, it started asking me personal details like :What is your first and last name? What is the name of your organizational unit?What is the name of your City or Locality? I felt uncomfortable answering these. It felt like a phishing attempt to me. Can you comment on this?
... View more
05-08-2019
10:00 PM
Labels:
- Labels:
-
Apache Hadoop
-
Apache Sqoop