DataStax Help Center

Importing into hive causes "InvalidRequestException" on password enabled cluster



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


The following error will be seen in the terminal

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


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


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



Configure your import.options file appropriately:

--connect jdbc:oracle:thin:@//
--username DATASTAX
--password password
--table NPA_NXX
--split-by NPA_NXX_KEY
--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


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


Powered by Zendesk