DataStax Help Center

Importing into hive causes "InvalidRequestException" on password enabled cluster

 

Summary

When importing from an external DB into DSE hive, if the cluster has internal authentication set, an "InvalidRequestException" error may be seen

Symptoms

The following error will be seen in the terminal

15/01/30 13:48:04 ERROR security.UserGroupInformation: PriviledgedActionException as:pricadmn cause:java.io.IOException: InvalidRequestException(why:You have not logged in) 15/01/30 13:48:04 ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: InvalidRequestException(why:You have not logged in)

Cause

There is a known issue outlined in DSP-4722 which at the time of writing this article is not yet fixed.

Workaround

The user may add the following lines into the hive-site.xml file:

<property>
<name>cassandra.username</name>
<value>cassandra</value>
</property>

<property>
<name>cassandra.password</name>
<value>cassandra</value>
</property>

Configure your import.options file appropriately:

import
-Dcassandra.username=cassandra
-Dcassandra.password=cassandra
--connect jdbc:oracle:thin:@//192.168.56.26:1521/XE
--username DATASTAX
--password password
--verbose
--table NPA_NXX
--split-by NPA_NXX_KEY
--hive-import
--hive-overwrite
--hive-table npa_nxx.npa_nxx_data1

Run the import:

 /usr/bin/dse sqoop --options-file /home/datastax/import.options.hive

<...truncated output...>

Loading data to table npa_nxx.npa_nxx_data1

Table npa_nxx.npa_nxx_data1 stats: [num_partitions: 0, num_files: 5, num_rows: 0, total_size: 111, raw_data_size: 0]

OK Time taken: 0.434 seconds

Solution

At the time of writing this article, the solution to DSP-4722 is still outstanding

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk